P_PURGMATPRICECHGNETPRICE

Price Change Net Price calc | view: PMMMATLPRC3NTPRC | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKPO, EKBE, EKBEH, T163B
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
MaterialDocumentYear Material Document Year
Invoice Invoice Number
MaterialDocumentItem Item in Material Document
Column Name Description
NetAmount Net Order Value in PO Currency
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
💲 Display Currency (DisplayCurrency):
InvoiceAmtInDisplayCurrency Invoice Amount
NetPriceInvoiceAmtInBaseUnit null
Column Name Description
Column Name Description
InvoiceDate Invoice Date in Document
PurchaseOrderDate Purchase Order Date
Column Name Description
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
IsReturnItemValue 2 Byte Signed Integer INT2
NetPriceQuantity Price Unit DEC5
QuantityInBaseUnit null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_PURGMATPRICECHGNETPRICE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_PURGMATPRICECHGNETPRICE.MANDT == T163K.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_PURGMATPRICECHGNETPRICE.BASEUNIT == T006.MSEHI
  • P_PURGMATPRICECHGNETPRICE.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
  • P_PURGMATPRICECHGNETPRICE.COMPANYCODE == T001.BUKRS
  • P_PURGMATPRICECHGNETPRICE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_PURGMATPRICECHGNETPRICE.DOCUMENTCURRENCY == TCURC.WAERS
  • P_PURGMATPRICECHGNETPRICE.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_PURGMATPRICECHGNETPRICE.MATERIAL == MARA.MATNR
  • P_PURGMATPRICECHGNETPRICE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_PURGMATPRICECHGNETPRICE.MATERIALGROUP == T023.MATKL
  • P_PURGMATPRICECHGNETPRICE.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_PURGMATPRICECHGNETPRICE.PLANT == T001W.WERKS
  • P_PURGMATPRICECHGNETPRICE.MANDT == T001W.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_PURGMATPRICECHGNETPRICE.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • P_PURGMATPRICECHGNETPRICE.MANDT == T006.MANDT
Purchase Order Type
  • ?
  • Purchase Order Type
  • Client
  • P_PURGMATPRICECHGNETPRICE.[column in domain "BSTYP"] == T161.BSTYP
  • P_PURGMATPRICECHGNETPRICE.PURCHASEORDERTYPE == T161.BSART
  • P_PURGMATPRICECHGNETPRICE.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURGMATPRICECHGNETPRICE.PURCHASINGGROUP == T024.EKGRP
  • P_PURGMATPRICECHGNETPRICE.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_PURGMATPRICECHGNETPRICE.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURGMATPRICECHGNETPRICE.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURGMATPRICECHGNETPRICE.SUPPLIER == LFA1.LIFNR
  • P_PURGMATPRICECHGNETPRICE.MANDT == LFA1.MANDT