C_ProductObjPg

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_ProductObjPg.
-- 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: CPRODUCTOBJPG

CREATE VIEW C_ProductObjPg AS
SELECT
  Product,
  _Text[1: Language=$session.system_language].ProductName AS ProductName,
  ProductType,
  ProductGroup,
  ProductCategory,
  CrossPlantConfigurableProduct,
  _CrossPlantConfigurableProduct._Text [1: Language=$session.system_language].ProductName AS CrsPlntConfigurableProductName,
  BaseUnit,
  ProductStandardID,
  InternationalArticleNumberCat,
  Brand,
  _ProductRetail.CountryOfOrigin AS CountryOfOrigin,
  _ProductRetail.RegionOfOrigin AS RegionOfOrigin,
  ProductManufacturerNumber,
  GrossWeight,
  WeightUnit,
  cast(rpad('', 80, ' ') as char80 preserving type) AS ProductMeasurement,
  BaseUnitSpecificProductLength,
  BaseUnitSpecificProductWidth,
  BaseUnitSpecificProductHeight,
  ProductMeasurementUnit,
  MaterialVolume,
  VolumeUnit,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  cast('' as productimageurl) AS ProductImageURL,
  _ProductSeasonType1._Text[1: Language=$session.system_language].ProductSeasonTypeName AS ProductSeasonType1Name,
  _ProductSeasonType2._Text[1: Language=$session.system_language].ProductSeasonTypeName AS ProductSeasonType2Name,
  _ProductSeasonType3._Text[1: Language=$session.system_language].ProductSeasonTypeName AS ProductSeasonType3Name,
  ProductIsConfigurable,
  AuthorizationGroup,
  ItemCategoryGroup,
  _ProductRetail._CountryOfOrigin AS _CountryOfOrigin,
  _ProductRetail._CountryText AS _CountryText,
  _ProductRetail._RegionOfOrigin AS _RegionOfOrigin
FROM I_Product
LEFT OUTER JOIN C_ProductObjPgSupplierContact AS _ProductObjPgSupplierContact ON Product = _ProductObjPgSupplierContact.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgPurgInfoRecd AS _ProductObjPgPurgInfoRecd ON Product = _ProductObjPgPurgInfoRecd.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgSite AS _ProductObjPgSite ON Product = _ProductObjPgSite.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgPlant AS _ProductObjPgPlant ON Product = _ProductObjPgPlant.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgPurchaseOrder AS _ProductObjPgPurchaseOrder ON Product = _ProductObjPgPurchaseOrder.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgDistrChain AS _ProductObjPgDistrChain ON Product = _ProductObjPgDistrChain.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgSalesOrder AS _ProductObjPgSalesOrder ON Product = _ProductObjPgSalesOrder.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgAllocationTable AS _ProductObjPgAllocationTable ON Product = _ProductObjPgAllocationTable.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgRetailPromotion AS _ProductObjPgRetailPromotion ON Product = _ProductObjPgRetailPromotion.Product  -- association [0..*]
LEFT OUTER JOIN C_ProductObjPgSeason AS _ProductObjPgSeason ON Product = _ProductObjPgSeason.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductSeasonType AS _ProductSeasonType1 ON _ProductSeasonType1.ProductSeasonType = 'ST1'  -- association [1..1]
LEFT OUTER JOIN I_ProductSeasonType AS _ProductSeasonType2 ON _ProductSeasonType2.ProductSeasonType = 'ST2'  -- association [1..1]
LEFT OUTER JOIN I_ProductSeasonType AS _ProductSeasonType3 ON _ProductSeasonType3.ProductSeasonType = 'ST3'  -- association [1..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON regionoforigin = _RegionText.Region AND countryoforigin = _RegionText.Country  -- association [0..*]
;