S_Ccl_Code_T_C

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 S_Ccl_Code_T_C.
-- 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: S_V_CCL_CODE_T_C

CREATE VIEW S_Ccl_Code_T_C AS
SELECT
  I_SCCL_CODE_T_TP.CodeListID AS ActiveCodeListID,
  I_SCCL_CODE_T_TP.Code AS ActiveCode,
  I_SCCL_CODE_T_TP.Language AS ActiveLanguage,
  I_SCCL_CODE_T_TP.LanguageForEdit AS Language,
  I_SCCL_CODE_T_TP.Description AS Description,
  I_SCCL_CODE_T_TP.Transported AS Transported
FROM I_SCCL_CODE_T_TP
LEFT OUTER JOIN S_Ccl_Code_C AS _Code ON ActiveCodeListID = _Code.ActiveCodeListID AND ActiveCode = _Code.ActiveCode  -- association [1..1]
LEFT OUTER JOIN S_Ccl_List_C AS _List ON ActiveCodeListID = _List.ActiveCodeListID  -- association [1..1]
LEFT OUTER JOIN I_LanguageText AS _LanguageText ON _LanguageText.LanguageCode = Language AND _LanguageText.Language = $session.system_language  -- association [0..1]
;