- 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_TimeVarianceQuery
Time Variance
| view: CMMTIMEVARQUERY
| Extraction:
Not supported
| Component: Reporting
Tables used:
SCAL_TT_DATE, SCAL_TT_YEAR, MATDOC, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKET, MMPUR_ANA_EKET, SEVADJSC, T156, MMPUR_ANA_CONF, SEWS_VAR_SCORE, LFA1, T147, SEWS_CRITERIA_C, SEWS_SWITCH_C
- 🔑 Keys (3)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (4)
- ☰ Categorical (1)
- Other (26)
- 🔗 Relations (4)
| Column Name | Description | |
|---|---|---|
| PurchaseOrder FK | Purchase Order Number | |
| PurchaseOrderItem FK | Item Number of Purchase Order | |
| ScheduleLine | Schedule Line Number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| DeliveryDate | Delivery Date | |
| SchedLineStscDeliveryDate | Statistics-Relevant Delivery Date | |
| PurOrdItmFinalGRPostingDate | Final Goods Receipt Date | |
| PurOrdItmFirstGRPostingDate | First Goods Receipt Date |
| Column Name | Description | |
|---|---|---|
| PurchasingDocumentCategory | Purchasing Document Category | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CalendarYear | Calendar Year | NUM4 | |
| CalendarQuarter | Calendar Quarter | NUM1 | |
| CalendarMonth | Calendar Month | NUM2 | |
| CalendarWeek | Calendar Week | NUM2 | |
| PurchasingOrganization | Purchasing organization | EKORG | |
| PurchasingGroup | Purchasing Group | EKGRP | |
| CompanyCode | Company Code | BUKRS | |
| PurgDocMigrtnIsCmpltdForAnlyts | Single-Character Flag | CHAR1 | |
| Supplier | Account Number of Supplier | LIFNR | |
| Material | Material Number | MATNR | |
| MaterialGroup | Material Group | MATKL | |
| Plant | Plant | WERKS | |
| PurchasingCategory | Purchasing Category ID | /SRMSMC/OBJECT_ID | |
| PurgCatName | Name of Purchasing Category | /SRMSMC/MEDIUM_NAME | |
| TimeVarianceInDays | Overdue days | ||
| TimeVarianceInPct | Variance % for Statistical Delivery Date | ||
| TimeVarianceInPctByDelivDate | Variance for Delivery Date | DEC | |
| TimeVarianceScore | Variance Score for Statistical Delivery Date | ||
| TimeVarianceScoreByDelivDate | MM_A_TIMEVARC_SCORE_DELIV_DATE | ||
| SuplrEvalTimeVarianceInDays | Overdue days | ||
| SuplrEvalTimeVarianceInPct | Variance % for Statistical Delivery Date | ||
| SuplrEvalTmeVarcByDelivDtePct | Variance for Delivery Date | DEC | |
| SuplrEvalTimeVarianceScoreVal | Variance Score for Statistical Delivery Date | ||
| SuplrEvalTmeVarcDelivDteScrVal | MM_A_TIMEVARC_SCORE_DELIV_DATE | ||
| NumberOfPurchaseOrders | Number of Purchase Orders | ||
| NumberOfPurchaseOrderItems | Number of Purchase Order Items |
| Master Data Relations | Join Conditions |
|---|---|
Region (State, Province, County)
| |
Supplier Country/Region
|