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
    inner to one join I_AsstmtMdlMgmtSolnGenSetting on I_AsstmtMdlMgmtSolnGenSetting.AsstmtMdlMgmtSolnIsEnbld = 'X'

  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 AssortmentModuleUser.AssortmentModuleUUID,
  key AssortmentModuleUser.AssortmentModuleUser,
      AssortmentModuleUser.AssortmentModuleName,
      AssortmentModuleUser.ValidityStartDate,
      AssortmentModuleUser.ValidityEndDate,
      AssortmentModuleUser.LastChangeDate,
      AssortmentModuleUser.LastChangeDateTime,
      AssortmentModuleUser.LastChangedByUserName,

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


      _ExplicitAssortmentModule,
      _Exclusions,
      _Text,
      _Products,
      AssortmentModuleUser._Site,
      _ProductsWithoutExclusion,
      _User
}

Learn More