C_PurOrdDelivInvcVal

Purchase Order Delivery Invoice Value | view: CMMPODELINVVAL | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 null (DisplayCurrency):
PurchaseOrderNetAmount Purchase Order Net Amount
GoodsReceiptAmountInDspCrcy Goods Receipt Amount
InvoiceAmtInDisplayCurrency Invoice Amount in Display Currency
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
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
PlantName Plant Name TEXT30
MaterialName Material Description TEXT40
ComparisonPurchasingGroup Comparison Purchasing Group EKGRP
ComparisonPurchasingOrg Comparison Purchasing Organization EKORG
ComparisonMaterialGroup Comparison Material Group MATKL
ComparisonSupplierCountry Comparison Supplier Country/Region LAND1
ComparisonSupplier Comparison Supplier BU_PARTNER
PurchasingSpendRatio null
PurchaseOrderGoodsReceiptRatio null
PurchaseOrderInvoiceRcptRatio null
Master Data Relations Join Conditions
Company Code Currency
  • Company Code Currency
  • Currency Key
  • Client
  • C_PURORDDELIVINVCVAL.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PURORDDELIVINVCVAL.CURRENCY == TCURC.WAERS
  • C_PURORDDELIVINVCVAL.MANDT == TCURC.MANDT
Currency Key
  • Company Code Currency
  • Currency Key
  • Client
  • C_PURORDDELIVINVCVAL.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PURORDDELIVINVCVAL.CURRENCY == TCURC.WAERS
  • C_PURORDDELIVINVCVAL.MANDT == TCURC.MANDT
Material Number
  • Client
  • Material Number
  • C_PURORDDELIVINVCVAL.MANDT == MARA.MANDT
  • C_PURORDDELIVINVCVAL.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURORDDELIVINVCVAL.MANDT == T023.MANDT
  • C_PURORDDELIVINVCVAL.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • C_PURORDDELIVINVCVAL.PLANT == T001W.WERKS
  • C_PURORDDELIVINVCVAL.MANDT == T001W.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURORDDELIVINVCVAL.MANDT == T024.MANDT
  • C_PURORDDELIVINVCVAL.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURORDDELIVINVCVAL.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURORDDELIVINVCVAL.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURORDDELIVINVCVAL.SUPPLIER == LFA1.LIFNR
  • C_PURORDDELIVINVCVAL.MANDT == LFA1.MANDT