CFIN_AV_CI_ITEM

Billing Document: Item Data | #masterdata | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
AV_DBKEY Accounting View DB KEY
Column Name Description
NETWR Net Value of Billing item in Document Currency
Column Name Description
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
📏 Base Unit of Measure (MEINS):
FKLMG Billing quantity in stock keeping unit
Column Name Description
Column Name Description
SHKZG Returns item Show values
VGTYP Document Category of Preceding SD Document Show values
FAREG Rule in billing plan/invoice plan Show values
Column Name Description Domain name
AV_PARENTKEY Accounting View Parent Key SYSUUID_X16
AV_ROOTKEY Accounting View Root Key SYSUUID_X16
VBELN Billing Document VBELN
POSNR Billing Item POSNR
AUBEL Sales Document VBELN
AUPOS Sales Document Item POSNR
VGBEL Document number of the reference document VBELN
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
KOKRS Controlling Area CACCD
DUMMY_AVCIITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
KOSTL Cost Center KOSTL
PRCTR Profit Center PRCTR
ALAND Country/Region Key LAND1
TXJCD Tax Jurisdiction TXJCD
Master Data Relations Join Conditions
Logical system CFIN_AV_CI_ITEM.FINS_LOGSYS == TBDLS.LOGSYS
Reason for Zero VAT
  • CFIN_AV_CI_ITEM.MANDT == J_1ARFZ.MANDT
  • CFIN_AV_CI_ITEM.J_1ARFZ == J_1ARFZ.J_1ARFZ
Material Number
  • Material Number
  • Client
  • CFIN_AV_CI_ITEM.MATNR == MARA.MATNR
  • CFIN_AV_CI_ITEM.MANDT == MARA.MANDT
Base Unit of Measure
  • CFIN_AV_CI_ITEM.MANDT == T006.MANDT
  • CFIN_AV_CI_ITEM.MEINS == T006.MSEHI
Sales unit
  • CFIN_AV_CI_ITEM.MANDT == T006.MANDT
  • CFIN_AV_CI_ITEM.VRKME == T006.MSEHI
Plant
  • CFIN_AV_CI_ITEM.MANDT == T001W.MANDT
  • CFIN_AV_CI_ITEM.WERKS == T001W.WERKS