CUAN_TG_CDS_OT_MAP_KEY_AND_SEM

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 CUAN_TG_CDS_OT_MAP_KEY_AND_SEM.
-- 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.

CREATE VIEW CUAN_TG_CDS_OT_MAP_KEY_AND_SEM AS
SELECT
  scr.appl_id AS appl_id,
  scr.ot_id AS ot_id,
  otk.ot_key AS key_name,
  otk.ot_key_len AS ot_key_len,
  otk.ot_key_dec AS ot_key_dec,
  scv.ds_alias AS ds_alias,
  scv.cds_view AS cds_view,
  at.at_sem_type AS at_sem_type
FROM cds_gseg_ot_ds_at AS at
LEFT OUTER JOIN gseg_ot_ds_key AS dsk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN gseg_ot_key AS otk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cuanc_ot_k_tgm_k AS tgkm ON /* join condition not captured in parsed metadata */
INNER JOIN gseg_cds_seg_scen_rt AS scr ON /* join condition not captured in parsed metadata */
INNER JOIN gseg_cds_seg_scen_vw AS scv ON /* join condition not captured in parsed metadata */
;