CFIN_AV_SO_ITEM - Sales Document: Item Data

Sales Document: Item Data information is stored in SAP table CFIN_AV_SO_ITEM.
It is part of development package FINS_CFIN_ACC_VIEW in software component FI-CF-AVL. This development package consists of objects that can be grouped under "Central Finance - Accounting View".

Fields for table CFIN_AV_SO_ITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE	KEY	X		FINS_CFIN_S_AV_DBKEY	0
AV_DBKEY	Accounting View DB KEY	X	FINS_CFIN_AV_DBKEY	RAW	16
.INCLUDE	HIERACHY			FINS_CFIN_S_AV_HIERACHY	0
AV_PARENTKEY	Accounting View Parent Key		FINS_CFIN_AV_PARENTKEY	RAW	16
AV_ROOTKEY	Accounting View Root Key		FINS_CFIN_AV_ROOTKEY	RAW	16
.INCLUDE	DATA			FINS_CFIN_S_AV_SO_ITEM	0
FINS_LOGSYS	Logical system		LOGSYS	CHAR	20	TBDLS
VBELN	Sales Document		VBELN_VA	CHAR	20
POSNR	Sales Document Item		POSNR_VA	NUMC	12
VGBEL	Document number of the reference document		VGBEL	CHAR	20
VGPOS	Item number of the reference item		VGPOS	NUMC	12
VGTYP	Document Category of Preceding SD Document		VBTYPL_V	CHAR	8
GSBER	Business Area		GSBER	CHAR	8	TGSB
MATNR	Material Number		MATNR	CHAR	80	MARA
PSTYV	Sales document item category		PSTYV	CHAR	8	TVPT
SPART	Division		SPART	CHAR	4	TSPA
WERKS	Plant (Own or External)		WERKS_EXT	CHAR	8
MATKL	Material Group		MATKL	CHAR	18	T023
LGORT	Storage location		LGORT_D	CHAR	8	T001L
PRCTR	Profit Center		PRCTR	CHAR	20
ERDAT	Date on which the record was created		ERDAT	DATS	16
AEDAT	Last Changed On		AEDAT	DATS	16
SHKZG	Returns Item		SHKZG_VA	CHAR	2
VBELV	Originating Document		VBELV	CHAR	20
POSNV	Originating Item		POSNV	NUMC	12
REVACC_REFID	Revenue Accounting: Reference ID		REVACC_REFID	CHAR	60
REVACC_REFTYPE	Revenue Accounting: Reference Type		REVACC_REFTYPE	CHAR	6
KWMENG	Cumulative order quantity in sales units		KWMENG	QUAN	8
UMVKZ	Numerator (factor) for conversion of sales quantity into SKU		UMVKZ	DEC	3
UMVKN	Denominator (divisor) for conversion of sales Qty into SKU		UMVKN	DEC	3
MEINS	Base Unit of Measure		MEINS	UNIT	6	T006
UMZIZ	Factor for Converting Sales Units to Base Units (Target Qty)		UMZIZ	DEC	3
UMZIN	Factor for Converting Sales Units to Base Units (Target Qty)		UMZIN	DEC	3
AUFNR	Order Number		AUFNR	CHAR	24	AUFK
KZVBR	Consumption posting		KZVBR	CHAR	2
FKREL	Relevant for Billing		FKREL	CHAR	2
FIXMG	Delivery Date and Quantity Fixed		FIXMG	CHAR	2
WAERK	SD Document Currency		WAERK	CUKY	10	TCURC
KBMENG	Cumulative Confirmed Quantity in Sales Unit		KBMENG	QUAN	8
VRKME	Sales unit		VRKME	UNIT	6	T006
ABGRU	Reason for Rejection of Sales Documents		ABGRU_VA	CHAR	4	TVAG
KOWRR	Statistical Values		KOWRR	CHAR	2
NETWR	Net Value of the Order Item in Document Currency		NETWR_AP	CURR	8
BRGEW	Gross Weight of the Item		BRGEW_AP	QUAN	8
NTGEW	Net Weight of the Item		NTGEW_AP	QUAN	8
GEWEI	Weight Unit		GEWEI	UNIT	6	T006
VOLUM	Volume of the item		VOLUM_AP	QUAN	8
VOLEH	Volume unit		VOLEH	UNIT	6	T006
ABGRS	Results Analysis Key		ABGR_SCHL	CHAR	12	TKKAA
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
STCUR	Exchange rate for statistics (Exch.rate at time of creation)		STCUR_AP	DEC	5
ERKRS	Operating concern		ERKRS	CHAR	8	TKEB
VGREF	Preceding document has resulted from reference		VGREF	CHAR	2
.INCLUDE				CFAVSOITM_INCL_EEW_PS	0
DUMMY_AVSOITM_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2