- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- External Services (MM-SRV)
- Information System (MM-IS)
- Inventory Management (MM-IM)
- Invoice Verification (MM-IV)
- Purchasing (MM-PUR)
- Basic Functions (MM-PUR-GF)
- Master Product Specification (MM-PUR-MPS)
- Procurement Hub (MM-PUR-HUB)
- Purchase Orders (MM-PUR-PO)
- Purchase Requisitions (MM-PUR-REQ)
- Purchasing Content (MM-PUR-CNT)
- RFQ/Quotation (MM-PUR-RFQ)
- Self-Service Procurement (MM-PUR-SSP)
- Service Procurement (MM-PUR-SVC)
- Sources of Supply (MM-PUR-SQ)
- Sourcing Project/Quotation (MM-PUR-SPQ)
- Vendor Outline Agreements (MM-PUR-OA)
- Vendor-Material Relationships and Conditions (MM-PUR-VM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_CntrlContrCnsmpnQry
Query view for central contract consumption
| view: CNTRLCONCNSMPNQY
| Extraction:
Not supported
| Component: Contract
Tables used:
SCAL_TT_DATE, EKPO_DISTR, MMPRC_CCTR_RELOR, EKKO, EKPO, MARA, MARA, T023T, T023, MAKT, LFA1, MMPUR_C_BE_SYREG, MMPUR_C_BE_CCREG, MMPUR_C_BE_PLREG, MMPUR_EXT_T024, MMPUR_C_BE_PORGR
| 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 | |
|---|---|---|---|
| SupplierName | Name of Supplier | TEXT80 | |
| ProcmtHubPurchasingOrg | Connected Purchasing Organization | ||
| ProcmtHubPurchasingGroup | Back-End Purchasing Group | EKGRP | |
| ProcmtHubPlant | Connected Plant | WERKS | |
| ProcmtHubCompanyCode | Connected Company Code | BUKRS | |
| MaterialName | Product Description | TEXT40 | |
| MaterialGroupName | Product Group Description | TEXT20 | |
| CalendarYear | Calendar Year | NUM4 | |
| CalendarQuarter | Calendar Quarter | NUM1 | |
| CalendarMonth | Calendar Month | NUM2 | |
| CalendarWeek | Calendar Week | NUM2 | |
| ContractConsumptionRatio | null | ||
| ContractConsumptionInPct | null |
| Master Data Relations | Join Conditions |
|---|---|
Company Code
| |
Material Number
| |
Material Group
| |
Purchase Order Unit of Measure
| |
Plant
| |
Purchasing Document Type
| |
Purchasing Group
| |
Purchasing organization
| |
Supplier
|