I_CNTRBTSCENGENDATA

@AbapCatalog.sqlViewName: 'ICRRCSGDEN'
@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_CntrbtScenGenData
  as select from ehsdsv_cs_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,

      --Exposure Scenario - Short Title UUID
      pcesshorttitlephrs1uuid                                              as PCESShortTitlePhrs1UUID,

      --Exposure Scenario - Short Title UUID
      pcesshorttitlephrs2uuid                                              as PCESShortTitlePhrs2UUID,

      --Exposure Scenario - Short Title UUID
      pcesshorttitlephrs3uuid                                              as PCESShortTitlePhrs3UUID,

      --Exposure Scenario - Short Title UUID
      pcesshorttitlephrs4uuid                                              as PCESShortTitlePhrs4UUID,

      --Exposure Scenario - Short Title UUID
      pcesshorttitlephrs5uuid                                              as PCESShortTitlePhrs5UUID,

      --Exposure Scenario - Short Title UUID
      pcesshorttitlephrs6uuid                                              as PCESShortTitlePhrs6UUID,

      --Contributing Scenario - Environment Release Category
      pcesenvrmtrelcatphrs1uuid                                           as PCESEnvrmtRelCatPhrs1UUID,

      --Contributing Scenario - Environment Release Category
      pcesenvrmtrelcatphrs2uuid                                           as PCESEnvrmtRelCatPhrs2UUID,

      --Contributing Scenario - Environment Release Category
      pcesenvrmtrelcatphrs3uuid                                           as PCESEnvrmtRelCatPhrs3UUID,

      --Contributing Scenario - Environment Release Category
      pcesenvrmtrelcatphrs4uuid                                           as PCESEnvrmtRelCatPhrs4UUID,

      --Contributing Scenario - Environment Release Category
      pcesenvrmtrelcatphrs5uuid                                           as PCESEnvrmtRelCatPhrs5UUID,

      --Contributing Scenario - Environment Release Category
      pcesenvrmtrelcatphrs6uuid                                           as PCESEnvrmtRelCatPhrs6UUID,

      --Contributing Scenario - Process Category UUID
      pcesprocesscatphrs1uuid                                              as PCESProcessCatPhrs1UUID,

      --Contributing Scenario - Process Category UUID
      pcesprocesscatphrs2uuid                                              as PCESProcessCatPhrs2UUID,

      --Contributing Scenario - Process Category UUID
      pcesprocesscatphrs3uuid                                              as PCESProcessCatPhrs3UUID,

      --Contributing Scenario - Process Category UUID
      pcesprocesscatphrs4uuid                                              as PCESProcessCatPhrs4UUID,

      --Contributing Scenario - Process Category UUID
      pcesprocesscatphrs5uuid                                              as PCESProcessCatPhrs5UUID,

      --Contributing Scenario - Process Category UUID
      pcesprocesscatphrs6uuid                                              as PCESProcessCatPhrs6UUID,

      --Contributing Scenario - Product Category
      pcesproductcatphrs1uuid                                              as PCESProductCatPhrs1UUID,

      --Contributing Scenario - Product Category
      pcesproductcatphrs2uuid                                              as PCESProductCatPhrs2UUID,

      --Contributing Scenario - Product Category
      pcesproductcatphrs3uuid                                              as PCESProductCatPhrs3UUID,

      --Contributing Scenario - Product Category
      pcesproductcatphrs4uuid                                              as PCESProductCatPhrs4UUID,

      --Contributing Scenario - Product Category
      pcesproductcatphrs5uuid                                              as PCESProductCatPhrs5UUID,

      --Contributing Scenario - Product Category
      pcesproductcatphrs6uuid                                              as PCESProductCatPhrs6UUID,

      --Contributing Scenario - Product Sub Category
      pcesproductsubcatphrs1uuid                                           as PCESProductSubCatPhrs1UUID,

      --Contributing Scenario - Product Sub Category
      pcesproductsubcatphrs2uuid                                           as PCESProductSubCatPhrs2UUID,

      --Contributing Scenario - Product Sub Category
      pcesproductsubcatphrs3uuid                                           as PCESProductSubCatPhrs3UUID,

      --Contributing Scenario - Article Category
      pcesarticlecatphrs1uuid                                              as PCESArticleCatPhrs1UUID,

      --Contributing Scenario - Article Category
      pcesarticlecatphrs2uuid                                              as PCESArticleCatPhrs2UUID,

      --Contributing Scenario - Article Category
      pcesarticlecatphrs3uuid                                              as PCESArticleCatPhrs3UUID,

      --Contributing Scenario - Article Category
      pcesarticlecatphrs4uuid                                              as PCESArticleCatPhrs4UUID,

      --Contributing Scenario - Article Category
      pcesarticlecatphrs5uuid                                              as PCESArticleCatPhrs5UUID,

      --Contributing Scenario - Article Category
      pcesarticlecatphrs6uuid                                              as PCESArticleCatPhrs6UUID,

      --Contributing Scenario - Article Sub Category
      pcesarticlesubcatphrs1uuid                                           as PCESArticleSubCatPhrs1UUID,

      --Contributing Scenario - Article Sub Category
      pcesarticlesubcatphrs2uuid                                           as PCESArticleSubCatPhrs2UUID,

      --Contributing Scenario - Article Sub Category
      pcesarticlesubcatphrs3uuid                                           as PCESArticleSubCatPhrs3UUID,

      --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_CS_GEN"
],
"ASSOCIATED":
[
"I_CMPLRQRSLT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/