I_ProdAssgblToExplctModuleTP

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_ProdAssgblToExplctModuleTP.
-- 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_ProdAssgblToExplctModuleTP AS
SELECT
  Product.Product AS Product,
  cast( 'X' as rfm_asm_prd_asgnd_to_expl_mod preserving type ) AS ProdIsLstdInAnyExplctAsstmtMdl,
  cast ( Product.ProductGroup as rfm_mrchdscategory preserving type ) AS ProductGroup,
  Product.ProductCategory AS ProductCategory,
  Product.ProductType AS ProductType,
  Product.AuthorizationGroup AS AuthorizationGroup,
  Product.ProductStandardID AS ProductStandardID,
  cast ( Product.CrossPlantConfigurableProduct as rfm_asm_crossplant_conf_prod preserving type ) AS CrossPlantConfigurableProduct,
  _ArticleHierNode.HierarchyID AS HierarchyID,
  _ArticleHierNode.RetailArticleHierarchyNode AS RetailArticleHierarchyNode,
  _ArticleHierNode._NodeText AS _ArtHierNodeText,
  _ArticleHierNode._ActiveArticleHierarchy AS _ActiveArticleHierarchy,
  Product._Text AS _Text,
  Product._ProductType AS _ProductType,
  Product._ProductCategory AS _ProductCategory,
  Product._ProductGroup AS _ProductGroup,
  Product._ProductGroup_2 AS _ProductGroup_2,
  Product._CrossPlantConfigurableProduct AS _CrossPlantConfigurableProduct
INNER JOIN I_ProdToExplicitAsstmtModule AS ProdExplctAssortmentMdl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdToExplicitAsstmtModule AS ProdExplctAssortmentMdl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdToExplicitAsstmtMdlTP AS _ProductAssortMdlListing ON Product = _ProductAssortMdlListing.Product  -- association [0..*]
LEFT OUTER JOIN I_ArticleHierNodeToProduct AS _ArticleHierNode ON Product = _ArticleHierNode.Product  -- association [0..1]
;