I_CntrbtScenEnvrmtRelPrvtnTP

@AbapCatalog:
{
  sqlViewName: 'ICRRENPVRLTP',
  compiler.compareFilter: true
}

@EndUserText.label: 'Prevention of Release to Environment - TP'

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  modelCategory: #BUSINESS_OBJECT,
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  writeDraftPersistence: 'EHSDSW_CS_ENVPRE',
  writeActivePersistence: 'EHSDSV_CS_ENVPRE',
  semanticKey:  [ 'PCESReleasePreventionUUID' ],
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
  },
  entityChangeStateId: 'LastChangeDateTime'
}
define view I_CntrbtScenEnvrmtRelPrvtnTP
  as select from I_CntrbtScenEnvrmtRelPrvtn

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

{

  key PCESReleasePreventionUUID,

      --Compliance Assessment UUID
      @ObjectModel.mandatory: true
      CmplRqRsltUUID,

      --Release Measure
      PCESRelPrvtnMsrPhrs1UUID,

      --Release Measure
      PCESRelPrvtnMsrPhrs2UUID,

      --Release Measure
      PCESRelPrvtnMsrPhrs3UUID,

      --Release Measure
      PCESRelPrvtnMsrPhrs4UUID,

      --Release Measure
      PCESRelPrvtnMsrPhrs5UUID,

      --Release Measure
      PCESRelPrvtnMsrPhrs6UUID,

      --Effectiveness Air Lower Value
      PCESEffctvnAirLowrValue,

      -- Effectiveness Air Lower Value Text
      PCESEffctvnAirLowrValueTxt,

      --Effectiveness Air Lower Value Operator
      PCESEffctvnAirLowrValueOptr,

      -- Effectiveness Air Upper Value
      PCESEffctvnAirUprValue,

      -- Effectivenes Air Upper Value Text
      PCESEffctvnAirUprValueTxt,

      --Effectiveness Air Upper Value Operator
      PCESEffctvnAirUprValueOptr,

      --Effectiveness Air Unit
      PCESEffctvnAirUoM,

      --Effectiveness Lower Value
      PCESEffctvnSoilLowrValue,

      -- Effectiveness Lower Value Text
      PCESEffctvnSoilLowrValueTxt,

      -- Effectiveness Lower Value Operator
      PCESEffctvnSoilLowrValueOptr,

      --Effectiveness upper Value
      PCESEffctvnSoilUprValue,

      -- Effectiveness Upper Value Text
      PCESEffctvnSoilUprValueTxt,

      -- Effectiveness Upper Value Operator
      PCESEffctvnSoilUprValueOptr,

      -- Effectiveness Soil Unit
      PCESEffctvnSoilUoM,

      --Effectiveness  Lower Value
      PCESEffctvnWaterLowrValue,

      -- Effectiveness Lower Value Text
      PCESEffctvnWaterLowrValueTxt,

      -- Effectiveness Lower Value Operator
      PCESEffctvnWaterLowrValueOptr,

      --Effectiveness upper Value
      PCESEffctvnWaterUprValue,

      -- Effectiveness Upper Value Text
      PCESEffctvnWaterUprValueTxt,

      -- Effectiveness Upper Value Operator
      PCESEffctvnWaterUprValueOptr,

      -- Effectiveness Water unit
      PCESEffctvnWaterUoM,

      @ObjectModel.readOnly: true
      CreationDateTime,

      @ObjectModel.readOnly: true
      CreatedByUser,

      @ObjectModel.readOnly: true
      LastChangeDateTime,

      @ObjectModel.readOnly: true
      LastChangedByUser,


      /* Associations */
      //      _RegisteredBy,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _CmplRqRslt,
      _CreatedByUser,
      _LastChangedByUser

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNTRBTSCENENVRMTRELPRVTN"
],
"ASSOCIATED":
[
"I_CMPLRQRSLTPCESENVRMTASSMTTP",
"I_USER"
],
"BASE":
[
"I_CNTRBTSCENENVRMTRELPRVTN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/