AunitElemInfo_01

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 AunitElemInfo_01.
-- 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: SDDICTESTELM01

CREATE VIEW AunitElemInfo_01 AS
SELECT
  snwd_employees.client AS client,
  snwd_employees.node_key AS node_key,
  snwd_employees.parent_key AS parent_key,
  snwd_employees.employee_id AS employee_id,
  snwd_employees.first_name AS first_name,
  snwd_employees.middle_name AS middle_name,
  snwd_employees.last_name AS last_name,
  snwd_employees.initials AS initials,
  snwd_employees.sex AS sex,
  snwd_employees.language AS language,
  snwd_employees.phone_number AS phone_number,
  snwd_employees.login_name AS login_name,
  snwd_employees.val_end_date AS val_end_date,
  snwd_employees.currency AS currency,
  snwd_employees.bank_id AS bank_id,
  snwd_employees.bank_name AS bank_name,
  Address,
  Lang,
  SalaryCurrency
FROM snwd_employees
LEFT OUTER JOIN AunitTestAddress AS Address ON pr_address_guid = Address.node_key  -- association [1]
LEFT OUTER JOIN t002 AS Lang ON language = Lang.spras  -- association [2]
LEFT OUTER JOIN tcurc AS SalaryCurrency ON currency = waers  -- association [0..*]
;