I_ActiveLogisticalProduct

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_ActiveLogisticalProduct.
-- 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 I_ActiveLogisticalProduct AS
SELECT
  product.Product AS Product,
  _Text.ProductDescription AS ProductDescription,
  product.ProductExternalID AS ProductExternalID,
  product.CreationDate AS CreationDate,
  product.CreatedByUser AS CreatedByUser,
  product.LastChangeDate AS LastChangeDate,
  product.LastChangeTime AS LastChangeTime,
  product.LastChangeDateTime AS LastChangeDateTime,
  product.LastChangedByUser AS LastChangedByUser,
  product.ProductStandardID AS ProductStandardID,
  product.AuthorizationGroup AS AuthorizationGroup,
  product.SalesProduct AS SalesProduct,
  cast( product.LogisticalProductCategory as logisticalproductcategory preserving type ) AS LogisticalProductCategory,
  product.BaseUnit AS BaseUnit,
  product.ProductType AS ProductType,
  product.ProductCategory AS ProductCategory,
  product.ProductGroup AS ProductGroup,
  IndustrySector,
  cast( product.PurchaseOrderQuantityUnit as purorderquantityunit preserving type ) AS PurchaseOrderUnit,
  _PurchaseOrderUnitText.UnitOfMeasureName AS PurchaseOrderUnitName,
  _PurchaseOrderUnit.QuantityDenominator AS OrderToBaseQuantityDnmntr,
  _PurchaseOrderUnit.QuantityNumerator AS OrderToBaseQuantityNmrtr,
  cast( ProductRetail.GoodsIssueUnit as goodsissueunit preserving type ) AS GoodsIssueUnit,
  _GoodsIssueUnitText.UnitOfMeasureName AS GoodsIssueUnitName,
  _GoodsIssueUnit.QuantityDenominator AS GoodsIssueToBaseQuantityDnmntr,
  _GoodsIssueUnit.QuantityNumerator AS GoodsIssueToBaseQuantityNmrtr
FROM I_Product AS product
INNER JOIN I_ProductRetail AS ProductRetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductDescription AS _Text ON Product = _Text.Product AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Producttype AS _ProductType ON ProductType = _ProductType.ProductType  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeText ON ProductType = _ProductTypeText.ProductType AND _ProductTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductCategory AS _ProductCategory ON ProductCategory = _ProductCategory.ProductCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductCategoryText AS _ProductCategoryText ON ProductCategory = _ProductCategoryText.ProductCategory  -- association [0..*]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON ProductGroup = _ProductGroupText.MaterialGroup AND _ProductGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnitOfMeasure ON BaseUnit = _BaseUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _BaseUnitText ON BaseUnit = _BaseUnitText.UnitOfMeasure AND _BaseUnitText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _GoodsIssueUnit ON Product = _GoodsIssueUnit.Product AND GoodsIssueUnit = _GoodsIssueUnit.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _GoodsIssueUnitOfMeasure ON GoodsIssueUnit = _GoodsIssueUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _GoodsIssueUnitText ON GoodsIssueUnit = _GoodsIssueUnitText.UnitOfMeasure AND _GoodsIssueUnitText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _PurchaseOrderUnit ON Product = _PurchaseOrderUnit.Product AND PurchaseOrderUnit = _PurchaseOrderUnit.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PurchaseOrderUnitOfMeasure ON PurchaseOrderUnit = _PurchaseOrderUnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _PurchaseOrderUnitText ON PurchaseOrderUnit = _PurchaseOrderUnitText.UnitOfMeasure AND _PurchaseOrderUnitText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_Product AS _ProductExt ON Product = _ProductExt.Product  -- association [0..1]
;