I_ExplicitAsstmtMdlVersionTP

DDL: I_EXPLICITASSTMTMDLVERSIONTP Type: view_entity TRANSACTIONAL

Assortment Module Version

I_ExplicitAsstmtMdlVersionTP is a Transactional CDS View that provides data about "Assortment Module Version" in SAP S/4HANA. It reads from 1 data source (I_ExplicitAsstmtModuleVersion) and exposes 15 fields with key field AssortmentModuleVersionUUID. It has 5 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_ExplicitAsstmtModuleVersion Version from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_ProdToExplctAsstmtMdlVersTP _Product _Product.AssortmentModuleUUID = $projection.AssortmentModuleVersionUUID
[0..*] I_ExplctAssMdlUsrProdExclsnTP _Exclusion _Exclusion.AssortmentModuleObjectUUID = $projection.AssortmentModuleUUID
[1..1] I_ExplicitAssortmentModuleTP _Module _Module.AssortmentModuleUUID = $projection.AssortmentModuleUUID
[0..1] I_UserContactCard _User _User.ContactCardID = $projection.LastChangedByUserName
[0..*] I_ExplicitAsstmtMdlVersionTTP _Text

Annotations (8)

NameValueLevelField
EndUserText.label Assortment Module Version view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name AssortmentModule view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleVersionUUID AssortmentModuleVersionUUID
AssortmentModuleName AssortmentModuleName
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
AssortmentModuleUUID I_ExplicitAsstmtModuleVersion AssortmentModuleUUID
LastChangeDate I_ExplicitAsstmtModuleVersion LastChangeDate
LastChangeDateTime I_ExplicitAsstmtModuleVersion LastChangeDateTime
LastChangedByUserName I_ExplicitAsstmtModuleVersion LastChangedByUserName
IsExpired
AssortmentModuleVersionDescILL
_Text _Text
_Product _Product
_Exclusion _Exclusion
_Module _Module
_User _User 
@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