P_PurOrderDeliveryInvoiceValue

Purchase Order Delivery Invoice Value | view: PMMPODELINVVAL | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKBZ, EKBZH, EKBE, EKBEH, ADCP, ADRC, T001, TKA02, T005, T163B, LFA1
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
PurchaseOrderNetAmount null
GoodsReceiptAmountInDspCrcy null
InvoiceAmtInDisplayCurrency null
ComparisonNetAmtInDspCrcy Comparison Net Amount
ComprnGoodsReceiptAmtInDspCrcy Comparison of Goods Receipt Amount
ComprnInvoiceAmtInDspCrcy Comparison of Invoice Amount
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SupplierCountry Country/Region Key LAND1
ComparisonSupplier Comparison Supplier BU_PARTNER
ComparisonPurchasingGroup Comparison Purchasing Group EKGRP
ComparisonMaterialGroup Comparison Material Group MATKL
ComparisonSupplierCountry Comparison Supplier Country/Region LAND1
ComparisonPurchasingOrg Comparison Purchasing Organization EKORG
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == TCURC.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PURORDERDELIVERYINVOICEVALUE.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == TCURC.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PURORDERDELIVERYINVOICEVALUE.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == MARA.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == T023.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == T001W.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.PLANT == T001W.WERKS
Purchase Order Type
  • Client
  • Purchase Order Type
  • ?
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == T161.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.PURCHASEORDERTYPE == T161.BSART
  • P_PURORDERDELIVERYINVOICEVALUE.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == T024.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == T024E.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_PURORDERDELIVERYINVOICEVALUE.MANDT == LFA1.MANDT
  • P_PURORDERDELIVERYINVOICEVALUE.SUPPLIER == LFA1.LIFNR