P_MaterialPriceVariance

Material Price Variance | view: PMMMATLPRCVAR | Extraction: Not supported | Component: Reporting

Tables used: SCAL_TT_DATE, CDHDR, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, MATDOC_EXTRACT, FMLT_PRICE, CKMLCR, CKMLCR, EKBE, EKBEH, EKKO, EKPO, MARA, FINSC_LEDGER, FINSC_LEDGER_T, MBEWH, T001, T001K, CKMLHD, T001K, T001W, MARA, T163B, EINA, T161, T162, EINE, LFA1, PRPS, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, FINSC_CURTYPE, CKMLHD, CKMLPR, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, CKMLHD, T001K, CKMLHD, MARV, MARV, FINSC_CURTYPET, FINSC_VALSUBTYPT, FINSC_VALUTYPT, CDPOS, FINSC_ACTVE_APPL, /SAPSLL/TUNOS, FMLC_TOGGLE, FMLT_CURTP_ML

🔑 Keys (7)
💰 Amounts (6)
∑ Quantities (2)
📅 Dates (3)
☰ Categorical (2)
Other (11)
🔗 Relations (13)

Column Name	Description
PurchasingDocument FK	Purchasing Document
PurchasingDocumentItem	Item Number of Purchasing Document
ChangeDocument FK	Change Number of Document
MaterialDocumentYear	Fiscal Year
MaterialDocumentItem	Material Document Item
PurchasingInfoRecordCategory	Purchasing info record category	Show values
PurchasingGroup FK	Purchasing Group

Column Name	Description
ReleaseOrderItemNetAmount	Release Net Amount
💲 null (DisplayCurrency):
TargetAmount	Target Amount
InvoiceAmtInDisplayCurrency	Invoice Amount
PurOrdNetAmountInDisplayCrcy	Purchase Order Net Amount
NetPriceAmount	Material Price
NetUnitPriceAmount	Material Net Unit Price

Column Name	Description
OrderQuantity	Purchase Order Quantity
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity	Target Quantity

Column Name	Description
InvoiceDate	Posting Date in the Document
CreationDate	Creation Date of Purchasing Document
DocumentChangeDate	Creation Date of Purchasing Document

Column Name	Description
PurchasingInfoRecordCategory	Purchasing info record category	Show values
PurchasingDocumentType	Object Type	Show values

Column Name	Description	Domain name
FormattedDocumentKey	null
PurchaseContractItem	Item Number of Purchasing Contract	EBELP
PurchaseOrder	Purchase Order Number	EBELN
PurchaseOrderItem	Item Number of Purchase Order	EBELP
Invoice	Invoice Number	TEXT50
PurchasingInfoRecord	Purchasing Info Record	INFNR
NetPriceQuantity	Price Unit	DEC5
NumberOfContractChanges	null
NumberOfPriceChanges	null
NumberOfPurchaseOrders	Number of Purchase Orders
StockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Company Code Company Code Client	`P_MATERIALPRICEVARIANCE.COMPANYCODE == T001.BUKRS` `P_MATERIALPRICEVARIANCE.MANDT == T001.MANDT`
Material Number Material Number Client	`P_MATERIALPRICEVARIANCE.MATERIAL == MARA.MATNR` `P_MATERIALPRICEVARIANCE.MANDT == MARA.MANDT`
Material Group Client Material Group	`P_MATERIALPRICEVARIANCE.MANDT == T023.MANDT` `P_MATERIALPRICEVARIANCE.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`P_MATERIALPRICEVARIANCE.ORDERPRICEUNIT == T006.MSEHI` `P_MATERIALPRICEVARIANCE.MANDT == T006.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`P_MATERIALPRICEVARIANCE.ORDERQUANTITYUNIT == T006.MSEHI` `P_MATERIALPRICEVARIANCE.MANDT == T006.MANDT`
Plant Plant Client	`P_MATERIALPRICEVARIANCE.PLANT == T001W.WERKS` `P_MATERIALPRICEVARIANCE.MANDT == T001W.MANDT`
Purchasing Group Purchasing Group Client	`P_MATERIALPRICEVARIANCE.PURCHASINGGROUP == T024.EKGRP` `P_MATERIALPRICEVARIANCE.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`P_MATERIALPRICEVARIANCE.PURCHASINGORGANIZATION == T024E.EKORG` `P_MATERIALPRICEVARIANCE.MANDT == T024E.MANDT`
Supplier Supplier Client	`P_MATERIALPRICEVARIANCE.SUPPLIER == LFA1.LIFNR` `P_MATERIALPRICEVARIANCE.MANDT == LFA1.MANDT`