C_TimeVariance
Time Variance
C_TimeVariance is a Consumption CDS View that provides data about "Time Variance" in SAP S/4HANA. It reads from 2 data sources (P_TimeVariance1, P_TimeVarianceUpdatedScore) and exposes 41 fields. It has 7 associations to related views. It is used in 10 Fiori applications: Supplier Evaluation by Quantity, Supplier Evaluation by Quantity (Version 2), Operational Supplier Evaluation, ....
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_TimeVariance1 | P_TimeVariance1 | from |
| P_TimeVarianceUpdatedScore | UpdatedScore | left_outer |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_StartDate | bedat | |
| P_EndDate | bedat | |
| P_DateFunction | datefunctionid |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_CalendarDate | _Calendar | PurchaseOrderDate = _Calendar.CalendarDate |
| [1..1] | C_MM_MaterialGroupValueHelp | _MaterialGroup | $projection.MaterialGroup = _MaterialGroup.MaterialGroup |
| [0..1] | C_MM_SupplierValueHelp | _Supplier | $projection.Supplier = _Supplier.Supplier and $projection.CompanyCode = _Supplier.CompanyCode |
| [1..1] | C_MM_MaterialValueHelp | _Material | $projection.Material = _Material.Material and $projection.Plant = _Material.Plant |
| [0..1] | C_PurchasingGroupValueHelp | _PurchasingGroup | $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup |
| [0..1] | C_PurchasingOrgValueHelp | _PurchasingOrganization | $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization |
| [1..1] | I_Plant | _Plant | $projection.Plant = _Plant.Plant association[1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup association[1..1] to I_PurchasingDocumentCategory as _PurchasingDocumentCategory on $projection.PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMMTIMEVARIANCE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| EndUserText.label | Time Variance | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| OData.publish | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view |
Fiori Apps (10)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F1661 | Supplier Evaluation by Quantity | Analytical | With the Supplier Evaluation by Quantity app, you can determine the quantity variance, which is based on the variance between the ordered quantity and delivered quantity of items. Both the excess and less delivered quantities are considered. |
| F1661A | Supplier Evaluation by Quantity (Version 2) | Analytical | With the Supplier Evaluation by Quantity app, you can determine the quantity variance, which is based on the variance between the ordered quantity and delivered quantity of items. Both the excess and less delivered quantities are considered. |
| F1662 | Operational Supplier Evaluation | Analytical | This app determines the score of a supplier in an organization based on the weighted average of the quantity variance, price variance, and time variance. The score is calculated over a period of 365 days. The overall score is calculated from the variance available from the different criteria, price, time, quantity or soft score after applying the weightage. Both early and late deliveries of items are considered variance. |
| F1663 | Supplier Evaluation by Price | Analytical | With the Supplier Evaluation by Price app, you can determine the score of a given supplier in an organization based on the variance in the price of ordered items and delivered items. The score is calculated over a period of one year and is based on the difference in the purchase order amount and invoice amount. Both the excess and less price are considered as variance. |
| F1664 | Supplier Evaluation by Time | Analytical | ou can use this app to determine the score of a given supplier in an organization based on the difference in time between the ordered date of items and delivered date of items. The score is calculated over a period of 365 days. Both the late and earlier deliveries of items are considered as variance. |
| F2019 | Overall Supplier Evaluation | Analytical | This app determines the score of a supplier in an organization based on the operational and questionnaire scores. The score is calculated over a period of 365 days. It combines scores from the weighted hard facts available from the different criteria (price, time, and quantity), and the soft facts available from questionnaire results. |
| F2234 | Supplier Evaluation by Questionnaire | Analytical | |
| F2234A | Supplier Evaluation by Questionnaire (Version 2) | Analytical | |
| F2309 | Supplier Evaluation by Quality | Analytical | With the Supplier Evaluation by Quality app, you can determine the scores for given suppliers based on the inspection lot. |
| F3295A | Supplier Evaluation By Quality (for Quality Notification) (Version 2) | Analytical |
Supplier Evaluation by Quantity
Business Role: Strategic Buyer
With the Supplier Evaluation by Quantity app, you can determine the quantity variance, which is based on the variance between the ordered quantity and the delivered quantity of items. Both the excess and the lower delivered quantities are considered as variances. The score is determined over the previous year to date. The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22: F_BKPF_BUK M_BEST_WRK M_BEST_EKG M_BEST_EKO The KPI is displayed in the following views: By Supplier By Purchasing Group By Purchasing Organization By Purchasing Category By Material Group By Plant Document Trend by Supplier Trend by Purchasing Category
Key Features: You can perform the following tasks: Apply filters to display views. You can set default values for these filters: Purchasing Organization, Material Group, Plant, and Purchasing Group. To do this, go to User Actions Menu Settings Default Values. For more information, see Maintaining Your Default User Values. Apply filter to display views. Display views as chart and in tabular format. Send the app link as email or export as an excel Personalize tiles: Filter views Click the arrow icon on the screen Choose the Save as Tile option Enter relevant details and saveThe newly created tile displays on the launchpad. Navigate to the following apps: Create Activity Manage Activities Manage Purchase Order Manage Purchasing Category Purchasing Category Factsheet My Purchasing Document Items Supplier Factsheet
Supplier Evaluation by Quantity (Version 2)
Business Role: Strategic Buyer
With the Supplier Evaluation by Quantity app, you can determine the quantity variance, which is based on the variance between the ordered quantity and delivered quantity of items. Both the excess and less delivered quantities are considered. The role Strategic Buyer (SAP_BR_BUYER) is required to access the app. The score is determined over a period of 365 days. The KPI is displayed in the following views: •By Supplier•By Purchasing Group•By Purchasing Organization•By Material Group•Document•Trend
Operational Supplier Evaluation
Business Role: Strategic Buyer
This app determines the score of a supplier in an organization based on the weighted average of the quantity variance, price variance, and time variance. The score is calculated over the previous year to date. The overall score is calculated from the variance available from the different criteria, and then the weighting is applied. For example, price is weighted more than quantity. The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22: F_BKPF_BUK M_BEST_WRK M_BEST_EKG M_BEST_EKO The KPI is displayed in the following views: By Supplier By Purchasing Group By Purchasing Organization By Purchasing Category By Material Group By Plant Document Trend Trend by Supplier Trend by Purchasing Category By Top 10 Suppliers By Bottom 10 Suppliers
Key Features: Using this app, you can do the following: Apply filters to display views. You can set default values for these filters: Purchasing Organization, Material Group, Plant, and Purchasing Group. To do this, go to User Actions Menu Settings Default Values. For more information, see Maintaining Your Default User Values. Analyze data in the form of chart and in tabular format. Share the analysis results via an email or export as an excel. Save the analyzed filters for later reference as a new tile: Filter views Click the arrow icon on the screen Choose the Save as Tile option Enter relevant details and saveThe newly created tile displays on the launchpad. Navigate to the following apps: Manage Purchasing Category Purchasing Category Factsheet My Purchasing Document Items Supplier Factsheet The views are grouped according to the supplier, purchasing group, purchasing organization, purchasing category, material group, document, and trend.
Supplier Evaluation by Price
Business Role: Strategic Buyer
With the Supplier Evaluation by Price app, you can determine the score of a given supplier in an organization based on the variance in the price of ordered items and delivered items. The score is calculated over the previous year to date and is based on the difference in the purchase order amount and invoice amount. Both the excess price and the lower price are considered as variances. The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22: F_BKPF_BUK M_BEST_WRK M_BEST_EKG M_BEST_EKO The KPI is displayed in the following views: By Supplier By Purchasing Group By Purchasing Organization By Purchasing Category By Material Group By Plant Document Trend by Supplier Trend by Purchasing Category
Key Features: You can perform the following tasks: Apply filters to display views. You can set default values for these filters: Purchasing Organization, Material Group, Plant, and Purchasing Group. To do this, go to User Actions Menu Settings Default Values. For more information, see Maintaining Your Default User Values. Apply filter to display views. Display every view as chart and in tabular format. Personalize tiles: Filter views Click the arrow icon on the screen Choose the Save as Tile option Enter relevant details and saveThe newly created tile displays on the launchpad. Navigate to the following apps: Create Activity Manage Activities Manage Purchase Order Manage Purchasing Category Purchasing Category Factsheet My Purchasing Document Items
Supplier Evaluation by Time
Business Role: Strategic Buyer
You can use this app to determine the score of a given supplier in an organization based on the difference in time between the ordered date of items and delivered date of items. The score is calculated over the previous year to date. Both the late and early deliveries of items are considered as variance. You can also see the time variance by delivery date. The catalog role Materials Management - Purchasing Strategy (SAP_BCR_MM_PUR_STRATEGY) is required to access the app. Note that this catalog role is included in the business role Strategic Buyer (SAP_BR_BUYER). The following authorization objects must be maintained in SU22: F_BKPF_BUK M_BEST_WRK M_BEST_EKG M_BEST_EKO The KPI is displayed in the following views: By Supplier By Purchasing Group By Purchasing Organization By Purchasing Category By Material Group By Plant Document Trend by Supplier Trend by Purchasing Organization
Key Features: Using this app, you can do the following: Apply filters to display views. You can set default values for these filters: Purchasing Organization, Material Group, Plant, and Purchasing Group. To do this, go to User Actions Menu Settings Default Values. For more information, see Maintaining Your Default User Values. Apply filter to display views. Analyze data in the form of chart and in tabular format. Share the analysis results via an email or export as an excel. Personalize tiles: Filter views Click the arrow icon on the screen Choose the Save as Tile option Enter relevant details and saveThe newly created tile displays on the launchpad. Navigate to the following apps: Create Activity Manage Activities Manage Purchase Order Manage Purchasing Category Purchasing Category Factsheet My Purchasing Document Items Supplier Factsheet
Fields (41)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| resultElementDateFunctionStartDate | ||||
| resultElementDateFunctionEndDate | ||||
| P_StartDate | ||||
| PurchaseOrderItem | ||||
| ScheduleLine | ScheduleLine | Schedule Line | ||
| DeliveryDate | Delivery Date | |||
| SchedLineStscDeliveryDate | Stat. Del. Date | |||
| PurgDocMigrtnIsCmpltdForAnlyts | PurgDocMigrtnIsCmpltdForAnlyts | |||
| SuplrEvalRelevantDocCategory | SuplrEvalRelevantDocCategory | |||
| PurOrdItmFinalGRPostingDate | PurOrdItmFinalGRPostingDate | |||
| PurOrdItmFirstGRPostingDate | PurOrdItmFirstGRPostingDate | |||
| CalendarYear | _Calendar | CalendarYear | Year | |
| CalendarQuarter | _Calendar | CalendarQuarter | Calendar Quarter | |
| CalendarMonth | _Calendar | CalendarMonth | Calendar Month | |
| CalendarWeek | _Calendar | CalendarWeek | Calendar Week | |
| PurchasingOrganization | SupplierEvalByTime | PurchasingOrganization | Purchasing Organization | |
| PurchasingOrganizationName | ||||
| PurchasingGroup | PurchasingGroup | Purchasing Group | ||
| PurchasingGroupName | ||||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| Supplier | Supplier | Supplier | ||
| SupplierName | ||||
| SupplierCountry | ||||
| CountryName | ||||
| Material | Material | Vehicle Model | ||
| MaterialName | _Material | MaterialName | Material Description | |
| MaterialGroup | SupplierEvalByTime | MaterialGroup | Product Group | |
| MaterialGroupName | _MaterialGroup | MaterialGroupName | prod Grp Desc. | |
| Plant | SupplierEvalByTime | Plant | Valuation Area | |
| PlantName | _Plant | PlantName | Plant Name | |
| PurchasingCategory | ||||
| PurgCatName | ||||
| PurchasingDocumentCategory | PurchasingDocumentCategory | Purchasing Document Category | ||
| PurchasingDocumentCategoryName | ||||
| TimeVarianceInDays | Overdue Days | |||
| TimeVarianceInPct | Stat. Delivery Var | |||
| TimeVarianceInPctByDelivDate | Delivery Date Var | |||
| TimeVarianceScoreByDelivDate | Delivery Date Score | |||
| PurchaseOrderItemUniqueID | PurchaseOrderItemUniqueID | Document Item | ||
| NumberOfPurchaseOrders | ||||
| NumberOfPurchaseOrderItems |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_TimeVariance.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMMTIMEVARIANCE
-- Parameters: P_StartDate : bedat, P_EndDate : bedat, P_DateFunction : datefunctionid
CREATE VIEW C_TimeVariance AS
SELECT
resultElement: 'DateFunctionStartDate' AS resultElementDateFunctionStartDate,
resultElement: 'DateFunctionEndDate' AS resultElementDateFunctionEndDate,
binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS P_StartDate,
cast(SupplierEvalByTime.PurchaseOrderItem as vdm_purchaseorderitem) AS PurchaseOrderItem,
ScheduleLine,
cast( ScheduleLineDeliveryDate as fieu_deliverydate) AS DeliveryDate,
cast( SchedLineStscDeliveryDate as slfdt) AS SchedLineStscDeliveryDate,
PurgDocMigrtnIsCmpltdForAnlyts,
SuplrEvalRelevantDocCategory,
PurOrdItmFinalGRPostingDate,
PurOrdItmFirstGRPostingDate,
_Calendar.CalendarYear AS CalendarYear,
_Calendar.CalendarQuarter AS CalendarQuarter,
_Calendar.CalendarMonth AS CalendarMonth,
_Calendar.CalendarWeek AS CalendarWeek,
SupplierEvalByTime.PurchasingOrganization AS PurchasingOrganization,
cast ( _PurchasingOrganization.PurchasingOrganizationName as mm_a_purg_org_name ) AS PurchasingOrganizationName,
PurchasingGroup,
cast ( _PurchasingGroup.PurchasingGroupName as mm_a_purg_grp_name ) AS PurchasingGroupName,
CompanyCode,
Supplier,
cast ( _Supplier.SupplierName as suppliername ) AS SupplierName,
cast( _Supplier.Country as mm_a_supplier_country ) AS SupplierCountry,
_Supplier._CountryText[1: Language = $session.system_language].CountryName AS CountryName,
Material,
_Material.MaterialName AS MaterialName,
SupplierEvalByTime.MaterialGroup AS MaterialGroup,
_MaterialGroup.MaterialGroupName AS MaterialGroupName,
SupplierEvalByTime.Plant AS Plant,
_Plant.PlantName AS PlantName,
_PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
_PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
PurchasingDocumentCategory,
_PurchasingDocumentCategory._Text[1: Language = $session.system_language].PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
cast ( TimeVarianceInDays as mm_a_overdue_days ) AS TimeVarianceInDays,
cast ( TimeVarianceInPct as mmpur_ana_timevar_statdelivpct ) AS TimeVarianceInPct,
cast( TimeVarianceInPctByDelivDate as mm_a_variance_delivery_pct ) AS TimeVarianceInPctByDelivDate,
cast ( TimeVarianceScoreByDelivDate as mm_a_timevarc_score_deliv_date) AS TimeVarianceScoreByDelivDate,
PurchaseOrderItemUniqueID,
cast( 1 as mm_pur_ana_numbrofpurords ) AS NumberOfPurchaseOrders,
cast( 1 as mm_pur_ana_numbrofpurorditms ) AS NumberOfPurchaseOrderItems
FROM P_TimeVariance1
LEFT OUTER JOIN P_TimeVarianceUpdatedScore AS UpdatedScore ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON PurchaseOrderDate = _Calendar.CalendarDate -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup -- association [1..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _Supplier ON Supplier = _Supplier.Supplier AND CompanyCode = _Supplier.CompanyCode -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _Material ON Material = _Material.Material AND Plant = _Material.Plant -- association [1..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant association[1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup association[1..1] to I_PurchasingDocumentCategory as _PurchasingDocumentCategory on PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory -- association [1..1]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA