I_CatalogItemMngTP

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_CatalogItemMngTP.
-- 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: ICTLGITMMNGTP

CREATE VIEW I_CatalogItemMngTP AS
SELECT
  OpnCtlgItemID,
  OpnCtlgPriceID,
  PricingScaleType,
  OpnCtlgExternalProductID,
  OpnCtlgWebServiceID,
  OpnCtlgWebServiceName,
  ProductCatalogName,
  OpnCtlgIntCatalogName,
  OpnCtlgSupplierName,
  OpnCtlgMaterialIDBySupplier,
  ItemType,
  OpnCtlgIsServiceMaterialType AS Service,
  OpnCtlgItemPriceQuantityValue AS NetPriceQuantity,
  TaxTolerancePercent,
  OpenCatalogMaterialGroup AS MaterialGroup,
  ManufacturerName,
  Manufacturer,
  OpnCtlgMfrMaterialNumber AS ManufacturerMaterial,
  OpnCtlgLeadTmeAnncmntDuDaysVal AS LeadTimeAnncmntDueInDays,
  OpenCatalogPackingQuantityVal AS OpnCtlgPackingQty,
  OpnCtlgMinOrderQuantityValue AS OpnCtlgMinOrderQuantity,
  OpnCtlgMatlFixedLotSizeQtyVal AS MaterialFixedLotSizeQuantity,
  OpenCatalogReferenceContractID AS ContractAccount,
  OpnCtlgContractItem,
  OpnCtlgExternalQuoteID,
  OpnCtlgExtQuoteItem,
  OpnCtlgExtSchemaType,
  OpnCtlgExternalCategoryID,
  OpnCtlgExternalCategory,
  OpenCatalogUserRatingValue AS UsageRating,
  ParentItem,
  IsMarkedForDeletion,
  IsOpnCtlgManaged,
  IsOpnCtlgItmFrmMatlMstr,
  IsOpnCtlgItem,
  OpnCtlgChangedDateTimeValue AS ChangedDateTime,
  OpnCtlgChangedBy,
  OpnCtlgItemSustainCompliance,
  OpnCtlgDirectEmissionValue,
  OpnCtlgDirectEmissionUnit,
  OpnCtlgIndrctEmissionValue,
  OpnCtlgIndrctEmissionUnit,
  OpnCtlgTempEmissionValue,
  OpnCtlgTempEMissionUnit,
  OpnCtlgRecycleValue,
  OpnCtlgRecycleUnit,
  OpnCtlgWaterConsumptionValue,
  OpnCtlgWaterConsumptionUnit,
  OpnCtlgEnergyConsumptionValue,
  OpnCtlgEnergyConsumptionUnit,
  OpnCtlgWasteGeneratedValue,
  OpnCtlgWasteGeneratedUnit,
  LogicalSystem,
  OpnCtlgSystemName,
  SourceLogicalSystem,
  ProductType,
  OpnCtlgCategoryID,
  Decimals,
  OpnCtlgHasProdRelationExists,
  OpnCtlgHasPriceScale,
  PlantName,
  CompanyCode,
  BaseUnit,
  PurchasingDocument,
  PurchasingDocumentItem,
  NetPriceAmount,
  OrderPriceUnitQty AS PurchasingDocumentPriceUnit,
  OrderQuantityUnit AS PurchasingDocumentOrderQty,
  Currency,
  PurReqnSourceOfSupplyType AS PurchasingDocumentType,
  ValidityEndDate,
  ValidityStartDate,
  SourceOfSupplyIsFixed,
  SourceOfSupplyIsBlocked,
  OpnCtlgSourceListValidFromDate AS ValidFrom,
  OpnCtlgSourceListValidToDate AS ValidTo,
  PurchasingOrganization,
  OpenCatalogExternalKey AS ExternalDocumentReferenceID,
  IsBusinessPurposeCompleted,
  OpnCtlgItemPrpslID,
  OpnCtlgArchivingStatus AS ArchivingStatus,
  Material AS PlanningMaterial,
  cast(OpnCtlgSupplierID as lifnr) AS OpnCtlgSupplierID,
  cast(Material as matnr) AS Material,
  cast(OpenCatalogUnitOfMeasure as meins) AS UnitOfMeasure,
  cast(OpnCtlgContentUnit as meins) AS OpnCtlgContentUnit,
  $session.system_language AS Language,
  cast(case when IsMarkedForDeletion = 'X' then '02' when IsMarkedForDeletion <> 'X' then '01' end as abap.char(10)) as DueDateCriticality AS char10asDueDateCriticality,
  case when OpnCtlgPriceValdtyStartDteVal = '0' or OpnCtlgPriceValdtyStartDteVal = '' then cast('00000000' as abap.dats) when OpnCtlgPriceValdtyStartDteVal <> '0' and OpnCtlgPriceValdtyStartDteVal <> '' then cast(cast( OpnCtlgPriceValdtyStartDteVal as abap.char( 8 )) as abap.dats) end as OpnCtlgPrcValidityStartDate AS datsendasOpnCtlgPrcValidityStartDate,
  case when OpnCtlgPriceValdtyEndDteVal = '0' or OpnCtlgPriceValdtyEndDteVal = '' then cast('00000000' as abap.dats) when OpnCtlgPriceValdtyEndDteVal <> '0' and OpnCtlgPriceValdtyEndDteVal <> '' then cast(cast( OpnCtlgPriceValdtyEndDteVal as abap.char( 8 )) as abap.dats) end as OpnCtlgPrcValidityEndDate AS datsendasOpnCtlgPrcValidityEndDate,
  _CatalogItemDescTP[1: Language = $session.system_language].ProductDescription AS ProductDescription,
  _CatalogItemDescTP[1: Language = $session.system_language].OpnCtlgSearchTerm AS OpnCtlgSearchTerm,
  _CatalogItemDescTP[1: Language = $session.system_language].OpnCtlgSrchLongText AS OpnCtlgSrchLongText,
  _attachMain.OpnCtlgImageID AS OpnCtlgImageID,
  _attachMain._Attach.OpnCtlgMainImageName AS OpnCtlgMainImageName,
  _attachMain._Attach.OpnCtlgMainImageURL AS OpnCtlgMainImageURL,
  cast( '' as abap.char( 1000 ) ) AS OpnCtlgMainImgURLHdr,
  OpnCtlgItemPrice,
  OpnCtlgItemCurrency
FROM I_Catalogitem
LEFT OUTER JOIN I_OpnCtlgAttachMain AS _attachMain ON OpnCtlgItemID = _attachMain.OpnCtlgItemID  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialTextVH ON _MaterialTextVH.Material = PlanningMaterial AND _MaterialTextVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CatalogItemDescTP AS _CatalogItemDescTP ON _CatalogItemDescTP.OpnCtlgItemID = OpnCtlgItemID AND _CatalogItemDescTP.Language = $session.system_language  -- association [0..1]
;