C_OpnCtlgItem

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_OpnCtlgItem.
-- 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: COPNCTLGITEM

CREATE VIEW C_OpnCtlgItem AS
SELECT
  OpnCtlgItemID,
  OpnCtlgItemKey,
  _AttachMain._Attach.OpnCtlgMainImageURL AS OpnCtlgMainImageURL,
  _ItemDesc.ProductDescription AS ProductDescription,
  _LongText.OpnCtlgSrchLongText AS OpnCtlgSrchLongText,
  OpenCatalogUserRatingValue,
  ProductCatalogName,
  _PriceCon.OpnCtlgItemPrice AS OpnCtlgItemPrice,
  _PriceCon.OpnCtlgItemCurrency AS OpnCtlgItemCurrency,
  NetPriceQuantity,
  UnitOfMeasure,
  OpnCtlgMinOrderQuantity,
  MaterialFixedLotSizeQuantity,
  / OpnCtlgPrcValidityStartDate AS OpnCtlgPrcValidityStartDate,
  OpnCtlgPrcValidityEndDate,
  TaxTolerancePercent,
  ManufacturerName,
  OpnCtlgIntCatalogName,
  Material,
  _MtrGrpText.MaterialGroupName AS MaterialGroupName,
  OpnCtlgSupplierID,
  ProductType,
  OpnCtlgCategoryID,
  OpnCtlgHasProdRelationExists,
  _AttachMain._Attach.OpnCtlgMainImageName AS OpnCtlgMainImageText,
  _AttachMain.OpnCtlgImageID AS OpnCtlgMainImageID,
  OpnCtlgPriceID,
  OpnCtlgHasPriceScale,
  Service,
  OpnCtlgExternalProductID,
  OpnCtlgWebServiceID,
  ItemType,
  cast( OpnCtlgContentUnit as abap.unit( 3 ) ) AS OpnCtlgContentUnit,
  ContractAccount,
  OpnCtlgContractItem,
  OpnCtlgExternalQuoteID,
  OpnCtlgExtQuoteItem,
  OpnCtlgExtSchemaType,
  OpnCtlgExternalCategoryID,
  OpnCtlgExternalCategory,
  ParentItem,
  Plant,
  OpnCtlgPurchasingOrganization,
  OpnCtlgSystemName,
  OpnCtlgLeadTmeAnncmntDuDaysVal,
  cast(0 as abap.int4( 10 )) AS OpnCtlgNumberOfHits,
  cast(0 as abap.int4( 10 )) AS OrderQuantity,
  cast(0 as abap.char( 30 )) AS ObjectType,
  cast(0 as abap.char( 50 )) AS OpnCtlgOriginApplication
FROM I_OpnCtlgItem
LEFT OUTER JOIN C_OpnCtlgAttribute AS _OpnCtlgAttribute ON OpnCtlgItemID = _OpnCtlgAttribute.OpnCtlgItemID  -- association [1..*]
LEFT OUTER JOIN C_OpnCtlgReview AS _OpnCtlgReview ON OpnCtlgItemID = _OpnCtlgReview.OpnCtlgItemID  -- association [1..*]
LEFT OUTER JOIN C_OpnCtlgProdImages AS _OpnCtlgProdImages ON OpnCtlgItemID = _OpnCtlgProdImages.OpnCtlgItemID  -- association [1..*]
;