SUIM_2X_TEXTS

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 SUIM_2X_TEXTS.
-- 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: SUIM2X_TEXTS

CREATE VIEW SUIM_2X_TEXTS AS
SELECT
  appl_type.ident AS ident
FROM SUIM_2X_APPL_TYPE AS appl_type
LEFT OUTER JOIN tstc AS tcd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN enlfdir AS rf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usobhash AS uhash ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_TEXTS_SICF AS texts_sicf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_TEXTS_IWSV AS texts_iwsv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SUIM_2X_TEXTS_EEEC AS texts_eeec ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tstct AS tran ON tran.tcode = tcd.tcode AND tran.sprsl = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tstct AS tran_en ON tran_en.tcode = tcd.tcode AND tran_en.sprsl = 'E'  -- association [0..1]
LEFT OUTER JOIN tftit AS func ON func.funcname = rf.funcname AND func.spras = $session.system_language  -- association [0..1]
LEFT OUTER JOIN tftit AS func_en ON func_en.funcname = rf.funcname AND func_en.spras = 'E'  -- association [0..1]
LEFT OUTER JOIN abap_daemon_text AS dmon ON dmon.daemon_id = uhash.obj_name AND dmon.version = 'A' AND dmon.lang = $session.system_language  -- association [0..1]
LEFT OUTER JOIN abap_daemon_text AS dmon_en ON dmon_en.daemon_id = uhash.obj_name AND dmon_en.version = 'A' AND dmon_en.lang = 'E'  -- association [0..1]
LEFT OUTER JOIN /iwxbe/i_cons_t AS eeec ON eeec.id = texts_eeec.id AND eeec.version = texts_eeec.version AND eeec.state = 'A' AND eeec.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /iwxbe/i_cons_t AS eeec_en ON eeec_en.id = texts_eeec.id AND eeec_en.version = texts_eeec.version AND eeec_en.state = 'A' AND eeec_en.language = 'E'  -- association [0..1]
LEFT OUTER JOIN /iwbep/i_v4_msgt AS g4ba ON g4ba.group_id = uhash.obj_name AND g4ba.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /iwbep/i_v4_msgt AS g4ba_en ON g4ba_en.group_id = uhash.obj_name AND g4ba_en.language = 'E'  -- association [0..1]
LEFT OUTER JOIN gsm_md_prv_wt AS gsmp ON gsmp.provider_id = uhash.obj_name AND gsmp.version = 'A' AND gsmp.lang = $session.system_language  -- association [0..1]
LEFT OUTER JOIN gsm_md_prv_wt AS gsmp_en ON gsmp_en.provider_id = uhash.obj_name AND gsmp_en.version = 'A' AND gsmp_en.lang = 'E'  -- association [0..1]
LEFT OUTER JOIN uconhttpservtext AS http ON http.id = uhash.obj_name AND http.version = 'A' AND http.lang = $session.system_language  -- association [0..1]
LEFT OUTER JOIN uconhttpservtext AS http_en ON http_en.id = uhash.obj_name AND http_en.version = 'A' AND http_en.lang = 'E'  -- association [0..1]
LEFT OUTER JOIN edimsgt AS idoc ON idoc.mestyp = uhash.obj_name AND idoc.langua = $session.system_language  -- association [0..1]
LEFT OUTER JOIN edimsgt AS idoc_en ON idoc_en.mestyp = uhash.obj_name AND idoc_en.langua = 'E'  -- association [0..1]
LEFT OUTER JOIN ina1_header_t AS ina1 ON ina1.service_id = uhash.obj_name AND ina1.version = 'A' AND ina1.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ina1_header_t AS ina1_en ON ina1_en.service_id = uhash.obj_name AND ina1_en.version = 'A' AND ina1_en.language = 'E'  -- association [0..1]
LEFT OUTER JOIN /iwfnd/i_med_srt AS iwsg ON iwsg.srv_identifier = uhash.obj_name AND iwsg.is_active = 'A' AND iwsg.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /iwfnd/i_med_srt AS iwsg_en ON iwsg_en.srv_identifier = uhash.obj_name AND iwsg_en.is_active = 'A' AND iwsg_en.language = 'E'  -- association [0..1]
LEFT OUTER JOIN /iwbep/i_mgw_srt AS iwsv ON iwsv.technical_name = texts_iwsv.tech_name AND iwsv.version = texts_iwsv.version AND iwsv.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN /iwbep/i_mgw_srt AS iwsv_en ON iwsv_en.technical_name = texts_iwsv.tech_name AND iwsv_en.version = texts_iwsv.version AND iwsv_en.language = 'E'  -- association [0..1]
LEFT OUTER JOIN hrs1000 AS pdws ON pdws.otype = 'WS' AND pdws.objid = uhash.obj_name AND pdws.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN hrs1000 AS pdws_en ON pdws_en.otype = 'WS' AND pdws_en.objid = uhash.obj_name AND pdws_en.langu = 'E'  -- association [0..1]
LEFT OUTER JOIN sadt_srvc_grp_t AS sadt ON sadt.group_name = uhash.obj_name AND sadt.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN sadt_srvc_grp_t AS sadt_en ON sadt_en.group_name = uhash.obj_name AND sadt_en.langu = 'E'  -- association [0..1]
LEFT OUTER JOIN apj_w_jce_ro_t AS sajc ON sajc.job_catalog_entry_name = uhash.obj_name AND sajc.job_catalog_entry_version = '0' AND sajc.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN apj_w_jce_ro_t AS sajc_en ON sajc_en.job_catalog_entry_name = uhash.obj_name AND sajc_en.job_catalog_entry_version = '0' AND sajc_en.langu = 'E'  -- association [0..1]
LEFT OUTER JOIN amc_appl_text AS samc ON samc.application_id = uhash.obj_name AND samc.version = 'A' AND samc.lang = $session.system_language  -- association [0..1]
LEFT OUTER JOIN amc_appl_text AS samc_en ON samc_en.application_id = uhash.obj_name AND samc_en.version = 'A' AND samc_en.lang = 'E'  -- association [0..1]
LEFT OUTER JOIN apc_appl_text AS sapc ON sapc.application_id = uhash.obj_name AND sapc.version = 'A' AND sapc.lang = $session.system_language  -- association [0..1]
LEFT OUTER JOIN apc_appl_text AS sapc_en ON sapc_en.application_id = uhash.obj_name AND sapc_en.version = 'A' AND sapc_en.lang = 'E'  -- association [0..1]
LEFT OUTER JOIN icfdocu AS sicf ON sicf.icf_name = texts_sicf.icf_name AND sicf.icfparguid = texts_sicf.icfparguid AND sicf.icf_langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN icfdocu AS sicf_en ON sicf_en.icf_name = texts_sicf.icf_name AND sicf_en.icfparguid = texts_sicf.icfparguid AND sicf_en.icf_langu = 'E'  -- association [0..1]
LEFT OUTER JOIN sql1_head_t AS sql1 ON sql1.sql1_name = uhash.obj_name AND sql1.language = $session.system_language AND sql1.state = 'A'  -- association [0..1]
LEFT OUTER JOIN sql1_head_t AS sql1_en ON sql1_en.sql1_name = uhash.obj_name AND sql1_en.language = 'E' AND sql1_en.state = 'A'  -- association [0..1]
LEFT OUTER JOIN o2applt AS wapa ON wapa.applname = uhash.obj_name AND wapa.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN o2applt AS wapa_en ON wapa_en.applname = uhash.obj_name AND wapa_en.langu = 'E'  -- association [0..1]
LEFT OUTER JOIN wdy_config_appt AS wdca ON wdca.config_id = uhash.obj_name AND wdca.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN wdy_config_appt AS wdca_en ON wdca_en.config_id = uhash.obj_name AND wdca_en.langu = 'E'  -- association [0..1]
LEFT OUTER JOIN wdy_applicationt AS wdya ON wdya.application_name = uhash.obj_name AND wdya.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN wdy_applicationt AS wdya_en ON wdya_en.application_name = uhash.obj_name AND wdya_en.langu = 'E'  -- association [0..1]
;