CFIN_AV_PO_ITEM

Purchasing Document Item | #transactional | Component: Accounting View of Logistics Information
Column Name Description
MANDT Client
DB_KEY NodeID
Column Name Description
NETPR Net Price in Purchasing Document (in Document Currency)
NETWR Net Order Value in PO Currency
NAVNW Non-deductible input tax
Column Name Description
📏 Purchase Order Unit of Measure (MEINS):
KTMNG Target Quantity
MENGE Purchase Order Quantity
Column Name Description
AEDAT Purchasing Document Item Change Date
Column Name Description
ELIKZ "Delivery Completed" Indicator Show values
EREKZ Final Invoice Indicator Show values
KZVBR Consumption posting Show values
VRTKZ Distribution Indicator for Multiple Account Assignment Show values
TWRKZ Partial invoice indicator Show values
WEPOS Goods Receipt Indicator Show values
WEUNB Goods Receipt, Non-Valuated Show values
REPOS Invoice receipt indicator Show values
WEBRE Indicator: GR-Based Invoice Verification Show values
BSTYP Purchasing Document Category Show values
XOBLR Item affects commitments Show values
STAPO Item is statistical Show values
XERSY Evaluated Receipt Settlement (ERS) Show values
RETPO Returns Item Show values
KZBWS Valuation of Special Stock Show values
LEBRE Indicator for Service-Based Invoice Verification Show values
CCOMP Posting Logic in the Case of Stock Transfers Show values
SRV_BAS_COM Service-Based Commitment Show values
Column Name Description Domain name
PARENT_KEY NodeID /BOBF/CONF_KEY
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
LOEKZ Deletion Indicator in Purchasing Document ELOEK
TXZ01 Short Text TEXT40
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
BPUMN Denominator for Conv. of Order Price Unit into Order Unit UMBSN
UMREZ Numerator for Conversion of Order Unit to Base Unit UMBSZ
UMREN Denominator for Conversion of Order Unit to Base Unit UMBSN
PEINH Price unit DEC5
GEBER Fund BP_GEBER
FISTL Funds Center FISTL
FIPOS Commitment Item FIPOS
KO_PRCTR Profit Center PRCTR
KO_GSBER Business area reported to the partner GSBER
PACKNO Package number PACKNO
GRANT_NBR Grant GM_GRANT_NBR
FKBER Functional Area FKBER
BUDGET_PD Budget Period FM_BUDGET_PERIOD
PRODUCTTYPE Product Type Group CHAR2
AFNAM Name of requisitioner/requester AFNAM
DUMMY_AVPOITM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Order Price Unit (Purchasing)
  • CFIN_AV_PO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_PO_ITEM.BPRME == T006.MSEHI
Company Code
  • CFIN_AV_PO_ITEM.MANDT == T001.MANDT
  • CFIN_AV_PO_ITEM.BUKRS == T001.BUKRS
Valuation Type
  • CFIN_AV_PO_ITEM.MANDT == T149D.MANDT
  • CFIN_AV_PO_ITEM.BWTAR == T149D.BWTAR
Logical system CFIN_AV_PO_ITEM.FINS_LOGSYS == TBDLS.LOGSYS
Account Assignment Category
  • CFIN_AV_PO_ITEM.MANDT == T163K.MANDT
  • CFIN_AV_PO_ITEM.KNTTP == T163K.KNTTP
Base Unit of Measure
  • CFIN_AV_PO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_PO_ITEM.LMEIN == T006.MSEHI
Material Group
  • CFIN_AV_PO_ITEM.MANDT == T023.MANDT
  • CFIN_AV_PO_ITEM.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • CFIN_AV_PO_ITEM.MATNR == MARA.MATNR
  • CFIN_AV_PO_ITEM.MANDT == MARA.MANDT
Purchase Order Unit of Measure
  • CFIN_AV_PO_ITEM.MANDT == T006.MANDT
  • CFIN_AV_PO_ITEM.MEINS == T006.MSEHI
Material type
  • CFIN_AV_PO_ITEM.MANDT == T134.MANDT
  • CFIN_AV_PO_ITEM.MTART == T134.MTART
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • CFIN_AV_PO_ITEM.MANDT == T007A.MANDT
  • CFIN_AV_PO_ITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • CFIN_AV_PO_ITEM.MWSKZ == T007A.MWSKZ
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • CFIN_AV_PO_ITEM.PSTYP == T163.PSTYP
  • CFIN_AV_PO_ITEM.MANDT == T163.MANDT
Special Stock Indicator
  • CFIN_AV_PO_ITEM.MANDT == T148.MANDT
  • CFIN_AV_PO_ITEM.SOBKZ == T148.SOBKZ
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • CFIN_AV_PO_ITEM.MANDT == TTXJ.MANDT
  • CFIN_AV_PO_ITEM.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • CFIN_AV_PO_ITEM.TXJCD == TTXJ.TXJCD
Plant
  • CFIN_AV_PO_ITEM.MANDT == T001W.MANDT
  • CFIN_AV_PO_ITEM.WERKS == T001W.WERKS