I_EXPLICITASSORTMENTMODULE

CDS View

Assortment Module

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

Used by 10 CDS view(s) 5 fields

CDS Views using this table (10)

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 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

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleName AssortmentModuleName 1
KEY AssortmentModuleUUID AssortmentModuleUUID 6
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUserName LastChangedByUserName 1 
@AbapCatalog.sqlViewName: 'IEXPLASMMOD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@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 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RFM_ASM_EXP_MOD"
],
"ASSOCIATED":
[
"I_ASSORTMENTMODULETEXT",
"I_ASSTMTMDLMAXVERSVALIDITYEND",
"I_ASSTMTMDLUSERPRODUCTEXCLSN",
"I_EXPLICITASSTMTMODULEVERSION",
"I_NROFASSTMTUSERSFORASSTMTMDL",
"I_NROFFUTRVERSIONSFORASSTMTMDL",
"I_PRODTOEXPLICITASSTMTMODULE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More