I_CustCmmdtyQuantityHeaderTP

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_CustCmmdtyQuantityHeaderTP.
-- 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_CustCmmdtyQuantityHeaderTP AS
SELECT
  UniqueSpecificationUUID,
  Product,
  _ProductDesc[1: Language=$session.system_language].ProductDescription AS ProductDescription,
  SalesOrganization,
  _SalesText[1: Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistChannelText[1: Language=$session.system_language].DistributionChannelName AS DistributionChannelName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  CreatedByUser,
  _UserCreate.UserDescription AS CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  _UserChange.UserDescription AS ChangedByUserName,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  cast('X' as cmm_doc_available_in_db preserving type ) AS DocumentIsSavedOnDatabase,
  _Customer.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_CustomerCommodityQtyHdr
LEFT OUTER JOIN I_ProductDescription AS _ProductDesc ON Product = _ProductDesc.Product  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesText ON SalesOrganization = _SalesText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistChannelText ON DistributionChannel = _DistChannelText.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
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]
LEFT OUTER JOIN E_CustCommoditySpecification AS _Extension ON UniqueSpecificationUUID = _Extension.UniqueSpecificationUUID  -- association [1..1]
LEFT OUTER JOIN I_CustCommodityQuantityItemTP AS _CustomerItem ON /* condition not available in parsed metadata */  -- association [0..*]
;