I_ProdAssgblToExplctMdlVersTP

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_ProdAssgblToExplctMdlVersTP.
-- 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_ProdAssgblToExplctMdlVersTP AS
SELECT
  ModuleVersion.AssortmentModuleVersionUUID AS AssortmentModuleVersionUUID,
  Product.Product AS Product,
  ModuleVersion.AssortmentModuleName AS AssortmentModuleName,
  ModuleVersion.ValidityStartDate AS ValidityStartDate,
  ModuleVersion.ValidityEndDate AS ValidityEndDate,
  Assignments.ValidityStartDate AS AssignmentValidityStartDate,
  Assignments.ValidityEndDate AS AssignmentValidityEndDate,
  Product.AuthorizationGroup AS AuthorizationGroup,
  Product.ProductGroup AS ProductGroup,
  Product.ProductType AS ProductType,
  Product._ProductGroup_2 AS _ProductGroup_2,
  Product._ProductType AS _ProductType
FROM I_ExplicitAsstmtMdlVersionTP AS ModuleVersion
INNER JOIN I_ProductRetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdToExplctAsstmtMdlVersTP AS Assignments ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AssortmentModuleText AS _Text ON _Text.AssortmentModuleUUID = AssortmentModuleVersionUUID  -- association [1..*]
;