I_CmmdtyStructuralQuantityTP

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_CmmdtyStructuralQuantityTP.
-- 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: ICMMDTYSTRUQTY

CREATE VIEW I_CmmdtyStructuralQuantityTP AS
SELECT
  Product,
  Plant,
  Commodity,
  Commodity AS CommodityForEdit,
  _SourcingCommodityText[1: Language=$session.system_language].CommodityName AS CommodityName,
  CommodityQuantity,
  CommodityQuantityUoM,
  ReferenceQuantity,
  ReferenceQuantityUoM,
  CreatedByUser,
  _UserCreate.UserDescription AS CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  _UserChange.UserDescription AS ChangedByUserName,
  LastChangeDateTime
FROM I_CommodityStructuralQuantity AS CommodityStructuralQuantity
LEFT OUTER JOIN E_CommodityStructuralQuantity AS _ActiveExtension ON Product = _ActiveExtension.Product AND Plant = _ActiveExtension.Plant AND Commodity = _ActiveExtension.Commodity  -- association [1..1]
LEFT OUTER JOIN E_CommodityStructuralQuantity AS _DraftExtension ON Product = _DraftExtension.Product AND Plant = _DraftExtension.Plant AND Commodity = _DraftExtension.Commodity  -- association [1..1]
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]
LEFT OUTER JOIN I_SourcingCommodityText AS _SourcingCommodityText ON Commodity = _SourcingCommodityText.Commodity  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserCreate ON CreatedByUser = _UserCreate.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserChange ON LastChangedByUser = _UserChange.UserID  -- association [0..1]
;