C_EHSJobHzdAnlysJobStepTP

DDL: C_EHSJOBHZDANLYSJOBSTEPTP Type: view_entity CONSUMPTION Package: EHHSS_CNS_JOB_HAZARD_ANALYSIS
10 Fields 1 Data Sources 2 OData Services

Job Hazard Analysis Job Step

C_EHSJobHzdAnlysJobStepTP is a Consumption CDS View that provides data about "Job Hazard Analysis Job Step" in SAP S/4HANA. It reads from 1 data source (R_EHSRskAssmt2JobStepTP) and exposes 10 fields with key field EHSRiskAssessmentJobStepUUID. It is exposed through 2 OData services (ASQL_F7896, UI_EHSJOBHAZARDANALYSIS_MANAGE). Part of development package EHHSS_CNS_JOB_HAZARD_ANALYSIS.

Data Sources (1)

SourceAliasJoin Type
R_EHSRskAssmt2JobStepTP R_EHSRskAssmt2JobStepTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Job Hazard Analysis Job Step view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey EHSRiskAssessmentJobStepUUID view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7896 ASQL_F7896 C2 NOT_RELEASED
UI_EHSJOBHAZARDANALYSIS_MANAGE UI_EHSJOBHAZARDANALYSIS_MANAGE V4 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskAssessmentJobStepUUID EHSRiskAssessmentJobStepUUID UUID
EHSRiskAssessmentJobInfoUUID EHSRiskAssessmentJobInfoUUID UUID
EHSRiskAssessmentUUID EHSRiskAssessmentUUID UUID
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
EHSRiskAssessmentJobStepSqnc EHSRiskAssessmentJobStepSqnc
EHSJobStepName EHSJobStepName Job Step
_RiskredirectedtoC_EHSJobHzdAnlysRiskTP

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_EHSJobHzdAnlysJobStepTP.
-- 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.

CREATE VIEW C_EHSJobHzdAnlysJobStepTP AS
SELECT
  EHSRiskAssessmentJobStepUUID,
  EHSRiskAssessmentJobInfoUUID,
  EHSRiskAssessmentUUID,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser,
  EHSRiskAssessmentJobStepSqnc,
  EHSJobStepName
FROM R_EHSRskAssmt2JobStepTP
;

Learn More