C_TimeVarianceQuery

DDL: C_TIMEVARIANCEQUERY SQL: CMMTIMEVARQUERY Type: view CONSUMPTION
43 Fields 1 Data Sources 5 Fiori Apps

Time Variance

C_TimeVarianceQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

C_TimeVarianceQuery is a Consumption CDS View that provides data about "Time Variance" in SAP S/4HANA. It reads from 1 data source (C_TimeVarianceCube) and exposes 43 fields with key field ScheduleLine. It is used in 5 Fiori applications: Supplier Evaluation by Quantity (Version 2), Supplier Evaluation by Price (Version 2), Supplier Evaluation by Time (Version 2), ....

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-ANA
CapabilitiesAnalytical Query
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
C_TimeVarianceCube C_TimeVarianceCube from

Parameters (3)

NameTypeDefault
P_StartDate badat
P_EndDate badat
P_DateFunction datefunctionid

Annotations (16)

NameValueLevelField
EndUserText.label Time Variance view
AbapCatalog.sqlViewName CMMTIMEVARQUERY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Analytics.query true view
OData.publish true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
Metadata.allowExtensions true view

Fiori Apps (5)

App IDApp NameTypeDescription
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.
F1663A Supplier Evaluation by Price (Version 2) 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.
F1664A Supplier Evaluation by Time (Version 2) Analytical You can use this app to determine the score of a given supplier in an organisation 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.
F2309A Supplier Evaluation by Quality (Version 2) 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 (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

Supplier Evaluation by Price (Version 2)

Business Role: Strategic Buyer

This new app is a replacement for the app , which is planned to be deprecated with SAP S/4HANA Cloud 2102. We recommend that you start using this new app instead of the old app Supplier Evaluation by Quality (Deprecated). SAP Fiori ID for this app is F3295A. You can now view number of purchase orders and number of purchase order items with this app.

Supplier Evaluation by Time (Version 2)

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 a period of 365 days. Both the late and earlier deliveries of items are considered as variance. The role Strategic Buyer (SAP_BR_BUYER) is required to access the role. The KPI is displayed in the following views: •By Supplier•By Purchasing Group•By Purchasing Organization•By Material Group•Document•Trend

Supplier Evaluation by Quality (Version 2)

Business Role: Strategic Buyer

This app determines the score of a supplier in an organization based on the weighted average of the quantity, price, and time variances. 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. The role Strategic Buyer (SAP_BR_BUYER) is required to access the app.

Supplier Evaluation By Quality (for Quality Notification) (Version 2)

Business Role: Strategic Buyer

With this app you can evaluate suppliers based on score that is calculated on the basis of quality complaints received. You can identify the suppliers with less received complaint notifications and thus with higher quality evaluation score. This helps you to determine the suppliers with the best performance and reliability. This app can also help you to decide which supplier to select if the purchasing conditions such as quality and price of material, quotation and delivery time are the same.

Fields (43)

KeyFieldSource TableSource FieldDescription
resultElementDateFunctionStartDate
resultElementDateFunctionEndDate
P_StartDate
KEY ScheduleLine ScheduleLine Schedule Line Number
DeliveryDate DeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
OriglPOSchdLnDelivDte OriglPOSchdLnDelivDte Original Delivery Date
OriglPOSchedLineStstclDelivDte OriglPOSchedLineStstclDelivDte Original Statistical Delivery Date
PurOrdItmFinalGRPostingDate PurOrdItmFinalGRPostingDate Final Goods Receipt Date
PurOrdItmFirstGRPostingDate PurOrdItmFirstGRPostingDate First Goods Receipt Date
OriglPurOrdItm1stGRPostgDte OriglPurOrdItm1stGRPostgDte Original First Good Receipt Posting Date
OriglPurOrdItmFnlGRPostgDte OriglPurOrdItmFnlGRPostgDte Original Final Goods Receipt Posting Date
CalendarYear CalendarYear Calendar Year
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarMonth CalendarMonth Calendar Month
CalendarWeek CalendarWeek Calendar Week
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
PurgDocMigrtnIsCmpltdForAnlyts PurgDocMigrtnIsCmpltdForAnlyts Single-Character Flag
SuplrEvalRelevantDocCategory SuplrEvalRelevantDocCategory Supplier Evaluation Configuration for Document Category type
Supplier Supplier Account Number of Supplier
SupplierCountry SupplierCountry Supplier Country/Region
Region Region Region (State, Province, County)
Material Material Material Number
MaterialGroup MaterialGroup Material Group
Plant Plant Valuation Area
PurchasingCategory PurchasingCategory Purchasing Category ID
PurchasingDocumentCategory PurchasingDocumentCategory Purchasing Document Category
PurgCatName PurgCatName Purchasing Category Name (Deprecated)
TimeVarianceInDays TimeVarianceInDays Overdue Days
TimeVarianceInPct TimeVarianceInPct Variance % for Statistical Delivery Date
TimeVarianceInPctByDelivDate TimeVarianceInPctByDelivDate Variance for Delivery Date
TimeVarianceScore TimeVarianceScore Variance Score for Statistical Delivery Date
TimeVarianceScoreByDelivDate TimeVarianceScoreByDelivDate MM_A_TIMEVARC_SCORE_DELIV_DATE
NumberOfScheduleLines NumberOfScheduleLines Number of Purchase Order Items
SuplrEvalTimeVarianceInDays Overdue days
SuplrEvalTimeVarianceInPct Variance % for Statistical Delivery Date
SuplrEvalTmeVarcByDelivDtePct Variance for Delivery Date
SuplrEvalTimeVarianceScoreVal Variance Score for Statistical Delivery Date
SuplrEvalTmeVarcDelivDteScrVal MM_A_TIMEVARC_SCORE_DELIV_DATE
NumberOfPurchaseOrders NumberOfPurchaseOrders Number of Purchase Orders
NumberOfPurchaseOrderItems NumberOfPurchaseOrderItems Number of Purchase Order Items

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_TimeVarianceQuery.
-- 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: CMMTIMEVARQUERY
-- Parameters: P_StartDate : badat, P_EndDate : badat, P_DateFunction : datefunctionid

CREATE VIEW C_TimeVarianceQuery AS
SELECT
  resultElement: 'DateFunctionStartDate' AS resultElementDateFunctionStartDate,
  resultElement: 'DateFunctionEndDate' AS resultElementDateFunctionEndDate,
  binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS P_StartDate,
  ScheduleLine,
  DeliveryDate,
  SchedLineStscDeliveryDate,
  OriglPOSchdLnDelivDte,
  OriglPOSchedLineStstclDelivDte,
  PurOrdItmFinalGRPostingDate,
  PurOrdItmFirstGRPostingDate,
  OriglPurOrdItm1stGRPostgDte,
  OriglPurOrdItmFnlGRPostgDte,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  PurgDocMigrtnIsCmpltdForAnlyts,
  SuplrEvalRelevantDocCategory,
  Supplier,
  SupplierCountry,
  Region,
  Material,
  MaterialGroup,
  Plant,
  PurchasingCategory,
  PurchasingDocumentCategory,
  PurgCatName,
  TimeVarianceInDays,
  TimeVarianceInPct,
  TimeVarianceInPctByDelivDate,
  TimeVarianceScore,
  TimeVarianceScoreByDelivDate,
  NumberOfScheduleLines,
  cast( 1 as mm_a_overdue_days ) AS SuplrEvalTimeVarianceInDays,
  cast( 1 as mmpur_ana_timevar_statdelivpct ) AS SuplrEvalTimeVarianceInPct,
  cast( 1 as mm_a_variance_delivery_pct ) AS SuplrEvalTmeVarcByDelivDtePct,
  cast( 1 as mm_a_timevar_score_statdeliv ) AS SuplrEvalTimeVarianceScoreVal,
  cast( 1 as mm_a_timevarc_score_deliv_date ) AS SuplrEvalTmeVarcDelivDteScrVal,
  NumberOfPurchaseOrders,
  NumberOfPurchaseOrderItems
FROM C_TimeVarianceCube
;

Learn More