I_AssortmentModuleProductTP

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_AssortmentModuleProductTP.
-- 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_AssortmentModuleProductTP AS
SELECT
  Product.Product AS Product,
  cast ( case when ProdDistCenter.Product is null then '' else 'X' end as rfm_asm_is_prod_listed_in_dc preserving type ) AS ProductIsListedInAnyDistrCtr,
  cast ( Product.ProductGroup as rfm_mrchdscategory preserving type ) AS ProductGroup,
  Product.ProductCategory AS ProductCategory,
  Product.ProductType AS ProductType,
  Product.ProductStandardID AS ProductStandardID,
  _ArticleHierNode.RetailArticleHierarchyNode AS RetailArticleHierarchyNode,
  Product.AuthorizationGroup AS AuthorizationGroup,
  max( ProdDistCenter.LastChangeDate ) AS LastChangeDate,
  Product._Text AS _Text,
  Product._ProductType AS _ProductType,
  Product._ProductCategory AS _ProductCategory,
  Product._ProductGroup AS _ProductGroup,
  Product._ProductGroup_2 AS _ProductGroup_2
INNER JOIN I_ProductRetail AS RetailProduct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductDistrCtrListingTP AS ProdDistCenter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_GenericArticleWithVariants AS Variants ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductDistrCtrListingTP AS _ProductDistrCtrListing ON Product = _ProductDistrCtrListing.Product  -- association [0..*]
LEFT OUTER JOIN I_ArticleHierNodeToProduct AS _ArticleHierNode ON Product = _ArticleHierNode.Product  -- association [0..1]
;