I_EHSJOBATLOCATION

CDS View

Job at Location

I_EHSJOBATLOCATION is a CDS View in S/4HANA. Job at Location. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_EHSJobForSafetyInfo view from COMPOSITE EHS Job for Safety Relevant Information
C_EHSJobForSafetyInsights view from CONSUMPTION EHS Job for Safety Insights
I_EHSJobAtLocationTP view from TRANSACTIONAL Job At Location
I_EHSJobForIdentifyRisks view union COMPOSITE Interface view for the Jobs used in the EHS Risks
P_EHSJobStepForIdentifyRisks view inner CONSUMPTION
P_EHSJobStepForIdentifyRisks view union CONSUMPTION
@EndUserText.label: 'Job at Location'

@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'EHSJobAtLocationUUID'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IEHSJOBATLOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Transactional Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec   

                         sizeCategory:  #M,         // < 1.000.000

                         dataClass: #TRANSACTIONAL } 
                         
@ObjectModel.compositionRoot: true

define view I_EHSJobAtLocation 
  as select from ehhssd_locjob {
  
  key ehsjobatlocationuuid as EHSJobAtLocationUUID, // BOPF DB_KEY

  
  cast( ehslocationuuid as ehfnd_location_uuid_ref preserving type )  as EHSLocationUUID,
  cast( ehsjobuuid as ehhss_job_uuid_ref preserving type )            as EHSJobUUID
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSD_LOCJOB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/