I_ProductPlantPlanningTP

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_ProductPlantPlanningTP.
-- 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 I_ProductPlantPlanningTP AS
SELECT
  cast (Planning.Product as productnumber preserving type ) AS Product,
  Planning.Plant AS Plant,
  Planning.Plant AS PlantForEdit,
  Planning.PlanningMaterial AS PlanningMaterial,
  cast (Planning.PlanningPlant as cmd_prd_planning_plant preserving type ) AS PlanningPlant,
  Planning.ProdPlntPlngMatlConversionFctr AS ProdPlntPlngMatlConversionFctr,
  cast ('' as abap.char(10) ) AS ProdPlntPlngMatlCnvrsnFctrVal,
  Planning.PlanningMaterialUnitOfMeasure AS PlanningMaterialUnitOfMeasure
FROM I_ProductPlantPlanning AS Planning
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantWD AS _ProductPlant ON Product = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
;