I_EXPLICITASSORTMENTMODULE

CDS View

Assortment Module

I_EXPLICITASSORTMENTMODULE is a CDS View in S/4HANA. Assortment Module. It contains 8 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 8 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_AsstmtMdlUsrProdExclsnTP_2 view_entity inner TRANSACTIONAL Product Exclusion from Assortment Module for Assortment User
I_ExplctAssMdlUsrProdExclsnTP view_entity inner TRANSACTIONAL Product Exclusion from Assortment Module for Assortment User
I_ExplicitAssortmentModuleTP view_entity from TRANSACTIONAL Assortment Module
I_ExplicitAssortmentModuleTTP view_entity inner TRANSACTIONAL Assortment Module - Text
I_ExplicitAssortmentModuleVH view_entity from COMPOSITE Assortment Module
I_NrOfAsstmtUsersForAsstmtMdl view from COMPOSITE Number of Currently Valid Assortment Users in Asstmt Module
I_NrOfFutrVersionsForAsstmtMdl view from COMPOSITE Number of Planned Assortment Module Versions
I_ProdToExplicitAsstmtModule view from COMPOSITE Product Assignment to Assortment Module
I_UserToExplicitAsstmtModule view inner COMPOSITE Assortment User Assignment to Assortment Module
I_UserToExplicitAsstmtModule_2 view inner COMPOSITE Assortment User Assignment to Assortment Module
I_VersionDetail view_entity inner COMPOSITE Version Listing

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleName AssortmentModuleName 3
KEY AssortmentModuleUUID AssortmentModuleUUID 7
_MaxVersionValidityEnd _MaxVersionValidityEnd 1
_NrOfAssortmentUsers _NrOfAssortmentUsers 1
_NrOfFutureVersions _NrOfFutureVersions 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUserName LastChangedByUserName 1 
@EndUserText.label: 'Assortment Module'

@VDM: {
  viewType: #BASIC,

  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #A,
        sizeCategory: #M,
        dataClass: #MASTER
   }
}
@AccessControl: {
  authorizationCheck: #CHECK
}
define view entity I_ExplicitAssortmentModule
  as select from rfm_asm_exp_mod
  association [1..*] to I_ExplicitAsstmtModuleVersion  as _Versions              on $projection.AssortmentModuleUUID = _Versions.AssortmentModuleUUID
  association [0..*] to I_AssortmentModuleText         as _Descriptions          on $projection.AssortmentModuleUUID = _Descriptions.AssortmentModuleUUID
  association [0..*] to I_ProdToExplicitAsstmtModule   as _Product               on _Product.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [0..*] to I_AsstmtMdlUserProductExclsn   as _Exclusion             on _Exclusion.AssortmentModuleObjectUUID = $projection.AssortmentModuleUUID
  association [0..1] to I_AsstmtMdlMaxVersValidityEnd  as _MaxVersionValidityEnd on _MaxVersionValidityEnd.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [0..1] to I_NrOfFutrVersionsForAsstmtMdl as _NrOfFutureVersions    on _NrOfFutureVersions.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [0..1] to I_NrOfAsstmtUsersForAsstmtMdl  as _NrOfAssortmentUsers   on _NrOfAssortmentUsers.AssortmentModuleUUID = $projection.AssortmentModuleUUID

{
  key module_guid                                                                       as AssortmentModuleUUID,
      module_name                                                                       as AssortmentModuleName,

      // LastChangeDate exists only for compatibility reasons

      tstmp_to_dats( last_changed_at, $session.user_timezone, $session.client, 'NULL' ) as LastChangeDate,
      last_changed_at                                                                   as LastChangeDateTime,
      last_changed_by                                                                   as LastChangedByUserName,

      _Product,
      _Descriptions,
      _Exclusion,
      _Versions,
      _MaxVersionValidityEnd,
      _NrOfFutureVersions,
      _NrOfAssortmentUsers
}

Learn More