P_CntrlPurContrItemMonitor1

Central Purchase Contract Items | view: PCCTRITEMMNTR1 | Extraction: Not supported | Component: Contract

Tables used: EKPO_DISTR, EKKO, EKPO

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (3)
Other (14)
🔗 Relations (13)

Column Name	Description
CentralPurchaseContract FK	Central Purchase Contract
CentralPurchaseContractItem	Central Purchase Contract Item
DistributionKey	Distribution Number of Central Purchasing Document

Column Name	Description
💲 Currency Key (DocumentCurrency):
ContractNetPriceAmount	Net Price in Purchasing Document (in Document Currency)

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

Column Name	Description
ValidityStartDate	Start of Validity Period
ValidityEndDate	End of Validity Period
PurgDocPriceDate	Date of Price Determination
CreationDate	Creation Date of Purchasing Document

Column Name	Description
PurchasingDocumentCategory	Purchasing Document Category	Show values
ItemDistributionStatus	Distribution Status	Show values
PurgDocChangeRequestStatus	Change Request Status	Show values

Column Name	Description	Domain name
FormattedPurchasingDocItem	null
CntrlPurContrDistributionLevel	null
ProcmtHubPurchasingOrg	Connected Purchasing Organization
LogicalSystem	Logical System	LOGSYS
ProcmtHubCompanyCode	Connected Company Code	BUKRS
ProcmtHubPlant	Connected Plant	WERKS
PurchaseContractValidityStatus	null
NetPriceQuantity	Price Unit	DEC5
ProductType	Product Type Group	CHAR2
PurchasingCentralMaterial	Material of External System	MATNR
ProcmtHubCompanyCodeGroupingID	Grouping ID for Company Codes	MMPUR_D_CC_GROUPING_ID
OrdPriceUnitToOrderUnitDnmntr	Denominator for Conv. of Order Price Unit into Order Unit	UMBSN
OrderPriceUnitToOrderUnitNmrtr	Numerator for Conversion of Order Price Unit into Order Unit	UMBSZ
ChangeRequestNote	Short Text for Fixed Values	DDTEXT

Master Data Relations	Join Conditions
Company Code Company Code Client	`P_CNTRLPURCONTRITEMMONITOR1.COMPANYCODE == T001.BUKRS` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == T001.MANDT`
Currency Key Currency Key Client	`P_CNTRLPURCONTRITEMMONITOR1.DOCUMENTCURRENCY == TCURC.WAERS` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == TCURC.MANDT`
Material Number Material Number Client	`P_CNTRLPURCONTRITEMMONITOR1.MATERIAL == MARA.MATNR` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == MARA.MANDT`
Material Group Client Material Group	`P_CNTRLPURCONTRITEMMONITOR1.MANDT == T023.MANDT` `P_CNTRLPURCONTRITEMMONITOR1.MATERIALGROUP == T023.MATKL`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`P_CNTRLPURCONTRITEMMONITOR1.MANDT == T006.MANDT` `P_CNTRLPURCONTRITEMMONITOR1.ORDERQUANTITYUNIT == T006.MSEHI`
Plant Plant Client	`P_CNTRLPURCONTRITEMMONITOR1.PLANT == T001W.WERKS` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == T001W.MANDT`
Purchasing Group Purchasing Group Purchasing Group Client	`P_CNTRLPURCONTRITEMMONITOR1.PURCHASINGGROUP == T024.EKGRP` `P_CNTRLPURCONTRITEMMONITOR1.PROCMTHUBPURCHASINGGROUP == T024.EKGRP` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == T024.MANDT`
Purchasing Document Type Purchasing Document Category Purchasing Document Type Client	`P_CNTRLPURCONTRITEMMONITOR1.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_CNTRLPURCONTRITEMMONITOR1.PURCHASECONTRACTTYPE == T161.BSART` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == T161.MANDT`
Item category in purchasing document Client Item category in purchasing document	`P_CNTRLPURCONTRITEMMONITOR1.MANDT == T163.MANDT` `P_CNTRLPURCONTRITEMMONITOR1.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP`
Purchasing Group Purchasing Group Purchasing Group Client	`P_CNTRLPURCONTRITEMMONITOR1.PURCHASINGGROUP == T024.EKGRP` `P_CNTRLPURCONTRITEMMONITOR1.PROCMTHUBPURCHASINGGROUP == T024.EKGRP` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`P_CNTRLPURCONTRITEMMONITOR1.PURCHASINGORGANIZATION == T024E.EKORG` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == T024E.MANDT`
Supplier Supplier Client	`P_CNTRLPURCONTRITEMMONITOR1.SUPPLIER == LFA1.LIFNR` `P_CNTRLPURCONTRITEMMONITOR1.MANDT == LFA1.MANDT`