SUIM_2X_APPL_TYPE_OTH

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_APPL_TYPE_OTH.
-- 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_TYP_OTH

CREATE VIEW SUIM_2X_APPL_TYPE_OTH AS
SELECT
  cast( left( doma.domvalue_l, 2 ) as usobtype ) AS type,
  '' AS pgmid,
  '' AS object,
  coalesce( tx.ddtext, tx_en.ddtext) AS ddtext,
  '' AS service_type
FROM dd07l AS doma
LEFT OUTER JOIN dd07t AS tx ON tx.domname = doma.domname AND tx.domvalue_l = doma.domvalue_l AND tx.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN dd07t AS tx_en ON tx_en.domname = doma.domname AND tx_en.domvalue_l = doma.domvalue_l AND tx_en.ddlanguage = 'E'  -- association [0..1]
;