I_EXPLICITASSTMTMDLVERSIONTP

CDS View

Assortment Module Version

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

Used by 4 CDS view(s) 3 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_ExplicitAssortmentModuleVers 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_ProdToExplctAsstmtMdlVersTP view_entity inner TRANSACTIONAL Product Assignable to Assortment Module Version

Fields (3)

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

@AccessControl: {
  authorizationCheck: #CHECK
}

@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

  composition [0..*] 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 AssortmentModuleVersionUUID,
      AssortmentModuleName,
      ValidityStartDate,
      ValidityEndDate,
      Version.AssortmentModuleUUID,
      Version.LastChangeDate,
      Version.LastChangeDateTime,
      Version.LastChangedByUserName,

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

      _Text,
      _Product,
      _Exclusion,
      _Module,
      _User
}

Learn More