C_TimeVarianceCube

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_TimeVarianceCube.
-- 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: CMMTIMEVARCUBE
-- Parameters: P_StartDate : budat, P_EndDate : budat

CREATE VIEW C_TimeVarianceCube AS
SELECT
  cast( SupplierEvalByTime.PurchaseOrder as vdm_purchaseorder ) AS PurchaseOrder,
  cast(SupplierEvalByTime.PurchaseOrderItem as vdm_purchaseorderitem) AS PurchaseOrderItem,
  ScheduleLine,
  cast( ScheduleLineDeliveryDate as fieu_deliverydate) AS DeliveryDate,
  cast( SchedLineStscDeliveryDate as slfdt) AS SchedLineStscDeliveryDate,
  OriglPOSchdLnDelivDte,
  OriglPOSchedLineStstclDelivDte,
  PurOrdItmFinalGRPostingDate,
  PurOrdItmFirstGRPostingDate,
  OriglPurOrdItm1stGRPostgDte,
  OriglPurOrdItmFnlGRPostgDte,
  PurchaseOrderDate,
  _Calendar.CalendarYear AS CalendarYear,
  _Calendar.CalendarQuarter AS CalendarQuarter,
  _Calendar.CalendarMonth AS CalendarMonth,
  _Calendar.CalendarWeek AS CalendarWeek,
  PurgDocMigrtnIsCmpltdForAnlyts,
  SuplrEvalRelevantDocCategory,
  SupplierEvalByTime.PurchasingOrganization AS PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  _Supplier.Region AS Region,
  cast( _Supplier.Country as mm_a_supplier_country ) AS SupplierCountry,
  Material,
  SupplierEvalByTime.MaterialGroup AS MaterialGroup,
  SupplierEvalByTime.Plant AS Plant,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  PurchasingDocumentCategory,
  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,
  cast( PurchaseOrderItemUniqueID as purchasingdocumentitemuniqueid ) AS PurchaseOrderItemUniqueID,
  cast( 1 as mm_pur_ana_numbrofpurords ) AS NumberOfPurchaseOrders,
  cast( 1 as mm_pur_ana_numbrofpurorditms ) AS NumberOfPurchaseOrderItems,
  cast( 1 as mm_pur_ana_numbrofpurorditms ) AS NumberOfScheduleLines
FROM P_TimeVariance1
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON PurchaseOrderDate = _Calendar.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _MaterialGroup ON MaterialGroup = _MaterialGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization 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_PurgCatMaterialGroupAPI01 as _PurchasingCategoryMatlGroup on MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup association[1..1] to I_PurchasingDocumentCategory as _PurchasingDocumentCategory on PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode association[1..1] to I_Country as _Country on SupplierCountry = _Country.Country association[1..1] to I_PurchasingCategoryValueHelp as _PurchasingCategory on PurchasingCategory = _PurchasingCategory.PurchasingCategory association[1..1] to I_Region as _Region on Region = _Region.Region AND _Region.Country = SupplierCountry  -- association [1..1]
;