C_EHSOptrSubjectVH

DDL: C_EHSOPTRSUBJECTVH SQL: CEHSOPERSUBJF4 Type: view CONSUMPTION Package: EHFND_MASTER_COMN
1 Fields 2 Data Sources 1 OData Services

Operator Subject value help

C_EHSOptrSubjectVH is a Consumption CDS View that provides data about "Operator Subject value help" in SAP S/4HANA. It reads from 2 data sources (I_EHSActiveScenDataColl, I_EHSSubject) and exposes 1 field with key field EHSSubjectUUID. It is exposed through 1 OData service (ASQL_F3991). Part of development package EHFND_MASTER_COMN.

Data Sources (2)

SourceAliasJoin Type
I_EHSActiveScenDataColl EHSActiveScenDataColl inner
I_EHSSubject EHSSubject inner

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CEHSOPERSUBJF4 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Operator Subject value help view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Subject view
UI.headerInfo.typeNamePlural Subject view
UI.headerInfo.title.value Subject view
ObjectModel.representativeKey EHSSubjectUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3991 ASQL_F3991 C2 NOT_RELEASED

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY EHSSubjectUUID I_EHSSubject EHSSubjectUUID Subject Ref Key

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_EHSOptrSubjectVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CEHSOPERSUBJF4

CREATE VIEW C_EHSOptrSubjectVH AS
SELECT
  EHSSubject.EHSSubjectUUID AS EHSSubjectUUID
INNER JOIN I_EHSActiveScenDataColl AS EHSActiveScenDataColl ON /* join condition not captured in parsed metadata */
INNER JOIN I_EHSSubject AS EHSSubject ON /* join condition not captured in parsed metadata */
;

Learn More