- 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)
- 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_PurchaseOrderSpendQuery
Spend Analysis
| view: CMMPURORDQUERY
| Extraction:
Not supported
| Component: Reporting
Tables used:
SCAL_TT_DATE, /CPD/D_PFP_PH, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, PRTE, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, ADCP, ADRC, TKA01, T005, T005T, MARA, T023, T023T, MAKT, T001W, PROJ, T163B, T024, T024E, T000, LFA1, PRPS, PRPS, PROJ, T161M
- 🔑 Keys (3)
- 💰 Amounts (1)
- ∑ Quantities
- 📅 Dates (1)
- ☰ Categorical
- Other (25)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| PurchaseOrder | Purchase Order Number | |
| PurchaseOrderItem | Item Number of Purchase Order | |
| AccountAssignmentNumber | Sequential Number of Account Assignment |
| Column Name | Description | |
|---|---|---|
| 💲 Display Currency (DisplayCurrency): | ||
| PurOrdNetAmountInDisplayCrcy | Purchase Order Net Amount | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| PurchaseOrderDate | Purchase Order Date |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| PurgCatUUID | Purchasing Category UUID | /BOBF/CONF_KEY | |
| SupplierName | Name of Supplier | TEXT80 | |
| SupplierCountry | Supplier Country/Region | LAND1 | |
| CountryName | Country/Region Name | TEXT50 | |
| CalendarYear | Calendar Year | NUM4 | |
| CalendarQuarter | Calendar Quarter | NUM1 | |
| CalendarMonth | Calendar Month | NUM2 | |
| CalendarWeek | Calendar Week | NUM2 | |
| YearQuarter | Year Quarter | NUM5 | |
| PurchasingOrganizationName | Purchasing Organization Name | TEXT20 | |
| PurchasingGroupName | Purchasing Group Name | TEXT18 | |
| PurchasingDocumentStatus | null | ||
| PurchasingDocumentStatusName | Purchasing Document Status Name | ||
| MaterialName | Material Description | TEXT40 | |
| MaterialGroupName | Product Group Description | TEXT20 | |
| PlantName | Plant Name | TEXT30 | |
| ProductTypeCode | Product Type Group | CHAR2 | |
| ProductType | Product Type | MTART | |
| ServicePerformer | Service Performer | BU_PARTNER | |
| PurchasingCategory | Purchasing Category ID | /SRMSMC/OBJECT_ID | |
| PurgCatName | Name of Purchasing Category | /SRMSMC/MEDIUM_NAME | |
| WBSElementInternalID | Work Breakdown Structure Element (WBS Element) | ||
| WBSElement | Work Breakdown Structure Element (WBS Element) | PS_POSID | |
| WBSDescription | WBS Element Name | TEXT40 | |
| CostCenter | Cost Center | KOSTL |
| Master Data Relations | Join Conditions |
|---|---|
Company Code
| |
Material Number
| |
Material Group
| |
Plant
| |
Purchasing Group
| |
Purchasing organization
| |
Supplier
|