SEPMRA_I_Product_E

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 SEPMRA_I_Product_E.
-- 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.

CREATE VIEW SEPMRA_I_Product_E AS
SELECT
  cast( Product.product_id as sepmra_product preserving type ) AS Product,
  Product.type_code AS ProductType,
  cast( Product.category as sepmra_productcategory preserving type ) AS ProductCategory,
  cast( CreatedByEmployee.employee_id as sepmra_createdbyemployee preserving type ) AS CreatedByUser,
  Product.created_at AS CreationDateTime,
  cast( LastChangedByEmployee.employee_id as sepmra_changedbyemployee preserving type ) AS LastChangedByUser,
  cast( Product.changed_at as sepmra_lastchanged preserving type ) AS LastChangedDateTime,
  cast( Product.price as sepmra_productunitprice preserving type ) AS Price,
  cast( Product.currency_code as sepmra_currency preserving type ) AS Currency,
  Product.height AS Height,
  Product.width AS Width,
  Product.depth AS Depth,
  Product.dim_unit AS DimensionUnit,
  cast( Product.product_pic_url as sepmra_productimageurl preserving type ) AS ProductPictureURL,
  Product.tax_tarif_code AS ProductValueAddedTax,
  cast( Supplier.bp_id as sepmra_supplierid preserving type ) AS Supplier,
  cast( Product.measure_unit as sepmra_productbaseunit preserving type ) AS ProductBaseUnit,
  Product.weight_measure AS Weight,
  cast( Product.weight_unit as sepmra_weightunit preserving type ) AS WeightUnit
FROM snwd_pd AS Product
LEFT OUTER JOIN SEPMRA_I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN SEPMRA_I_ProductText AS _ProductTextInOriginalLang ON Product = _ProductTextInOriginalLang.Product AND OriginalLanguage = _ProductTextInOriginalLang.Language  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_ProductText AS _ProductTextInCurrentLang ON Product = _ProductTextInCurrentLang.Product AND _ProductTextInCurrentLang.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Language AS _OriginalLanguage ON OriginalLanguage = _OriginalLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ProductValueAddedTax AS _ProductValueAddedTax ON ProductValueAddedTax = _ProductValueAddedTax.ProductValueAddedTax  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ProductType AS _ProductType ON ProductType = _ProductType.ProductType  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_DimensionUnit AS _DimensionUnit ON DimensionUnit = _DimensionUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_WeightUnit AS _WeightUnit ON WeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_QuantityUnit AS _ProductBaseUnit ON ProductBaseUnit = _ProductBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_ProductCategory AS _ProductCategory ON ProductCategory = _ProductCategory.ProductCategory  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_ProductImage AS _ProductImage ON Product = _ProductImage.Product  -- association [0..*]
LEFT OUTER JOIN SEPMRA_I_Employee AS _CreatedByUser ON CreatedByUser = _CreatedByUser.Employee  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_Employee AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.Employee  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_ProductReview AS _CollaborativeReview ON Product = _CollaborativeReview.Product  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_MaxProductStock AS _ProductStock ON Product = _ProductStock.Product  -- association [0..1]
LEFT OUTER JOIN SEPMRA_I_ProductFavourite AS _Favourites ON Product = _Favourites.Product  -- association [0..*]
LEFT OUTER JOIN SEPMRA_I_Stock AS _StorageBins ON Product = _StorageBins.Product  -- association [0..*]
;