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.system_date then 'X' else '' end as boolean ) as IsExpired,
      _Descriptions[1: Language=$session.system_language].AssortmentModuleObjectDesc          as AssortmentModuleVersionDescILL,

      _Text,
      _Product,
      _Exclusion,
      _Module,
      _User
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSORTMENTMODULETEXT",
"I_EXPLICITASSTMTMODULEVERSION"
],
"ASSOCIATED":
[
"I_EXPLCTASSMDLUSRPRODEXCLSNTP",
"I_EXPLICITASSORTMENTMODULETP",
"I_EXPLICITASSTMTMDLVERSIONTTP",
"I_PRODTOEXPLCTASSTMTMDLVERSTP",
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More