I_EXPSRSCENGENDATA

CDS View

General Data

I_EXPSRSCENGENDATA is a CDS View in S/4HANA. General Data. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ExpsrScenGenDataActiveDraft view union_all COMPOSITE General Data Active - Draft
I_ExpsrScenGenDataTP view from TRANSACTIONAL General Data - TP 
@AbapCatalog.sqlViewName: 'ICRRESGEN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #MANDATORY,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

@EndUserText.label: 'General Data'

@VDM.viewType: #BASIC

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{

    usageType:
    {
      dataClass: #TRANSACTIONAL,
      sizeCategory: #L,
      serviceQuality: #B
    },
    representativeKey: 'PCESGeneralDataUUID'
}

define view I_ExpsrScenGenData
  as select from ehsdsv_es_gen

  association [1..1] to I_CmplRqRslt as _CmplRqRslt        on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

  --Link to user data
  association [0..1] to I_User       as _CreatedByUser     on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User       as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID

{

  key  pcesgeneraldatauuid                                                  as PCESGeneralDataUUID,

       --Compliance Assessment UUID
       cmplrqrsltuuid                                                       as CmplRqRsltUUID,

       --Version Date
       pcesversiondate                                                      as PCESVersionDate,

       --General Data - Short Title1
       pcesshorttitlephrs1uuid                                              as PCESShortTitlePhrs1UUID,

       --General Data - Short Title2
       pcesshorttitlephrs2uuid                                              as PCESShortTitlePhrs2UUID,

       --General Data - Short Title3
       pcesshorttitlephrs3uuid                                              as PCESShortTitlePhrs3UUID,

       --General Data - Short Title4
       pcesshorttitlephrs4uuid                                              as PCESShortTitlePhrs4UUID,

       --General Data - Short Title5
       pcesshorttitlephrs5uuid                                              as PCESShortTitlePhrs5UUID,

       --General Data - Short Title6
       pcesshorttitlephrs6uuid                                              as PCESShortTitlePhrs6UUID,

       --General Data - Life cycle stages
       pceslifecyclestagephrsuuid                                           as PCESLifeCycleStagePhrsUUID,

       --General Data - Sector of use1
       pcessectorofusephrs1uuid                                             as PCESSectorOfUsePhrs1UUID,

       --General Data - Sector of use2
       pcessectorofusephrs2uuid                                             as PCESSectorOfUsePhrs2UUID,

       --General Data - Sector of use3
       pcessectorofusephrs3uuid                                             as PCESSectorOfUsePhrs3UUID,

       --General Data - Sector of use4
       pcessectorofusephrs4uuid                                             as PCESSectorOfUsePhrs4UUID,

       --General Data - Sector of use5
       pcessectorofusephrs5uuid                                             as PCESSectorOfUsePhrs5UUID,

       --General Data - Sector of use6
       pcessectorofusephrs6uuid                                             as PCESSectorOfUsePhrs6UUID,

       --Create at date/time
       @Semantics.systemDateTime.createdAt: true
       cast(creationdatetime  as ehfnd_bo_crea_date_time preserving type )  as CreationDateTime,

       --Create by user
       @ObjectModel.readOnly: true
       @Semantics.user.createdBy: true
       cast(createdbyuser as ehfnd_bo_crea_uname preserving type )          as CreatedByUser,

       --Update at date/time
       @Semantics.systemDateTime.lastChangedAt: true
       cast(lastchangedatetime as ehfnd_bo_lchg_date_time preserving type ) as LastChangeDateTime,

       --Update by user
       @ObjectModel.readOnly: true
       @Semantics.user.lastChangedBy: true
       cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type )      as LastChangedByUser,

       /**** Associations ****/
       _CmplRqRslt,
       _CreatedByUser,
       _LastChangedByUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHSDSV_ES_GEN"
],
"ASSOCIATED":
[
"I_CMPLRQRSLT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More