I_EXPSRSCENGENDATADRFT

CDS View

General Data - Draft

I_EXPSRSCENGENDATADRFT is a CDS View in S/4HANA. General Data - Draft. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ExpsrScenGenDataActiveDraft view from COMPOSITE General Data Active - Draft 
@AbapCatalog.sqlViewName: 'ICRRESGEND'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #BASIC
@ObjectModel:
{
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #B
  }
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'General Data - Draft'
define view I_ExpsrScenGenDataDrft
  as select from ehsdsw_es_gen

      -- Associotion to Copmpliance Requirement Result needed for authrization check
      association [1..1] to I_CmplRqRslt as _CmplRqRslt on $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

{

  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,

      -- Associotion to Copmpliance Requirement Result  nfor DCL
     _CmplRqRslt //needed for authrization check


}

where
  draftentityoperationcode <> 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHSDSW_ES_GEN"
],
"ASSOCIATED":
[
"I_CMPLRQRSLT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More