P_CtlgItemImage

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 P_CtlgItemImage.
-- 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: PCTLGITEMIMAGE
-- Parameters: P_Language : mmpur_cat_language

CREATE VIEW P_CtlgItemImage AS
SELECT
  OpnCtlgItemID,
  _Attach.OpnCtlgImageID AS OpnCtlgImageID,
  _ItemDesc.ProductDescription AS ProductDescription,
  OpenCatalogMaterialGroup AS MaterialGroup,
  _MtrGrpText.MaterialGroupName AS MaterialGroupName,
  _Attach.OpnCtlgMainImageName AS OpnCtlgMainImageName,
  _Attach.OpnCtlgMainImageURL AS OpnCtlgMainImageURL,
  OpnCtlgWebServiceID
FROM I_Catalogitem
LEFT OUTER JOIN I_CatalogItemAttachment AS _Attach ON OpnCtlgItemID = _Attach.OpnCtlgItemID  -- association [0..*]
LEFT OUTER JOIN I_OpnCtlgMatGrpText AS _MtrGrpText ON _MtrGrpText.OpnCtlgItemID = OpnCtlgItemID AND _MtrGrpText.Language = $parameters.P_Language  -- association [1..1]
;