CFIN_AV_SI_ITEM

Supplier Invoice: Item Data | #itemdata | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
AV_DBKEY Accounting View DB KEY
Column Name Description
WRBTR Amount in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (BSTME):
MENGE Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
AV_PARENTKEY Accounting View Parent Key SYSUUID_X16
AV_ROOTKEY Accounting View Root Key SYSUUID_X16
BELNR Document Number of an Invoice Document BELNR
GJAHR Fiscal Year GJAHR
BUZEI Document Item in Invoice Document NUMC6
LIFNR Account Number of Supplier LIFNR
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
LFBNR Document No. of a Reference Document BELNR
LFGJA Fiscal Year of Current Period GJAHR
LFPOS Item of a Reference Document MBLPO
DUMMY_AVSIITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • CFIN_AV_SI_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SI_ITEM.BSTME == T006.MSEHI
Logical system CFIN_AV_SI_ITEM.FINS_LOGSYS == TBDLS.LOGSYS
Material Number
  • Material Number
  • Client
  • CFIN_AV_SI_ITEM.MATNR == MARA.MATNR
  • CFIN_AV_SI_ITEM.MANDT == MARA.MANDT
Base Unit of Measure
  • CFIN_AV_SI_ITEM.MANDT == T006.MANDT
  • CFIN_AV_SI_ITEM.MEINS == T006.MSEHI
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • CFIN_AV_SI_ITEM.MANDT == T007A.MANDT
  • CFIN_AV_SI_ITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • CFIN_AV_SI_ITEM.MWSKZ == T007A.MWSKZ
Plant
  • CFIN_AV_SI_ITEM.MANDT == T001W.MANDT
  • CFIN_AV_SI_ITEM.WERKS == T001W.WERKS