I_EXPLICITASSTMTMDLVERSIONTP

CDS View

Assortment Module Version

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

Used by 6 CDS view(s) 5 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_ExplicitAssortmentModuleVers view_entity projection CONSUMPTION Assortment Module Version
C_AssortmentModuleVersion_AI view_entity projection CONSUMPTION Assortment Module Version
C_AssortmentModuleVersionTP view_entity projection CONSUMPTION Assortment Module Version
I_ExplicitAsstmtMdlVersionTTP view_entity inner TRANSACTIONAL Assortment Module Description
I_ProdAssgblToExplctMdlVersTP view_entity from TRANSACTIONAL Product Assignable to Assortment Module Version
I_ProdToExplctAsstmtMdlVersTP view_entity inner TRANSACTIONAL Product Assignment to Asstmt Mdl Version

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleVersionUUID AssortmentModuleVersionUUID 2
AssortmentModuleName AssortmentModuleName 2
AssortmentModuleUUID AssortmentModuleObjectUUID 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1 
@EndUserText.label: 'Assortment Module Version'

@AccessControl: {
  authorizationCheck: #MANDATORY
}

@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_ExplicitAsstmtMdlVersionTP
  as select from I_ExplicitAsstmtModuleVersion as Version
      inner to one join I_AsstmtMdlMgmtSolnGenSetting on I_AsstmtMdlMgmtSolnGenSetting.AsstmtMdlMgmtSolnIsEnbld = 'X'

  composition [1..*] of I_ExplicitAsstmtMdlVersionTTP as _Text 
  association [0..*] to I_ProdToExplctAsstmtMdlVersTP as _Product   on _Product.AssortmentModuleUUID = $projection.AssortmentModuleVersionUUID
  association [0..*] to I_ExplctAssMdlUsrProdExclsnTP as _Exclusion on _Exclusion.AssortmentModuleObjectUUID = $projection.AssortmentModuleUUID
  association [1..1] to I_ExplicitAssortmentModuleTP  as _Module    on _Module.AssortmentModuleUUID = $projection.AssortmentModuleUUID
  association [0..1] to I_UserContactCard             as _User      on _User.ContactCardID = $projection.LastChangedByUserName
{
  key Version.AssortmentModuleVersionUUID,
      Version.AssortmentModuleName,
      Version.ValidityStartDate,
      Version.ValidityEndDate,
      Version.AssortmentModuleUUID,
      Version.LastChangeDate,
      Version.LastChangeDateTime,
      Version.LastChangedByUserName,

      cast(case when Version.ValidityEndDate < $session.user_date then 'X' else '' end as boolean ) as IsExpired,
      Version._Descriptions[1: Language=$session.system_language].AssortmentModuleObjectDesc          as AssortmentModuleVersionDescILL,

      _Text,
      _Product,
      _Exclusion,
      _Module,
      _User
}

Learn More