I_ExplctAssMdlUsrProdExclsnTP

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_ExplctAssMdlUsrProdExclsnTP.
-- 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_ExplctAssMdlUsrProdExclsnTP AS
SELECT
  Exclusions.AssortmentModuleObjectUUID AS AssortmentModuleObjectUUID,
  Exclusions.Product AS Product,
  Exclusions.AssortmentModuleUser AS AssortmentModuleUser,
  Exclusions.LastChangeDate AS LastChangeDate,
  Exclusions.LastChangeDateTime AS LastChangeDateTime,
  Exclusions.SalesOrganization AS SalesOrganization,
  Exclusions.DistributionChannel AS DistributionChannel,
  case when coalesce( _ModuleProduct.Product, ' ' ) <> ' ' then 'X' else ' ' end AS ProductIsAssignedToVersion,
  max(_ModuleProduct.ValidityEndDate) AS ValidityEndDate
FROM I_AsstmtMdlUserProductExclsn AS Exclusions
INNER JOIN I_ExplicitAssortmentModule AS ExplicitModules ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ExplicitAssortmentModuleTP AS _ExplicitAssortmentModule ON AssortmentModuleObjectUUID = _ExplicitAssortmentModule.AssortmentModuleUUID  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON AssortmentModuleUser = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_ProdToExplicitAsstmtMdlTP AS _ModuleProduct ON Product = _ModuleProduct.Product AND AssortmentModuleObjectUUID = _ModuleProduct.AssortmentModuleUUID  -- association [0..1]
;