C_SchedProdnProdVersWeek

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_SchedProdnProdVersWeek.
-- 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.

CREATE VIEW C_SchedProdnProdVersWeek AS
SELECT
  _order.SimulationSessionID AS SimulationSessionID,
  _order.OrderID AS OrderID,
  _order.CapacityRequirementItem AS CapacityRequirementItem,
  _order.OrderCategory AS OrderCategory,
  _order.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  _order.CapacityRequirement AS CapacityRequirement,
  _prodvers.Material AS Product,
  _prodvers.Plant AS Plant,
  _prodvers.ProductionVersion AS ProductionVersion,
  _prodvers.ProductionLine AS WorkCenter,
  _calenderdate.CalendarWeek AS CalendarWeek,
  cast(substring(_calenderdate.YearWeek,1,4)as abap.numc(4)) AS CalendarYear,
  _calenderdate.FirstDayOfWeekDate AS FirstDayOfWeekDate,
  dats_add_days( _calenderdate.FirstDayOfWeekDate,6,'FAIL') AS LastDayOfWeekDate,
  _prodvers.ProductionVersionText AS ProductionVersionText,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  _order.Operation AS Operation,
  _order.OperationLatestStartDate AS OperationLatestStartDate,
  _order.OperationLatestEndDate AS OperationLatestEndDate,
  _order.OperationLatestStartTime AS OperationLatestStartTime,
  _order.OperationLatestEndTime AS OperationLatestEndTime,
  _order.LtstSchedldExecStrtDteTme AS LtstSchedldExecStrtDteTme,
  _order.LtstSchedldExecEndDteTme AS LtstSchedldExecEndDteTme,
  _order.SchedldOrdStartDteTme AS SchedldOrdStartDteTme,
  _order.SchedldOrdEndDteTme AS SchedldOrdEndDteTme,
  _order.RemainingCapReqExecutionDurn AS RemainingCapReqExecutionDurn,
  _order.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  cast('' as flag preserving type ) AS OperationIsDispatched,
  fltp_to_dec(0.00 as pph_cfs_sch_remaining_cap) AS RemainingCapacityDurn,
  fltp_to_dec(0.00 as pph_cfs_sch_consumed_cap) AS ConsumedCapacityDurn,
  cast(0 as pph_cfs_sch_criticality_status) AS StatusCriticality,
  cast(0 as pph_cfs_sch_bucket_starttmstmp) AS PlanningBucketStartDateTime,
  cast(0 as pph_cfs_sch_bucket_end_tmstmp) AS PlanningBucketEndDateTime,
  _Uom.UnitOfMeasure AS UnitOfMeasure,
  _Uom.UnitOfMeasure_E AS UnitOfMeasure_E,
  _OrderCategory.OrderCategoryName AS OrderCategoryName,
  _order.BOOExplosionDate AS BOOExplosionDate,
  _order.BOMExplosionDate AS BOMExplosionDate,
  _order.PlndOrderPlannedStartDate AS PlndOrderPlannedStartDate,
  _order.PlndOrderPlannedEndDate AS PlndOrderPlannedEndDate,
  cast('000000000000000' as timestamp) AS OrderOperationEndDateTime,
  cast('000000000000000' as timestamp) AS OrderOperationStartDateTime,
  cast('000000000000000' as timestamp) AS RequirementDateTime,
  case when _WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone is null or _WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone is initial then abap_system_timezone($session.client, 'NULL') when _WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone is not null then _WorkCenter._Plant._StandardOrganizationAddress.AddressTimeZone end as PlantTimeZone AS AddressTimeZoneendasPlantTimeZone
FROM I_ProductionVersion AS _prodvers
INNER JOIN I_WorkCenter AS _WorkCenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_Capacity AS _Capacity ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SchedProdnOperations AS _order ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS _Uom ON _Uom.UnitOfMeasure = 'H'  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _calenderdate ON _calenderdate.CalendarDate >= _prodvers.ValidityStartDate AND _calenderdate.CalendarDate <= _prodvers.ValidityEndDate AND _calenderdate.WeekDay = '7'  -- association [1..*]
LEFT OUTER JOIN C_SchedProdnOrderCategoryVH AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterText AS _WorkCenterText ON WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN I_SOSTypeText AS _SOSTypeText ON _SOSTypeText.SOSType = 'VERID' AND _SOSTypeText.Language = $session.system_language  -- association [1..1]
;