I_APSFillLvlDurnByAORCube

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_APSFillLvlDurnByAORCube.
-- 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.
-- Parameters: P_StartDate : vdm_v_start_date, P_EndDate : vdm_v_end_date, P_TimeZoneID : tznzone

CREATE VIEW I_APSFillLvlDurnByAORCube AS
SELECT
  fl_info.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  fl_info.SimulationSessionUUID AS SimulationSessionUUID,
  AdvncdPlngResourceID,
  _Resource.LocationUUID AS AdvncdPlngLocationID,
  fl_info.PPDSRsceEvaluationStartDate AS FactoryCalendarDate,
  _Resource.ResourcePlanner AS ResourcePlanner,
  _Resource.PlannerName AS ResourcePlannerName,
  _Resource.ResourceGroup AS ResourceGroup,
  fl_info.PlanningModel AS PlanningModel,
  fl_info.PlanningVersionExternal AS PlanningVersionExternal,
  _Resource.AdvncdPlngResourceName AS AdvncdPlngResourceName,
  _Resource.ResourceType AS ResourceType,
  _Resource.ResourceCategory AS ResourceCategory,
  _Resource.ResourceHomeLocation AS Location,
  _Resource.LocationType AS LocationType,
  fl_info.PPDSTimeUnit AS PPDSTimeUnit
FROM P_APSFillLvlInfoByAOR
LEFT OUTER JOIN I_APSResource AS _Resource ON AdvncdPlngResourceID = _Resource.AdvncdPlngResourceID AND AdvncdPlngPlanningVersion = _Resource.AdvncdPlngPlanningVersion AND SimulationSessionUUID = _Resource.SimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_APSPlanVersion AS _PlanningVersion ON AdvncdPlngPlanningVersion = _PlanningVersion.AdvncdPlngPlanningVersion  -- association [0..1]
LEFT OUTER JOIN I_APSSimulationSession AS _SimulationSession ON SimulationSessionUUID = _SimulationSession.SimulationSessionUUID  -- association [0..1]
LEFT OUTER JOIN I_APSPlanningModelText AS _ModelText ON PlanningModel = _ModelText.PlanningModel  -- association [0..*]
LEFT OUTER JOIN I_LocationBasic AS _Location ON AdvncdPlngLocationID = _Location.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_LocationText AS _LocationText ON AdvncdPlngLocationID = _LocationText.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_AdvncdPlngResourceGroupTxt AS _ResourceGroupText ON resourcegroup = _ResourceGroupText.ResourceGroup  -- association [0..*]
;