What is I_EHSJobStepForJobAtLocationTP in SAP S/4HANA?

I_EHSJobStepForJobAtLocationTP is a transactional CDS view in SAP S/4HANA. Job Step for Job at Location It contains 6 fields.

Which tables does I_EHSJobStepForJobAtLocationTP read from?

I_EHSJobStepForJobAtLocationTP reads data from: I_EHSJobStepForJobAtLocation.

What VDM layer is I_EHSJobStepForJobAtLocationTP?

I_EHSJobStepForJobAtLocationTP is classified as a Transactional view that supports create, update, and delete operations.

I_EHSJobStepForJobAtLocationTP

DDL: I_EHSJOBSTEPFORJOBATLOCATIONTP SQL: IEHSJOBSTPLOCTP Type: view TRANSACTIONAL

6 Fields 1 Data Sources 1 Associations

Job Step for Job at Location

I_EHSJobStepForJobAtLocationTP is a Transactional CDS View that provides data about "Job Step for Job at Location" in SAP S/4HANA. It reads from 1 data source (I_EHSJobStepForJobAtLocation) and exposes 6 fields with key field EHSJobStepForJobAtLocationUUID. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_EHSJobStepForJobAtLocation	I_EHSJobStepForJobAtLocation	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_EHSJobStepForJobAtLocTextTP	_EHSJobStepForJobAtLocTextTP	`$projection.EHSJobStepForJobAtLocationUUID = _EHSJobStepForJobAtLocTextTP.EHSJobStepForJobAtLocationUUID`

Annotations (16)

Name	Value	Level
EndUserText.label	Job Step for Job at Location	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	IEHSJOBSTPLOCTP	view
AbapCatalog.compiler.compareFilter	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.createEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.writeActivePersistence	EHHSSD_LOCJOBSTP	view
ObjectModel.transactionalProcessingUnitRoot	true	view
ObjectModel.representativeKey	EHSJobStepForJobAtLocationUUID	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (6)

Key	Field	Source Field	Description
KEY	EHSJobStepForJobAtLocationUUID	EHSJobStepForJobAtLocationUUID	NodeID
	EHSJobAtLocationUUID	EHSJobAtLocationUUID	NodeID
	EHSJobStep	EHSJobStep	Step ID
	EHSJobStepSequenceNo	EHSJobStepSequenceNo	Job Step No.
	_EHSJobAtLocationTP	_EHSJobAtLocationTP
	_EHSJobStepForJobAtLocTextTP	_EHSJobStepForJobAtLocTextTP

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 I_EHSJobStepForJobAtLocationTP.
-- 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: IEHSJOBSTPLOCTP

CREATE VIEW I_EHSJobStepForJobAtLocationTP AS
SELECT
  EHSJobStepForJobAtLocationUUID,
  EHSJobAtLocationUUID,
  EHSJobStep,
  EHSJobStepSequenceNo
FROM I_EHSJobStepForJobAtLocation
LEFT OUTER JOIN I_EHSJobStepForJobAtLocTextTP AS _EHSJobStepForJobAtLocTextTP ON EHSJobStepForJobAtLocationUUID = _EHSJobStepForJobAtLocTextTP.EHSJobStepForJobAtLocationUUID  -- association [0..*]
;

Depth:

I_EHSJobStepForJobAtLocationTP view

I_EHSJobStepForJobAtLocation view