C_APSOrdDetsByWorkAreaDEX

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

CREATE VIEW C_APSOrdDetsByWorkAreaDEX AS
SELECT
  orders.AdvncdPlngPlanningVersion AS AdvncdPlngPlanningVersion,
  orders.SimulationSessionUUID AS SimulationSessionUUID,
  orders.PlanningModel AS PlanningModel,
  orders.AdvncdPlngOrderInternalNumber AS AdvncdPlngOrderInternalNumber,
  orders.AdvncdPlngScheduleLineItmNmbr AS AdvncdPlngScheduleLineItmNmbr,
  orders.AdvncdPlngScheduleLineNumber AS AdvncdPlngScheduleLineNumber,
  orders.PlanningVersionExternal AS PlanningVersionExternal,
  orders.AdvncdPlngOrderID AS AdvncdPlngOrderID,
  orders.AdvncdPlngOrderATPCategory AS AdvncdPlngOrderATPCategory,
  orders.AdvncdPlngOrderType AS AdvncdPlngOrderType,
  orders.AdvancedPlanningOrderStatus AS AdvancedPlanningOrderStatus,
  orders.AdvncdPlngOrderObjectType AS AdvncdPlngOrderObjectType,
  orders.AdvncdPlngProductID AS AdvncdPlngProductID,
  orders.AdvancedPlanningProductName AS AdvancedPlanningProductName,
  orders.ProductBaseUnit AS ProductBaseUnit,
  orders.AdvancedPlanningMaterialGroup AS AdvancedPlanningMaterialGroup,
  orders.ProductionPlanner AS ProductionPlanner,
  _SCMPlanner.PlannerName AS ProductionPlannerName,
  cast( orders.AdvncdPlngFrmLocID as /sapapo/location_id preserving type ) AS AdvncdPlngFrmLocID,
  cast( _SourceLocation.Location as /sapapo/locno preserving type ) AS AdvancedPlanningSourceLocation,
  _SourceLocation.LocationType AS SourceLocationType,
  cast( orders.AdvncdPlngToLocID as /sapapo/location_id preserving type ) AS AdvncdPlngToLocID,
  cast(_DestinationLocation.Location as /sapapo/locno preserving type ) AS AdvancedPlanningDestLocation,
  _DestinationLocation.LocationType AS AdvncdPlngDestLocType,
  orders.AdvancedPlanningSpclStkType AS AdvancedPlanningSpclStkType,
  orders.AdvncdPlngSpclStkSgmtKeyVal AS AdvncdPlngSpclStkSgmtKeyVal,
  orders.SubcontractingFlag AS SubcontractingFlag,
  orders.ConsignmentFlag AS ConsignmentFlag,
  orders.AdvncdPlngSupNameSrce AS AdvncdPlngSupNameSrce,
  orders.AdvncdPlngMeansOfTransport AS AdvncdPlngMeansOfTransport,
  orders.AdvncdPlngCrtnDte AS AdvncdPlngCrtnDte,
  orders.CreationTime AS CreationTime,
  orders.AdvncdPlngEffctvStrtDte AS AdvncdPlngEffctvStrtDte,
  orders.AdvncdPlngEffctvStrtTme AS AdvncdPlngEffctvStrtTme,
  orders.AdvncdPlngEffctvEndDte AS AdvncdPlngEffctvEndDte,
  orders.AdvncdPlngEffctvEndTme AS AdvncdPlngEffctvEndTme,
  orders.AdvncdPlngOrderStartDate AS AdvncdPlngOrderStartDate,
  orders.AdvncdPlngOrderStartTime AS AdvncdPlngOrderStartTime,
  orders.AdvncdPlngOrdEndDte AS AdvncdPlngOrdEndDte,
  orders.AdvncdPlngOrdEndTme AS AdvncdPlngOrdEndTme,
  orders.AdvancedPlanningOutpStartDate AS AdvancedPlanningOutpStartDate,
  orders.AdvancedPlanningOutpStartTime AS AdvancedPlanningOutpStartTime,
  orders.AdvancedPlanningOutputEndDate AS AdvancedPlanningOutputEndDate,
  orders.AdvancedPlanningOutputEndTime AS AdvancedPlanningOutputEndTime,
  orders.AdvncdPlngRsceUtilznCapUnit AS AdvncdPlngRsceUtilznCapUnit,
  orders.AdvncdPlngLeadTmeDurn AS AdvncdPlngLeadTmeDurn,
  orders.AdvncdPlngSetupTmeDurn AS AdvncdPlngSetupTmeDurn,
  orders.AdvncdPlngProdnTmeDurn AS AdvncdPlngProdnTmeDurn,
  orders.AdvncdPlngWaitTmeDurn AS AdvncdPlngWaitTmeDurn,
  orders.AdvncdPlngQueueTmeDurn AS AdvncdPlngQueueTmeDurn,
  orders.AdvncdPlngWIPTmeDurn AS AdvncdPlngWIPTmeDurn,
  orders.AdvancedPlanningOrderDelay AS AdvancedPlanningOrderDelay,
  orders.AdvncdPlngOriglQty AS AdvncdPlngOriglQty,
  orders.AdvncdPlngTotQty AS AdvncdPlngTotQty,
  orders.AdvncdPlngRealQty AS AdvncdPlngRealQty,
  orders.AdvncdPlngScrapQty AS AdvncdPlngScrapQty,
  orders.AdvncdPlngConfdQty AS AdvncdPlngConfdQty,
  orders.MasterFlag AS MasterFlag,
  cast( orders.AdvncdPlngOrderIsOutputFirmed as xfeld preserving type ) AS AdvncdPlngOrderIsOutputFirmed,
  cast( orders.AdvncdPlngOrderIsInputFirmed as xfeld preserving type ) AS AdvncdPlngOrderIsInputFirmed,
  cast( orders.AdvncdPlngOrderIsFixed as xfeld preserving type ) AS AdvncdPlngOrderIsFixed,
  cast( orders.AdvncdPlngOrderIsReleased as xfeld preserving type ) AS AdvncdPlngOrderIsReleased,
  cast( orders.AdvncdPlngOrderIsStarted as xfeld preserving type ) AS AdvncdPlngOrderIsStarted,
  cast( orders.AdvncdPlngOrderIsPrtlyConfirm as xfeld preserving type ) AS AdvncdPlngOrderIsPrtlyConfirm,
  cast( orders.AdvncdPlngOrderIsConfirmed as xfeld preserving type ) AS AdvncdPlngOrderIsConfirmed,
  cast( orders.AdvncdPlngOrdIsPrtlyDlvrd as xfeld preserving type ) AS AdvncdPlngOrdIsPrtlyDlvrd,
  cast( orders.AdvncdPlngOrderIsFinalDelivery as xfeld preserving type ) AS AdvncdPlngOrderIsFinalDelivery,
  orders.AdvncdPlngOrderIsConvertible AS AdvncdPlngOrderIsConvertible
FROM P_APSOrdDetsByWrkArea
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_LocationBasic AS _SourceLocation ON AdvncdPlngFrmLocID = _SourceLocation.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _DestinationLocation ON AdvncdPlngToLocID = _DestinationLocation.LocationUUID  -- association [0..1]
LEFT OUTER JOIN I_SCMPlanner AS _SCMPlanner ON ProductionPlanner = _SCMPlanner.Planner  -- association [0..1]
LEFT OUTER JOIN I_APSPlanningModelText AS _PlanningModelText ON PlanningModel = _PlanningModelText.PlanningModel  -- association [0..*]
LEFT OUTER JOIN I_AdvncdPlngATPCategoryText AS _ATPCategoryText ON AdvncdPlngOrderATPCategory = _ATPCategoryText.AdvncdPlngOrderATPCategory  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON AdvancedPlanningProductName = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON AdvancedPlanningMaterialGroup = _ProductGroupText.ProductGroup  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _ProductUnitText ON ProductBaseUnit = _ProductUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _OrdTimeUnitText ON AdvncdPlngRsceUtilznCapUnit = _OrdTimeUnitText.UnitOfMeasure  -- association [0..*]
;