C_TimeVariance

DDL: C_TIMEVARIANCE SQL: CMMTIMEVARIANCE Type: view CONSUMPTION

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)

SourceAliasJoin Type
P_TimeVariance1 P_TimeVariance1 from
P_TimeVarianceUpdatedScore UpdatedScore left_outer

Parameters (3)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat
P_DateFunction datefunctionid

Associations (7)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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 IDApp NameTypeDescription
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)

KeyFieldSource TableSource FieldDescription
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]
;