Sadl_Rs_Ana_Job_Diversity

DDL: SADL_RS_JOB_DIVERSITY SQL: SADLRSJOBDIVRSTY Type: view
4 Fields 1 Data Sources

Job diversity in a department

Sadl_Rs_Ana_Job_Diversity is a CDS View that provides data about "Job diversity in a department" in SAP S/4HANA. It reads from 1 data source (Sadl_Rs_I_Employee) and exposes 4 fields with key field employee_id.

Data Sources (1)

SourceAliasJoin Type
Sadl_Rs_I_Employee Sadl_Rs_I_Employee from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLRSJOBDIVRSTY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Job diversity in a department view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY employee_id id WorklistID
validfrom validfrom Vers.Valid From
validto validto Vers.Valid To
jobtitle jobtitle

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_Ana_Job_Diversity.
-- 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: SADLRSJOBDIVRSTY

CREATE VIEW Sadl_Rs_Ana_Job_Diversity AS
SELECT
  id AS employee_id,
  validfrom,
  validto,
  jobtitle
FROM Sadl_Rs_I_Employee
;

Learn More