CFIN_AVSO_ITEME - CFin Rpld Sales Document Item (API)

CFin Rpld Sales Document Item (API) information is stored in SAP table CFIN_AVSO_ITEME.
It is part of development package FINS_CFIN_ACC_VIEW_EX in software component FI-CF-AVL. This development package consists of objects that can be grouped under "Central Finance - External Interface for Accounting View".

Fields for table CFIN_AVSO_ITEME

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		FINS_CFIN_S_AV_DBKEY	0
AV_DBKEY	Accounting View DB KEY	X	FINS_CFIN_AV_DBKEY	RAW	16
.INCLUDE				FINS_CFIN_S_AV_SO_EX_ITEM_DB	0
SOURCESYSTEMLOGICALSYSTEM	Logical System of the Sender		LOGSYSTEM_SENDER	CHAR	20	*
CFINREPLICATEDSALESDOCUMENT	Central Finance Replicated Sales Document		FINS_CFIN_AV_RPLD_SLS_DOC	CHAR	20
CFINRPLDSALESDOCUMENTITEM	Central Finance Replicated Sales Document Item		FINS_CFIN_AV_RPLD_SLS_DOC_ITEM	NUMC	12
LASTCHANGEDATETIME	Last Changed On		FINS_CFIN_AV_LASTCHANGEDON	DEC	11
REFERENCESDDOCUMENT	Document number of the reference document		VGBEL	CHAR	20
REFERENCESDDOCUMENTITEM	Item number of the reference item		VGPOS	NUMC	12
REFERENCESDDOCUMENTCATEGORY	Document Category of Preceding SD Document		VBTYPL_V	CHAR	8
BUSINESSAREA	Business Area		FIS_RBUSA	CHAR	8	*
MATERIAL	Material Number		MATNR	CHAR	80
SALESORDERITEMCATEGORY	Sales document item category		PSTYV	CHAR	8	*
DIVISION	Division		SPART	CHAR	4
PLANT	Plant		WERKS_D	CHAR	8
MATERIALGROUP	Material Group		MATKL	CHAR	18
STORAGELOCATION	Storage location		LGORT_D	CHAR	8	*
PROFITCENTER	Profit Center		FIS_PRCTR	CHAR	20	*
WBSELEMENTEXTERNALID	Work Breakdown Structure Element (WBS Element) Edited		PS_POSID_EDIT	CHAR	48
CREATIONDATE	Creation Date		FIS_CPDAT	DATS	16
LASTCHANGEDATE	Last Changed On		AEDAT	DATS	16
ISRETURNSITEM	Returns Item		SHKZG_VA	CHAR	2
ORIGINSDDOCUMENT	Originating Document		VBELV	CHAR	20
ORIGINSDDOCUMENTITEM	Originating Item		POSNV	NUMC	12
TARGETQUANTITY	Target Quantity in Sales Units		DZMENG	QUAN	7
TARGETQUANTITYUNIT	Target Quantity UoM		DZIEME	UNIT	6	*
NETAMOUNT	Net Value of the Order Item in Document Currency		NETWR_AP	CURR	8
ORDERID	Order ID		FIS_AUFNR	CHAR	24	*
TRANSACTIONCURRENCY	Transaction Currency		FIS_RWCUR	CUKY	10	*
SALESDOCUMENTRJCNREASON	Reason for Rejection of Sales Documents		ABGRU_VA	CHAR	4	*
.INCLUDE	BUSINESS			FINS_CFIN_S_AV_SO_EX_BIZ_DB	0
PRICINGDATE	Date for Pricing and Exchange Rate		PRSDT	DATS	16
ADDITIONALVALUEDAYS	Additional Value Days		VALTG	NUMC	4
BILLINGDATE	Billing Date		FKDAT	DATS	16
.INCLUDE				CFAVSOITM_INCL_EEW_PS	0
DUMMY_AVSOITM_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
COMPANYCODE	Company Code		BUKRS	CHAR	8