C_SchedProdnProdVersShift

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_SchedProdnProdVersShift.
-- 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: CSHPDPRDVRSFT

CREATE VIEW C_SchedProdnProdVersShift AS
SELECT
  _order.SimulationSessionID AS SimulationSessionID,
  _order.OrderID AS OrderID,
  _order.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  _order.CapacityRequirementItem AS CapacityRequirementItem,
  _order.OrderCategory AS OrderCategory,
  _order.CapacityRequirement AS CapacityRequirement,
  _prodvers.Material AS Product,
  _prodvers.Plant AS Plant,
  _prodvers.ProductionVersion AS ProductionVersion,
  _prodvers.ProductionLine AS WorkCenter,
  _calenderdate.CalendarDate AS CalendarDate,
  0 AS ShiftNumber,
  _SOSTypeText.SOSTypeDescription AS SOSTypeDescription,
  _prodvers.ProductionVersionText AS ProductionVersionText,
  _WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _WorkCenterText[1:Language=$session.system_language].WorkCenterText AS WorkCenterDesc,
  _order.LtstSchedldExecStrtDteTme AS LtstSchedldExecStrtDteTme,
  _order.LtstSchedldExecEndDteTme AS LtstSchedldExecEndDteTme,
  _order.OperationPlanningStatusCode AS OperationPlanningStatusCode,
  _calenderdate.WeekDay AS WeekDay,
  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,
  BOOExplosionDate,
  BOMExplosionDate,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate,
  cast('000000000000000' as timestamp) AS OrderOperationEndDateTime,
  cast('000000000000000' as timestamp) AS OrderOperationStartDateTime,
  cast('000000000000000' as timestamp) AS RequirementDateTime,
  cast('' as vornr) AS Operation,
  case when _WorkCenter._Plant._OrganizationAddress[1: AddressRepresentationCode = '' ].AddressTimeZone is null or _WorkCenter._Plant._OrganizationAddress[1: AddressRepresentationCode = '' ].AddressTimeZone is initial then abap_system_timezone($session.client, 'NULL') when _WorkCenter._Plant._OrganizationAddress[1: AddressRepresentationCode = '' ].AddressTimeZone is not null then _WorkCenter._Plant._OrganizationAddress[1: AddressRepresentationCode = '' ].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  -- association [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]
;