C_CntrlContractCnsmpn

Central contract consumption cube view | view: CNTRLCONTRCNSMPN | TRAN | 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
💲 Display Currency (DisplayCurrency):
TargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
ReleaseOrderItemOrderQuantity Release Order Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurgDocChangeRequestStatus Change Request Status Show values
Column Name Description Domain name
ProcmtHubPurchasingOrg Connected Purchasing Organization
ProcmtHubPurchasingGroup Back-End Purchasing Group EKGRP
ProcmtHubPlant Connected Plant WERKS
CompanyCodeName Connected Company Code BUKRS
ProcmtHubCompanyCode Connected Company Code BUKRS
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
ProcmtHubPurchasingGroupName Description of purchasing group TEXT18
ProcmtHubPlantName Plant Name TEXT30
ProcmtHubCompanyCodeName Name of Company Code or Company TEXT25
ProcmtHubPurgOrgName Connected Purchasing Organisation Name
ProcurementHubSourceSystem Connected System ID
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_CNTRLCONTRACTCNSMPN.COMPANYCODE == T001.BUKRS
  • C_CNTRLCONTRACTCNSMPN.MANDT == T001.MANDT
Material Number
  • Client
  • Material Number
  • C_CNTRLCONTRACTCNSMPN.MANDT == MARA.MANDT
  • C_CNTRLCONTRACTCNSMPN.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_CNTRLCONTRACTCNSMPN.MATERIALGROUP == T023.MATKL
  • C_CNTRLCONTRACTCNSMPN.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_CNTRLCONTRACTCNSMPN.ORDERQUANTITYUNIT == T006.MSEHI
  • C_CNTRLCONTRACTCNSMPN.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • C_CNTRLCONTRACTCNSMPN.PLANT == T001W.WERKS
  • C_CNTRLCONTRACTCNSMPN.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_CNTRLCONTRACTCNSMPN.PURCHASECONTRACTTYPE == T161.BSART
  • C_CNTRLCONTRACTCNSMPN.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_CNTRLCONTRACTCNSMPN.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_CNTRLCONTRACTCNSMPN.PURCHASINGGROUP == T024.EKGRP
  • C_CNTRLCONTRACTCNSMPN.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_CNTRLCONTRACTCNSMPN.PURCHASINGORGANIZATION == T024E.EKORG
  • C_CNTRLCONTRACTCNSMPN.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_CNTRLCONTRACTCNSMPN.SUPPLIER == LFA1.LIFNR
  • C_CNTRLCONTRACTCNSMPN.MANDT == LFA1.MANDT