P_CntrlPurContractItems

Central Purchase Contract Items | view: PCNTRLCTRITEM | Extraction: Not supported | Component: Contract
Column Name Description
CentralPurchaseContract FK Central Purchase Contract
CentralPurchaseContractItem Central Purchase Contract Item
DistributionKey Distribution Number of Central Purchasing Document
Column Name Description
ContractNetPriceAmount Net Price in Purchasing Document (in Document Currency)
TargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
Column Name Description
ReleaseOrderItemOrderQuantity Release Order Quantity
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingProcessingStatus Purchasing document processing state Show values
ItemDistributionStatus Distribution Status Show values
PurgDocChangeRequestStatus Change Request Status Show values
Column Name Description Domain name
ProcmtHubPurchasingOrg Connected Purchasing Organization
ProcmtHubPurchasingGroup Back-End Purchasing Group EKGRP
ProcmtHubCompanyCode Connected Company Code BUKRS
ProcmtHubPlant Connected Plant WERKS
CreatedByUser User of person who created a purchasing document USNAM
ProductType Product Type Group CHAR2
PurchasingCentralMaterial Material of External System MATNR
ExtContractForPurg Number of principal purchase agreement EBELN
ExtContractItemForPurg Item number of principal purchase agreement EBELP
LogicalSystem Connected System ID
ProcurementHubSourceSystem Connected System ID
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_CNTRLPURCONTRACTITEMS.COMPANYCODE == T001.BUKRS
  • P_CNTRLPURCONTRACTITEMS.MANDT == T001.MANDT
Material Number
  • Material Number
  • Client
  • P_CNTRLPURCONTRACTITEMS.MATERIAL == MARA.MATNR
  • P_CNTRLPURCONTRACTITEMS.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_CNTRLPURCONTRACTITEMS.MATERIALGROUP == T023.MATKL
  • P_CNTRLPURCONTRACTITEMS.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • P_CNTRLPURCONTRACTITEMS.ORDERQUANTITYUNIT == T006.MSEHI
  • P_CNTRLPURCONTRACTITEMS.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • P_CNTRLPURCONTRACTITEMS.PLANT == T001W.WERKS
  • P_CNTRLPURCONTRACTITEMS.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • P_CNTRLPURCONTRACTITEMS.PURCHASECONTRACTTYPE == T161.BSART
  • P_CNTRLPURCONTRACTITEMS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_CNTRLPURCONTRACTITEMS.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • P_CNTRLPURCONTRACTITEMS.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • P_CNTRLPURCONTRACTITEMS.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_CNTRLPURCONTRACTITEMS.PURCHASINGGROUP == T024.EKGRP
  • P_CNTRLPURCONTRACTITEMS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_CNTRLPURCONTRACTITEMS.PURCHASINGORGANIZATION == T024E.EKORG
  • P_CNTRLPURCONTRACTITEMS.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_CNTRLPURCONTRACTITEMS.SUPPLIER == LFA1.LIFNR
  • P_CNTRLPURCONTRACTITEMS.MANDT == LFA1.MANDT