I_EXPLICITASSTMTMODULEVERSION

CDS View

Assortment Module Version

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

Used by 7 CDS view(s) 4 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_AsstmtMdlMaxVersValidityEnd view from COMPOSITE Valid-To Date of Last Assortment Module Version
I_CurrentlyValdAsstmtMdlVers view_entity from BASIC Currently Valid Asstmt Module Version
I_ExplctAsstmtMdlExclsnRatio view_entity from COMPOSITE
I_ExplicitAsstmtMdlVersionTP view_entity from TRANSACTIONAL Assortment Module Version
I_ProdToExplicitAsstmtModule view inner COMPOSITE Product Assignment to Assortment Module
P_NrOfFutrVersionsForAsstmtMdl view from COMPOSITE
P_NrOfProdsForActvASMVersion view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY AssortmentModuleUUID AssortmentModuleGroupUUID,AssortmentModuleUUID 3
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUserName LastChangedByUserName 1 
@AbapCatalog.sqlViewName: 'IEXPLASMMODVERS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Assortment Module Version'
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM: {
  viewType: #BASIC,

  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}
@ObjectModel: {
    usageType: {
        serviceQuality: #A,
        sizeCategory: #M,
        dataClass: #MASTER
   }
}
@AccessControl: {
  authorizationCheck: #CHECK
}
define view I_ExplicitAsstmtModuleVersion
  as select from rfm_asm_explicit
    inner join   rfm_asm_vers_grp on rfm_asm_explicit.module_guid = rfm_asm_vers_grp.member_guid
  association [1..1] to I_ExplicitAssortmentModule as _Module       on $projection.AssortmentModuleUUID = _Module.AssortmentModuleUUID
  association [0..*] to I_AssortmentModuleText     as _Descriptions on $projection.AssortmentModuleVersionUUID = _Descriptions.AssortmentModuleUUID
{
  key cast( rfm_asm_explicit.module_guid
            as rfm_asm_version_guid preserving type ) as AssortmentModuleVersionUUID,
      rfm_asm_vers_grp.mod_grp_guid                   as AssortmentModuleUUID,
      rfm_asm_explicit.module_name                    as AssortmentModuleName,
      cast ( rfm_asm_explicit.valid_from
      as rfm_asm_version_valid_from preserving type ) as ValidityStartDate,
      cast ( rfm_asm_explicit.valid_to
      as rfm_asm_version_valid_to preserving type )   as ValidityEndDate,
      TSTMP_TO_DATS( rfm_asm_explicit.last_changed_at,
                     $session.user_timezone,
                     $session.client,
                     'NULL' )                         as LastChangeDate,
      rfm_asm_explicit.last_changed_at                as LastChangeDateTime,
      rfm_asm_explicit.last_changed_by                as LastChangedByUserName,
      _Module,
      _Descriptions
}

Learn More