Sadl_Rs_Temporal_Department

DDL: SADL_RS_DEPARTMENT SQL: SADLRSDEPARTM Type: view
10 Fields 1 Data Sources 5 Associations

Temporal Department

Sadl_Rs_Temporal_Department is a CDS View that provides data about "Temporal Department" in SAP S/4HANA. It reads from 1 data source (SADL_RS_I_DEPARTMENT) and exposes 10 fields with key fields identifier, validfrom. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
SADL_RS_I_DEPARTMENT SADL_RS_I_DEPARTMENT from

Associations (5)

CardinalityTargetAliasCondition
[0..*] Sadl_Rs_Temporal_Employee _Responsible _Responsible.id = $projection.manager
[0..*] Sadl_Rs_Temporal_Employee _Employees _Employees.department = $projection.identifier
[0..*] Sadl_Rs_Ana_Full_Employees _FullEmployees _FullEmployees.department = $projection.identifier
[0..*] Sadl_Rs_Temporal_Budget _Budget _Budget.department = $projection.identifier
[0..*] Sadl_Rs_Ana_Job_Diversity _JobDiversity _JobDiversity.department_id = $projection.identifier

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLRSDEPARTM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Temporal Department view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY identifier id WorklistID
KEY validfrom validfrom Vers.Valid From
lastvalidon validto Vers.Valid To
name name Zone name
manager manager Identifier
_Responsible _Responsible
_Employees _Employees
_FullEmployees _FullEmployees
_Budget _Budget
_JobDiversity _JobDiversity

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_Department.
-- 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: SADLRSDEPARTM

CREATE VIEW Sadl_Rs_Temporal_Department AS
SELECT
  id AS identifier,
  validfrom,
  validto AS lastvalidon,
  name,
  manager
FROM SADL_RS_I_DEPARTMENT
LEFT OUTER JOIN Sadl_Rs_Temporal_Employee AS _Responsible ON _Responsible.id = manager  -- association [0..*]
LEFT OUTER JOIN Sadl_Rs_Temporal_Employee AS _Employees ON _Employees.department = identifier  -- association [0..*]
LEFT OUTER JOIN Sadl_Rs_Ana_Full_Employees AS _FullEmployees ON _FullEmployees.department = identifier  -- association [0..*]
LEFT OUTER JOIN Sadl_Rs_Temporal_Budget AS _Budget ON _Budget.department = identifier  -- association [0..*]
LEFT OUTER JOIN Sadl_Rs_Ana_Job_Diversity AS _JobDiversity ON _JobDiversity.department_id = identifier  -- association [0..*]
;

Learn More