I_JITPlanSupToProduction

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 I_JITPlanSupToProduction.
-- 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: IJITPLANSTOP

CREATE VIEW I_JITPlanSupToProduction AS
SELECT
  JITControlCycle,
  Plant,
  Material,
  ProductionSupplyArea AS SupplyArea,
  Responsible AS PersonResponsible,
  StorageLocation,
  ReplenishmentStrategy,
  StorageBin,
  EWMWarehouse,
  ReplnmtPlanningProcedure,
  cast('1111' as tzntstmps ) AS PlanningHorizonDateTime,
  cast('X' as njit_demands ) AS JITDemands,
  cast( '2222' as tzntstmps ) AS CreationDateTime,
  cast( '3333' as tzntstmps ) AS JITSupplyDateTime,
  cast( 'X' as lprio ) AS JITCallPriorityID,
  cast('X' as njit_missing_part ) AS JITMaterialStockIsMissing,
  cast( 'X' as njit_tolerance_flag ) AS JITOutbToleranceFlag,
  Supplier,
  _JITCCSchdAgrmt.SchedulingAgreement AS SchedulingAgreement
FROM I_JITControlCycleCalc
LEFT OUTER JOIN C_JITControlCycleVH AS _JITControlCycleVH ON JITControlCycle = _JITControlCycleVH.JITControlCycle  -- association [0..*]
LEFT OUTER JOIN C_JITOutbPlantVH AS _JITOutbPlantVH ON Plant = _JITOutbPlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_JITOutbMaterialVH AS _JITOutbMaterialVH ON Plant = _JITOutbMaterialVH.Plant AND Material = _JITOutbMaterialVH.Product  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSupplyAreaVH AS _JITOutbSupplyAreaVH ON Plant = _JITOutbSupplyAreaVH.Plant AND SupplyArea = _JITOutbSupplyAreaVH.ProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN C_JITOutbCtrlCycResp AS _JITOutbCtrlCycResp ON Plant = _JITOutbCtrlCycResp.Plant AND PersonResponsible = _JITOutbCtrlCycResp.MRPController  -- association [0..1]
LEFT OUTER JOIN C_JITOutbSupplyAreaVH AS _JITOutbSupAreaVH ON StorageLocation = _JITOutbSupAreaVH.StorageLocation  -- association [0..*]
LEFT OUTER JOIN C_JITOutbReplnmtStrgyVH AS _JITOutbReplnmtStrgyVH ON Plant = _JITOutbReplnmtStrgyVH.Plant AND ReplenishmentStrategy = _JITOutbReplnmtStrgyVH.ReplenishmentStrategy  -- association [0..1]
LEFT OUTER JOIN C_JITOutbEWMStorageBinVH AS _JITOutbStorageBinVH ON StorageBin = _JITOutbStorageBinVH.EWMStorageBin AND EWMWarehouse = _JITOutbStorageBinVH.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_JITOutbPlngProcedure AS _JITOutbPlngProcedure ON ReplnmtPlanningProcedure = _JITOutbPlngProcedure.JITPlanningProcedure  -- association [0..1]
LEFT OUTER JOIN I_JITOutbControlCycSchedgAgrmt AS _JITCCSchdAgrmt ON JITControlCycle = _JITCCSchdAgrmt.JITControlCycle  -- association [0..*]
;