FAC_AUDIT_Z3_PURCHASEORDERITEM

Purchase Order Item | view: FAC_PURORDITEM | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: EKKOEKPOFINSC_LD_CMPFINSC_PERIOD
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (DocumentCurrency):
EffectiveAmount Effective value of item
NonDeductibleInputTaxAmount Non-deductible input tax
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
SystemClient Client
IncotermsTransferLocation Incoterms (Part 2) INCO2
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.COMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == TCURC.MANDT
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.DOCUMENTCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.FISCALYEARVARIANT == T009.PERIV
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T009.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == TINC.MANDT
Material Number
  • Material Number
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MATERIAL == MARA.MATNR
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MATERIALGROUP == T023.MATKL
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MATERIALTYPE == T134.MTART
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T134.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T006.MANDT
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.TAXCODE == T007A.MWSKZ
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T007A.MANDT
Valuation Category
  • Valuation Category
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.VALUATIONCATEGORY == T149C.BWTTY
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T149C.MANDT
Valuation Type
  • Valuation Type
  • Client
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.VALUATIONTYPE == T149D.BWTAR
  • FAC_AUDIT_Z3_PURCHASEORDERITEM.MANDT == T149D.MANDT