SADL_RS_I_DEPARTMENT

DDL: SADL_RS_I_DEPARTMENT SQL: SADLRSIDEPARTM Type: view Package: SADL_ENTITY_REFERENCE_SCENARIO
6 Fields 1 Data Sources 1 Associations

Department Data

SADL_RS_I_DEPARTMENT is a CDS View that provides data about "Department Data" in SAP S/4HANA. It reads from 1 data source (sadl_rs_departm) and exposes 6 fields with key fields id, validfrom. It has 1 association to related views. Part of development package SADL_ENTITY_REFERENCE_SCENARIO.

Data Sources (1)

SourceAliasJoin Type
sadl_rs_departm sadl_rs_departm from

Associations (1)

CardinalityTargetAliasCondition
[0..*] Sadl_Rs_Non_Temporal_Employee _Responsible _Responsible.id = $projection.manager

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLRSIDEPARTM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Department Data view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
KEY validfrom validfrom Vers.Valid From
validto validto Vers.Valid To
name name Zone name
manager manager Identifier
_Responsible _Responsible

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_I_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: SADLRSIDEPARTM

CREATE VIEW SADL_RS_I_DEPARTMENT AS
SELECT
  id,
  validfrom,
  validto,
  name,
  manager
FROM sadl_rs_departm
LEFT OUTER JOIN Sadl_Rs_Non_Temporal_Employee AS _Responsible ON _Responsible.id = manager  -- association [0..*]
;

Learn More