C_MonitorSupplierConfirmation

Monitor Supplier Confirmations | view: CSUPCONFOVP | Extraction: Not supported | Component: Reporting

Tables used: /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKET, EKES, T163K, T163I, T001, TKA02, MARA, MAKT, T001W, T024, T024E, T163, T163Y, T001L, LFA1, T163F, T163E, T006, T006A, T163G

🔑 Keys (3)
💰 Amounts (3)
∑ Quantities (2)
📅 Dates (2)
☰ Categorical
Other (8)
🔗 Relations (12)

Column Name	Description
PurchasingDocument FK	Purchasing Document Number
PurchasingDocumentItem	Item Number of Purchasing Document
ScheduleLine	Delivery Schedule Line Counter

Column Name	Description
💲 Display Currency (DisplayCurrency):
NetAmount	Net Order Value in PO Currency
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
ItemPrice	Purchase Order Value

Column Name	Description
📏 Purchase Order Unit of Measure (PurgDocOrderQuantityUnit):
OrderedQuantity	Scheduled Quantity
CommittedQuantity	Committed Quantity

Column Name	Description
ScheduleLineDeliveryDate	Item delivery date
EarliestConfirmationDate	null

Column Name	Description

Column Name	Description	Domain name
FormattedPurchasingDocItem	null
TimeVarianceInDays	null
SupplierName	Name of Supplier	TEXT80
UnitOfMeasureName	Unit of Measurement Text (Maximum 10 Characters)	TEXT10
PurchasingDocumentItemText	Short Text	TEXT40
VarianceCalcDataIsRecorded	null
QuantityVarianceInPct	null
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID

Master Data Relations	Join Conditions
Company Code Company Code Client	`C_MONITORSUPPLIERCONFIRMATION.COMPANYCODE == T001.BUKRS` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T001.MANDT`
Currency Key Client Currency Key	`C_MONITORSUPPLIERCONFIRMATION.MANDT == TCURC.MANDT` `C_MONITORSUPPLIERCONFIRMATION.DOCUMENTCURRENCY == TCURC.WAERS`
Material Number Client Material Number	`C_MONITORSUPPLIERCONFIRMATION.MANDT == MARA.MANDT` `C_MONITORSUPPLIERCONFIRMATION.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_MONITORSUPPLIERCONFIRMATION.MANDT == T023.MANDT` `C_MONITORSUPPLIERCONFIRMATION.MATERIALGROUP == T023.MATKL`
Plant Plant Client	`C_MONITORSUPPLIERCONFIRMATION.PLANT == T001W.WERKS` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T001W.MANDT`
Document Type ? Document Type Client	`C_MONITORSUPPLIERCONFIRMATION.[column in domain "BSTYP"] == T161.BSTYP` `C_MONITORSUPPLIERCONFIRMATION.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`C_MONITORSUPPLIERCONFIRMATION.PURCHASINGGROUP == T024.EKGRP` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`C_MONITORSUPPLIERCONFIRMATION.PURCHASINGORGANIZATION == T024E.EKORG` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T024E.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_MONITORSUPPLIERCONFIRMATION.PURGDOCORDERQUANTITYUNIT == T006.MSEHI` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T006.MANDT`
Supplier Supplier Client	`C_MONITORSUPPLIERCONFIRMATION.SUPPLIER == LFA1.LIFNR` `C_MONITORSUPPLIERCONFIRMATION.MANDT == LFA1.MANDT`
Confirmation Category Confirmation Category Client	`C_MONITORSUPPLIERCONFIRMATION.SUPPLIERCONFIRMATIONCATEGORY == T163E.EBTYP` `C_MONITORSUPPLIERCONFIRMATION.MANDT == T163E.MANDT`