S_Ccl_List_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_List_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_LIST_C

CREATE VIEW S_Ccl_List_C AS
SELECT
  i_sccl_list_tp.CodeListID AS ActiveCodeListID,
  i_sccl_list_tp.CodeListIDForEdit AS CodeListID,
  i_sccl_list_tp.Description AS Description,
  i_sccl_list_tp.Transported AS Transported,
  i_sccl_list_tp.PublishState AS PublishState,
  i_sccl_list_tp.CodeLength AS CodeLength,
  i_sccl_list_tp.OriginalLanguage AS OriginalLanguage,
  i_sccl_list_tp.OriginalRelease AS OriginalRelease,
  i_sccl_list_tp.CreatedBy AS CreatedBy,
  i_sccl_list_tp.CreatedAt AS CreatedAt,
  i_sccl_list_tp.LastChangedBy AS LastChangedBy,
  i_sccl_list_tp.LastChangedAt AS LastChangedAt,
  i_sccl_list_tp.NumFinishedStep AS NumFinishedStep,
  i_sccl_list_tp.NumTotalSteps AS NumTotalSteps
FROM i_sccl_list_tp
LEFT OUTER JOIN S_Ccl_Code_C AS _Code ON ActiveCodeListID = _Code.ActiveCodeListID  -- association [0..*]
LEFT OUTER JOIN S_Ccl_Code_T_C AS _Text ON ActiveCodeListID = _Text.ActiveCodeListID  -- association [0..*]
LEFT OUTER JOIN I_LanguageText AS _OriginalLanguageText ON _OriginalLanguageText.LanguageCode = OriginalLanguage AND _OriginalLanguageText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN S_Ccl_User AS _LastChangedByText ON _LastChangedByText.Name = LastChangedBy  -- association [0..1]
LEFT OUTER JOIN S_Ccl_User AS _CreatedByText ON _CreatedByText.Name = CreatedBy  -- association [0..1]
LEFT OUTER JOIN S_Ccl_Domain_Value_Description AS _PublishStateText ON _PublishStateText.domainname = 'SCCL_PUBLISH_STATE' AND _PublishStateText.code = PublishState AND _PublishStateText.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN S_Ccl_Vh_Trans_Lang_Existing AS _ExistingTranslLangValueHelp ON _ExistingTranslLangValueHelp.ActiveCodeListID = ActiveCodeListID  -- association [0..*]
LEFT OUTER JOIN S_Ccl_Vh_Trans_Lang_New AS _NewTranslLangValueHelp ON /* condition not available in parsed metadata */  -- association [0..*]
;