I_ExpsrScenGenDataActiveDraft

DDL: I_EXPSRSCENGENDATAACTIVEDRAFT Type: view COMPOSITE

General Data Active - Draft

I_ExpsrScenGenDataActiveDraft is a Composite CDS View that provides data about "General Data Active - Draft" in SAP S/4HANA. It reads from 2 data sources (I_ExpsrScenGenData, I_ExpsrScenGenDataDrft) and exposes 3 fields.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_ExpsrScenGenData I_ExpsrScenGenData union_all
I_ExpsrScenGenDataDrft I_ExpsrScenGenDataDrft from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICRRESGENACTDRFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label General Data Active - Draft view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
ComplianceAssessmentUUIDCmplRqRsltUUID
ComplianceAssessmentUUIDCmplRqRsltUUID
AssoctionsneededforDCL_CmplRqRslt 
@AbapCatalog: 
{
  sqlViewName: 'ICRRESGENACTDRFT',
  compiler.compareFilter: true
}

@AccessControl.authorizationCheck: #MANDATORY

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'General Data Active - Draft'

@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory:  #L,
  dataClass: #TRANSACTIONAL }

@VDM.viewType: #COMPOSITE

define view I_ExpsrScenGenDataActiveDraft
  as select from I_ExpsrScenGenDataDrft
{

      -- Exposure Scenario General Data -UUID
  key PCESGeneralDataUUID as PCESGeneralDataUUID,

      -- Compliance Assessment UUID
      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,

      -- Assoctions needed for DCL
      _CmplRqRslt

}

union all select from I_ExpsrScenGenData
{

       -- Exposure Scenario General Data -UUID
  key  PCESGeneralDataUUID as PCESGeneralDataUUID,

       -- Compliance Assessment UUID
       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,

       -- Assoctions needed for DCL
       _CmplRqRslt

}

Learn More