C_CtlgItemImage

DDL: C_CTLGITEMIMAGE SQL: CCTLGITEMIMAGE Type: view CONSUMPTION
7 Fields 1 Data Sources 1 Associations

Catalog Item and Associated Image URLs

C_CtlgItemImage is a Consumption CDS View that provides data about "Catalog Item and Associated Image URLs" in SAP S/4HANA. It reads from 1 data source (P_CtlgItemImage) and exposes 7 fields with key fields OpnCtlgItemID, OpnCtlgImageID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_CtlgItemImage P_CtlgItemImage from

Parameters (1)

NameTypeDefault
P_Language mmpur_cat_language

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialGroupText _MaterialGroupText _MaterialGroupText.MaterialGroup = $projection.MaterialGroup and _MaterialGroupText.Language = $parameters.P_Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCTLGITEMIMAGE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Catalog Item and Associated Image URLs view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OpnCtlgItemID OpnCtlgItemID Catalog Item Key
KEY OpnCtlgImageID OpnCtlgImageID
ProductDescription ProductDescription Description
MaterialGroup MaterialGroup Product Group
OpnCtlgMainImageURL OpnCtlgMainImageName
OpnCtlgMainImageName OpnCtlgMainImageURL
OpnCtlgWebServiceID OpnCtlgWebServiceID Web Service ID

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 C_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: CCTLGITEMIMAGE
-- Parameters: P_Language : mmpur_cat_language

CREATE VIEW C_CtlgItemImage AS
SELECT
  OpnCtlgItemID,
  OpnCtlgImageID,
  ProductDescription,
  MaterialGroup,
  OpnCtlgMainImageName AS OpnCtlgMainImageURL,
  OpnCtlgMainImageURL AS OpnCtlgMainImageName,
  OpnCtlgWebServiceID
FROM P_CtlgItemImage
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON _MaterialGroupText.MaterialGroup = MaterialGroup AND _MaterialGroupText.Language = $parameters.P_Language  -- association [0..1]
;

Learn More