I_IncidentCombAuthFields

DDL: I_INCIDENTCOMBAUTHFIELDS SQL: INCCOMBAUTHFLDS Type: view BASIC

Incident Authorization Fields

I_IncidentCombAuthFields is a Basic CDS View that provides data about "Incident Authorization Fields" in SAP S/4HANA. It reads from 2 data sources (I_IncidentAuthorizationFields, I_IncidentInvstgnAuthznFields) and exposes 30 fields with key field EHSTaskHostObjectInstanceUUID.

2 data source(s) 30 fields

Data Sources (2)

SourceAliasJoin Type
I_IncidentAuthorizationFields I_IncidentAuthorizationFields from
I_IncidentInvstgnAuthznFields I_IncidentInvstgnAuthznFields union_all

Annotations (12)

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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY EHSTaskHostObjectInstanceUUID EHSTaskHostObjectInstanceUUID
IncidentUUID IncidentUUID
InvestigationAccessRestriction
IncidentCategory IncidentCategory
IncidentStatus IncidentStatus
Plant Plant
EHSLocationUUID EHSLocationUUID
Country Country
Region Region
IncidentAccessRestriction IncidentHasAccessRestriction
_CurrentEHSParentLocationID _CurrentEHSParentLocationID
_Country _Country
_IncidentCategory _IncidentCategory
_IncidentStatus _IncidentStatus
_Plant _Plant
IncidentUUID IncidentUUID
InvestigationAccessRestriction InvestigationHasAccRestriction
IncidentCategory IncidentCategory
IncidentStatus IncidentStatus
Plant Plant
EHSLocationUUID EHSLocationUUID
Country Country
Region Region
IncidentAccessRestriction
_CurrentEHSParentLocationID _CurrentEHSParentLocationID
_Country _Country
_IncidentCategory _IncidentCategory
_IncidentStatus _IncidentStatus
_Plant _Plant
_Region _Region 
@AbapCatalog.sqlViewName: 'INCCOMBAUTHFLDS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Incident Authorization Fields'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.modelingPattern: #NONE
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
define view I_IncidentCombAuthFields
  as select from  I_IncidentAuthorizationFields 
 {
 //I_IncidentAuthorizationFields 

key EHSTaskHostObjectInstanceUUID,
    IncidentUUID, 
 //EHSTaskHostObjectInstance, // removed due to performance optimization 

 '' as InvestigationAccessRestriction, 
 IncidentCategory, 
 IncidentStatus, 
 Plant, 
 EHSLocationUUID, 
 Country, 
 Region, 
 IncidentHasAccessRestriction as IncidentAccessRestriction,
 _CurrentEHSParentLocationID,
 _Country,
 _IncidentCategory,
 _IncidentStatus,
 _Plant,
 _Region

 } union all select from I_IncidentInvstgnAuthznFields {

key EHSTaskHostObjectInstanceUUID,
IncidentUUID, 
//EHSTaskHostObjectInstance, // removed due to performance optimization 

InvestigationHasAccRestriction as InvestigationAccessRestriction, 
IncidentCategory, 
IncidentStatus, 
Plant, 
EHSLocationUUID, 
Country, 
Region, 
'' as IncidentAccessRestriction,
 _CurrentEHSParentLocationID,
 _Country,
 _IncidentCategory,
 _IncidentStatus,
 _Plant,
 _Region

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INCIDENTAUTHORIZATIONFIELDS",
"I_INCIDENTINVSTGNAUTHZNFIELDS"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_CURRENTEHSPARENTLOCATIONID",
"I_INCIDENTCATEGORY",
"I_INCIDENTSTATUS",
"I_PLANT",
"I_REGION"
],
"BASE":
[
"I_INCIDENTAUTHORIZATIONFIELDS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More