I_AssMdlUserToExplicitAssMdlTP

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_AssMdlUserToExplicitAssMdlTP.
-- 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_AssMdlUserToExplicitAssMdlTP AS
SELECT
  AssortmentModuleUser.AssortmentModuleUUID AS AssortmentModuleUUID,
  AssortmentModuleUser.AssortmentModuleUser AS AssortmentModuleUser,
  AssortmentModuleUser.AssortmentModuleName AS AssortmentModuleName,
  AssortmentModuleUser.ValidityStartDate AS ValidityStartDate,
  AssortmentModuleUser.ValidityEndDate AS ValidityEndDate,
  AssortmentModuleUser.LastChangeDate AS LastChangeDate,
  AssortmentModuleUser.LastChangeDateTime AS LastChangeDateTime,
  AssortmentModuleUser.LastChangedByUserName AS LastChangedByUserName,
  AssortmentModuleUser.SalesOrganization AS SalesOrganization,
  AssortmentModuleUser.DistributionChannel AS DistributionChannel,
  AssortmentModuleUser._Site AS _Site
FROM I_UserToExplicitAsstmtModule AS AssortmentModuleUser
LEFT OUTER JOIN I_ExplicitAssortmentModuleTP AS _ExplicitAssortmentModule ON _ExplicitAssortmentModule.AssortmentModuleUUID = AssortmentModuleUUID  -- association [1..1]
LEFT OUTER JOIN I_AssortmentModuleText AS _Text ON _Text.AssortmentModuleUUID = AssortmentModuleUUID  -- association [1..*]
LEFT OUTER JOIN I_ProdToExplicitAsstmtMdlTP AS _Products ON _Products.AssortmentModuleUUID = AssortmentModuleUUID  -- association [1..*]
LEFT OUTER JOIN I_ExplctAssMdlUsrProdExclsnTP AS _Exclusions ON _Exclusions.AssortmentModuleObjectUUID = AssortmentModuleUUID AND _Exclusions.AssortmentModuleUser = AssortmentModuleUser  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _User ON _User.ContactCardID = LastChangedByUserName  -- association [0..1]
LEFT OUTER JOIN R_ProdStoreToExplctAsstmtMdlTP AS _ProductsWithoutExclusion ON _ProductsWithoutExclusion.AssortmentModuleUUID = AssortmentModuleUUID AND _ProductsWithoutExclusion.AssortmentModuleUser = AssortmentModuleUser  -- association [0..*]
;