P_PurgMatlPriceChg1

Material Price Change 1 | view: PMMMATLPRC1 | Extraction: Not supported | Component: Reporting

Tables used: EKKO, EKPO, EKBE, EKBEH, T163B

🔑 Keys (7)
💰 Amounts (5)
∑ Quantities (5)
📅 Dates (2)
☰ Categorical (4)
Other (4)
🔗 Relations (16)

Column Name	Description
PurchaseOrder FK	Purchase Order Number
PurchaseOrderItem FK	Item Number of Purchase Order
AccountAssignmentNumber	Sequential Number of Account Assignment
PurchaseOrderTransactionType	Transaction/event type, purchase order history	Show values
MaterialDocumentYear	Material Document Year
MaterialDocument	Number of Material Document
MaterialDocumentItem	Item in Material Document

Column Name	Description
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
NetAmount	Net Order Value in PO Currency
PurchaseOrderAmount	Invoice Value Entered (in Local Currency)
PurOrdAmountInCompanyCodeCrcy	Amount in Local Currency
InvoiceAmountInDocCurrency	null

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity	Purchase Order Quantity
Quantity	Quantity
QtyInPurchaseOrderPriceUnit	Quantity in purchase order price unit
QuantityInBaseUnit	Quantity
QtyInPurchaseOrderPricUnit	null

Column Name	Description
PostingDate	Posting Date in the Document
PurchaseOrderDate	Purchase Order Date

Column Name	Description
PurchaseOrderTransactionType	Transaction/event type, purchase order history	Show values
DebitCreditCode	Debit/Credit Indicator	Show values
IsReturnsItem	Returns Item	Show values
MultipleAcctAssgmtDistribution	Distribution Indicator for Multiple Account Assignment	Show values

Column Name	Description	Domain name
ProductType	Product Type Group	CHAR2
NetPriceQuantity	Price Unit	DEC5
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ

Master Data Relations	Join Conditions
Account Assignment Category Client Account Assignment Category	`P_PURGMATLPRICECHG1.MANDT == T163K.MANDT` `P_PURGMATLPRICECHG1.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP`
Base Unit of Measure Client Base Unit of Measure	`P_PURGMATLPRICECHG1.MANDT == T006.MANDT` `P_PURGMATLPRICECHG1.BASEUNIT == T006.MSEHI`
Company Code Client Company Code	`P_PURGMATLPRICECHG1.MANDT == T001.MANDT` `P_PURGMATLPRICECHG1.COMPANYCODE == T001.BUKRS`
Currency Key Client Currency Key Currency Key	`P_PURGMATLPRICECHG1.MANDT == TCURC.MANDT` `P_PURGMATLPRICECHG1.CURRENCY == TCURC.WAERS` `P_PURGMATLPRICECHG1.DOCUMENTCURRENCY == TCURC.WAERS`
Currency Key Client Currency Key Currency Key	`P_PURGMATLPRICECHG1.MANDT == TCURC.MANDT` `P_PURGMATLPRICECHG1.CURRENCY == TCURC.WAERS` `P_PURGMATLPRICECHG1.DOCUMENTCURRENCY == TCURC.WAERS`
Material Number Client Material Number	`P_PURGMATLPRICECHG1.MANDT == MARA.MANDT` `P_PURGMATLPRICECHG1.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`P_PURGMATLPRICECHG1.MANDT == T023.MANDT` `P_PURGMATLPRICECHG1.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Client Order Price Unit (Purchasing)	`P_PURGMATLPRICECHG1.MANDT == T006.MANDT` `P_PURGMATLPRICECHG1.ORDERPRICEUNIT == T006.MSEHI`
Plant Client Plant	`P_PURGMATLPRICECHG1.MANDT == T001W.MANDT` `P_PURGMATLPRICECHG1.PLANT == T001W.WERKS`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`P_PURGMATLPRICECHG1.MANDT == T006.MANDT` `P_PURGMATLPRICECHG1.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Client Purchase Order Type ?	`P_PURGMATLPRICECHG1.MANDT == T161.MANDT` `P_PURGMATLPRICECHG1.PURCHASEORDERTYPE == T161.BSART` `P_PURGMATLPRICECHG1.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Purchasing Group Client	`P_PURGMATLPRICECHG1.PURCHASINGGROUP == T024.EKGRP` `P_PURGMATLPRICECHG1.MANDT == T024.MANDT`
Purchasing organization Client Purchasing organization	`P_PURGMATLPRICECHG1.MANDT == T024E.MANDT` `P_PURGMATLPRICECHG1.PURCHASINGORGANIZATION == T024E.EKORG`
Supplier Client Supplier	`P_PURGMATLPRICECHG1.MANDT == LFA1.MANDT` `P_PURGMATLPRICECHG1.SUPPLIER == LFA1.LIFNR`