Sadl_Rs_Temporal_Employee

DDL: SADL_RS_EMPLOYEE SQL: SADLRSEMPLOYEE Type: view Package: SADL_ENTITY_REFERENCE_SCENARIO
9 Fields 1 Data Sources 3 Associations

Temporal Employee

Sadl_Rs_Temporal_Employee is a CDS View that provides data about "Temporal Employee" in SAP S/4HANA. It reads from 1 data source (Sadl_Rs_I_Employee) and exposes 9 fields with key fields id, validfrom. It has 3 associations to related views. Part of development package SADL_ENTITY_REFERENCE_SCENARIO.

Data Sources (1)

SourceAliasJoin Type
Sadl_Rs_I_Employee Sadl_Rs_I_Employee from

Associations (3)

CardinalityTargetAliasCondition
[1..*] Sadl_Rs_Temporal_Department _Department _Department.identifier = $projection.department
[1..*] sadl_rs_temporal_salary _Salary _Salary.employee = $projection.id
[0..1] Sadl_Rs_Ana_Full_Employees _FullEmployee _FullEmployee.id = $projection.id

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLRSEMPLOYEE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Temporal Employee view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY validfrom validfrom Vers.Valid From
validto validto Vers.Valid To
name name Zone name
jobtitle jobtitle
department department Department
_Department _Department
_Salary _Salary
_FullEmployee _FullEmployee

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 Sadl_Rs_Temporal_Employee.
-- 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: SADLRSEMPLOYEE

CREATE VIEW Sadl_Rs_Temporal_Employee AS
SELECT
  id,
  validfrom,
  validto,
  name,
  jobtitle,
  department
FROM Sadl_Rs_I_Employee
LEFT OUTER JOIN Sadl_Rs_Temporal_Department AS _Department ON _Department.identifier = department  -- association [1..*]
LEFT OUTER JOIN sadl_rs_temporal_salary AS _Salary ON _Salary.employee = id  -- association [1..*]
LEFT OUTER JOIN Sadl_Rs_Ana_Full_Employees AS _FullEmployee ON _FullEmployee.id = id  -- association [0..1]
;

Learn More