C_AdhocEHSCtrlForIdentifyRisks
Adhoc EHS Control For Identify Risks
C_AdhocEHSCtrlForIdentifyRisks is a Consumption CDS View that provides data about "Adhoc EHS Control For Identify Risks" in SAP S/4HANA. It reads from 1 data source (I_EHSRiskControl) and exposes 14 fields with key field EHSControlInstanceUUID. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_EHSRiskControl | I_EHSRiskControl | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | C_EHSRisksForIdentifyRisks | _EHSRisk | $projection.EHSRiskUUID = _EHSRisk.EHSRiskUUID |
| [0..*] | I_EHSCtrlTypeText | _EHSCtrlTypeText | $projection.EHSControlAdhocType = _EHSCtrlTypeText.EHSControlType |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CAHCTRLFIR | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #CONSUMPTION | view | |
| UI.headerInfo.typeName | Adhoc Control | view | |
| UI.headerInfo.typeNamePlural | Adhoc Controls | view | |
| UI.headerInfo.title.value | EHSControlAdhocTitle | view | |
| Consumption.semanticObject | EHSControl | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| EndUserText.label | Adhoc EHS Control For Identify Risks | view |
Fields (14)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | EHSControlInstanceUUID | EHSControlInstanceUUID | ||
| EHSRiskUUID | I_EHSRiskControl | EHSRiskUUID | ||
| _EHSRisk | _EHSRisk | |||
| _EHSRiskRoot | _EHSRiskRoot | |||
| EHSRiskRevisionUUID | I_EHSRiskControl | EHSRiskRevisionUUID | ||
| _EHSRiskRevision | _EHSRiskRevision | |||
| EHSControlAdhocTitle | I_EHSRiskControl | EHSControlAdhocTitle | ||
| EHSControlAdhocType | I_EHSRiskControl | EHSControlAdhocType | ||
| _EHSControlAdhocType | I_EHSRiskControl | _EHSControlAdhocType | ||
| _EHSCtrlTypeText | _EHSCtrlTypeText | |||
| EHSControlAdhocSubtype | I_EHSRiskControl | EHSControlAdhocSubtype | ||
| _EHSControlAdhocSubtype | I_EHSRiskControl | _EHSControlAdhocSubtype | ||
| EHSControlRemarkUUID | ||||
| _EHSControlRemarkText | I_EHSRiskControl | _EHSControlRemarkText |
@AbapCatalog.sqlViewName: 'CAHCTRLFIR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_EHSControlRemarkText']
@VDM.viewType: #CONSUMPTION
@ObjectModel.semanticKey: ['EHSControlInstanceUUID'] // this will make the title column bold in smart templates
@UI: {
headerInfo: {
typeName: 'Adhoc Control',
typeNamePlural: 'Adhoc Controls',
title: {
value: 'EHSControlAdhocTitle'
}
}
}
@Consumption.semanticObject: 'EHSControl'
//@ObjectModel.representativeKey: 'EHSRiskAssessmentUUID'
// Client handling by session
@ClientHandling.algorithm: #SESSION_VARIABLE
// used for BOBF Master Data Object
@ObjectModel.usageType:{ serviceQuality: #D, // < 100 msec
sizeCategory: #L, // < 10.000.000
dataClass: #MIXED }
@EndUserText.label: 'Adhoc EHS Control For Identify Risks'
define view C_AdhocEHSCtrlForIdentifyRisks as select from I_EHSRiskControl
association [1..1] to C_EHSRisksForIdentifyRisks as _EHSRisk on $projection.EHSRiskUUID = _EHSRisk.EHSRiskUUID
association [0..*] to I_EHSCtrlTypeText as _EHSCtrlTypeText on $projection.EHSControlAdhocType = _EHSCtrlTypeText.EHSControlType
{
key EHSControlInstanceUUID,
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_EHSRiskStdVH', element: 'EHSRiskUUID' }}]
I_EHSRiskControl.EHSRiskUUID,
_EHSRisk,
_EHSRiskRoot,
I_EHSRiskControl.EHSRiskRevisionUUID,
_EHSRiskRevision,
I_EHSRiskControl.EHSControlAdhocTitle,
@ObjectModel.text.association: '_EHSCtrlTypeText'
I_EHSRiskControl.EHSControlAdhocType,
I_EHSRiskControl._EHSControlAdhocType,
_EHSCtrlTypeText,
I_EHSRiskControl.EHSControlAdhocSubtype,
I_EHSRiskControl._EHSControlAdhocSubtype,
@ UI: {
textArrangement: #TEXT_ONLY,
multiLineText: true
}
I_EHSRiskControl.EHSControlRemarkUUID,
I_EHSRiskControl._EHSControlRemarkText
} where I_EHSRiskControl.EHSControlIsAdhoc = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSRISKCONTROL"
],
"ASSOCIATED":
[
"C_EHSRISKSFORIDENTIFYRISKS",
"I_EHSCONTROLSUBTYPE",
"I_EHSCONTROLTYPE",
"I_EHSCTRLTYPETEXT",
"I_EHSRISKREVISION",
"I_EHSRISKROOT",
"I_EHSTEXTCOLLECTIONTEXT"
],
"BASE":
[
"I_EHSRISKCONTROL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA