I_AssMdlUserToExplctAssMdlTP_2

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_AssMdlUserToExplctAssMdlTP_2.
-- 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_AssMdlUserToExplctAssMdlTP_2 AS
SELECT
  AssortmentModuleUser.AssortmentModuleUUID AS AssortmentModuleUUID,
  AssortmentModuleUser.AssortmentModuleUser AS AssortmentModuleUser,
  AssortmentModuleUser.ValidityStartDate AS ValidityStartDate,
  AssortmentModuleUser.AssortmentModuleName AS AssortmentModuleName,
  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._ExclusionRatio AS _ExclusionRatio,
  AssortmentModuleUser._Site AS _Site
FROM I_UserToExplicitAsstmtModule_2 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 [0..*]
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_AsstmtMdlUsrProdExclsnTP_2 AS _Exclusions_2 ON _Exclusions_2.AssortmentModuleUUID = AssortmentModuleUUID AND _Exclusions_2.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 AND _ProductsWithoutExclusion.AssignmentValidityStartDate = ValidityStartDate  -- association [0..*]
;