I_EHSRskAssessmentAuthznFields

DDL: I_EHSRSKASSESSMENTAUTHZNFIELDS SQL: IEHSRASAUTH Type: view BASIC Package: EHHSS_BO_RAS_IMPL

EHS Risk Assessment Authorization Fields

I_EHSRskAssessmentAuthznFields is a Basic CDS View that provides data about "EHS Risk Assessment Authorization Fields" in SAP S/4HANA. It reads from 1 data source (I_EHSRiskAssessment) and exposes 16 fields with key field EHSRiskAssessmentUUID. Part of development package EHHSS_BO_RAS_IMPL.

Data Sources (1)

SourceAliasJoin Type
I_EHSRiskAssessment I_EHSRiskAssessment from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEHSRASAUTH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EHS Risk Assessment Authorization Fields view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskAssessmentUUID EHSRiskAssessmentUUID
EHSTaskHostObjectInstance
EHSRiskAssessmentType EHSRiskAssessmentType
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup
BusinessArea BusinessArea
Plant Plant
CostCenter CostCenter
CompanyCode CompanyCode
ControllingArea ControllingArea
EHSLocationUUIDHex
_EHSRiskAssessmentType _EHSRiskAssessmentType
_EHSLocationAuthGroup _EHSLocationAuthGroup
_BusinessArea _BusinessArea
_Plant _Plant
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
@AbapCatalog.sqlViewName: 'IEHSRASAUTH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'EHS Risk Assessment Authorization Fields'
@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #M,         // < 100.000

                         dataClass: #TRANSACTIONAL }
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.modelingPattern: #NONE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
define view I_EHSRskAssessmentAuthznFields as select from I_EHSRiskAssessment {
  key EHSRiskAssessmentUUID,
  cast(bintohex(EHSRiskAssessmentUUID) as sibfboriid) as EHSTaskHostObjectInstance,
  EHSRiskAssessmentType,
  EHSLocationAuthorizationGroup,
  BusinessArea,
  Plant,
  CostCenter,
  CompanyCode,
  ControllingArea,
// Begin correction 3281646 - 14.12.2022  **************************

  cast(EHSLocationUUIDHex as ehfnd_loc_root_uuid_hex preserving type) as EHSLocationUUIDHex,      ////correction 3295181 - 01.03.2023

// End correction 3281646 - 14.12.2022  ****************************


  _EHSRiskAssessmentType,
  _EHSLocationAuthGroup,
  _BusinessArea,
  _Plant,
//  _CostCenter,

  _CompanyCode,
  _ControllingArea
}