SADL_RS_TX_Dated_Employee

DDL: SADL_RS_TX_DATED_EMPLOYEE SQL: SADLRSTXDATEMPLO Type: view
7 Fields 1 Data Sources 1 Associations

Temporal Transactional Employee

SADL_RS_TX_Dated_Employee is a CDS View that provides data about "Temporal Transactional Employee" in SAP S/4HANA. It reads from 1 data source (Sadl_Rs_I_Employee) and exposes 7 fields with key fields id, validfrom. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
Sadl_Rs_I_Employee Sadl_Rs_I_Employee from

Associations (1)

CardinalityTargetAliasCondition
[1..*] Sadl_Rs_Temporal_Department _Department _Department.identifier = $projection.department

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SADLRSTXDATEMPLO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Temporal Transactional Employee view
Consumption.filter.businessDate.at false view

Fields (7)

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

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_TX_Dated_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: SADLRSTXDATEMPLO

CREATE VIEW SADL_RS_TX_Dated_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..*]
;

Learn More