I_ASSMDLUSERTOEXPLCTASSMDLTP_2

CDS View

Assortment User Assignment to Assortment Module

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

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_AssMdlUserToExplicitAssMdl_2 view_entity projection CONSUMPTION Assortment User Assignment to Assortment Module
C_AsstmtMdlUserToAsstmtMdlTP view_entity projection CONSUMPTION Assortment User Assignment to Assortment Module
C_UserToExplicitAsstmtMdl 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: 'AssortmentModule'
}
define root view entity I_AssMdlUserToExplctAssMdlTP_2
  as select from I_UserToExplicitAsstmtModule_2 as AssortmentModuleUser
  association [1..1] to I_ExplicitAssortmentModuleTP   as _ExplicitAssortmentModule on  _ExplicitAssortmentModule.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [0..*] 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 [1..*] to I_AsstmtMdlUsrProdExclsnTP_2   as _Exclusions_2             on  _Exclusions_2.AssortmentModuleUUID = $projection.AssortmentModuleUUID
                                                                                    and _Exclusions_2.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
                                                                                    and _ProductsWithoutExclusion.AssignmentValidityStartDate = $projection.ValidityStartDate


{
  key AssortmentModuleUUID,
  key AssortmentModuleUser,
  key ValidityStartDate,
      AssortmentModuleName,
      ValidityEndDate,
      AssortmentModuleUser.LastChangeDate,
      AssortmentModuleUser.LastChangeDateTime,
      AssortmentModuleUser.LastChangedByUserName,

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


      _ExplicitAssortmentModule,
      _Exclusions,
      _Exclusions_2,
      _ProductsWithoutExclusion,
      _ExclusionRatio,
      _Text,
      _Products,
      _Site,
      _User
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USERTOEXPLICITASSTMTMODULE_2"
],
"ASSOCIATED":
[
"I_ASSORTMENTMODULETEXT",
"I_ASSTMTMDLUSRPRODEXCLSNTP_2",
"I_EXCLSNRATIOFORASSTMTMDLUSER",
"I_EXPLCTASSMDLUSRPRODEXCLSNTP",
"I_EXPLICITASSORTMENTMODULETP",
"I_PRODTOEXPLICITASSTMTMDLTP",
"I_SITE",
"I_USERCONTACTCARD",
"R_PRODSTORETOEXPLCTASSTMTMDLTP"
],
"BASE":
[
"I_USERTOEXPLICITASSTMTMODULE_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More