I_ASSMDLUSERTOEXPLICITASSMDLTP

CDS View

Assortment User Assignment to Assortment Module

I_ASSMDLUSERTOEXPLICITASSMDLTP is a CDS View in S/4HANA. Assortment User Assignment to Assortment Module. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_AssMdlUserToExplicitAssMdl view_entity projection CONSUMPTION Assortment User Assignment to Assortment Module 

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Assortment User Assignment to Assortment Module'

@VDM: {
  viewType: #TRANSACTIONAL,

  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #M,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'RetailSite'
}
define root view entity I_AssMdlUserToExplicitAssMdlTP
  as select from I_UserToExplicitAsstmtModule as AssortmentModuleUser
  association [1..1] to I_ExplicitAssortmentModuleTP  as _ExplicitAssortmentModule on  _ExplicitAssortmentModule.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [1..*] to I_AssortmentModuleText        as _Text                     on  _Text.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [1..*] to I_ProdToExplicitAsstmtMdlTP   as _Products                 on  _Products.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [1..*] to I_ExplctAssMdlUsrProdExclsnTP as _Exclusions               on  _Exclusions.AssortmentModuleObjectUUID = $projection.AssortmentModuleUUID
                                                                                   and _Exclusions.AssortmentModuleUser       = $projection.AssortmentModuleUser
  association [0..1] to I_UserContactCard             as _User                     on  _User.ContactCardID = $projection.LastChangedByUserName
  association [0..*] to R_ProdStoreToExplctAsstmtMdlTP as _ProductsWithoutExclusion 
    on _ProductsWithoutExclusion.AssortmentModuleUUID = $projection.AssortmentModuleUUID
    and _ProductsWithoutExclusion.AssortmentModuleUser = $projection.AssortmentModuleUser
{
  key AssortmentModuleUUID,
  key AssortmentModuleUser,
      AssortmentModuleName,
      ValidityStartDate,
      ValidityEndDate,
      AssortmentModuleUser.LastChangeDate,
      AssortmentModuleUser.LastChangeDateTime,
      AssortmentModuleUser.LastChangedByUserName,

      /*For DCL*/
      AssortmentModuleUser.SalesOrganization,
      AssortmentModuleUser.DistributionChannel,


      _ExplicitAssortmentModule,
      _Exclusions,
      _ExclusionRatio,
      _Text,
      _Products,
      _Site,
      _ProductsWithoutExclusion,
      _User
}

Learn More