R_ProjectedStock

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 R_ProjectedStock.
-- 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 R_ProjectedStock AS
SELECT
  projected_stock_uuid AS ProjectedStockUUID,
  simsession_uuid AS SimulationSessionUUID,
  start_value_qty AS StartValueQuantity,
  unit_of_measure AS UnitOfMeasure,
  Product,
  product_desc AS ProductDescription,
  Location,
  planning_segment AS PlanningSegment,
  planning_vers_ext AS PlanningVersionExternal,
  safety_stock_method AS AdvncdPlngSftyStkMeth,
  target_stock_method AS AdvncdPlngTgtStkLvlMeth,
  target_days_supply_qty1 AS TargetDaysSupply1Quantity,
  target_days_supply_qty2 AS TargetDaysSupply2Quantity,
  target_days_supply_qty3 AS TargetDaysSupply3Quantity,
  target_days_supply_desc1 AS TargetDaysSupply1Description,
  target_days_supply_desc2 AS TargetDaysSupply2Description,
  target_days_supply_desc3 AS TargetDaysSupply3Description,
  target_days_supply_unit1 AS TargetDaysSupply1Unit,
  target_days_supply_unit2 AS TargetDaysSupply2Unit,
  target_days_supply_unit3 AS TargetDaysSupply3Unit,
  target_days_supply_alert_lvl1 AS TargetDaysSupply1AlertLevel,
  target_days_supply_alert_lvl2 AS TargetDaysSupply2AlertLevel,
  target_days_supply_alert_lvl3 AS TargetDaysSupply3AlertLevel,
  last_change_date_time AS LastChangeDateTime
FROM /sapapo/prjstk_h
;