SCCL_LIST

Transparent Table System Table (transport)
24 Fields 4 CDS Views

Custom Code Lists

SCCL_LIST is an SAP database table in S/4HANA. Custom Code Lists. It contains 24 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
S_Ccl_Bill_Of_Material view from Custom Code List runtime objects
S_Ccl_List_A view from Code List Core View
SCCL_LANG_VRS_OBJ_ACTIVE_SCCL view_entity from CCL: Language Version for Mass Retrieval
sccl_lang_vrs_obj_edit_sccl view_entity from CCL: Language Version for Single Objects

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY codelistid sccl_codelist_id Code List ID
KEY versionnumber sccl_version_number Version Number
description sccl_codelist_description Description
transported boole_d TRUE
namespace namespace Namespace
originallanguage sccl_language Original Language
originalrelease sccl_release Release
publishstate sccl_publish_state Publish State
codelength sccl_code_length code length
table_name_c sccl_table_name table name
table_name_t sccl_table_name table name
data_element_name_c sccl_data_element_name Custom code list data element name
data_element_name_t sccl_data_element_name Custom code list data element name
cds_view_name_c sccl_cds_view_name cds view name
cds_view_name_t sccl_cds_view_name cds view name
abap_view_name_c sccl_abap_view_name ABAP view name
abap_view_name_t sccl_abap_view_name ABAP view name
domain_name_c sccl_data_element_name Custom code list data element name
domain_name_t sccl_data_element_name Custom code list data element name
ballog_handle balloghndl Handle
job_name btcjob Job Name
job_count btcjobcnt Job No.
last_action sccl_action lifecycle action
data_extraction_type sccl_data_extraction_type Data Extraction Type

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Custom Code Lists
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCCL_LIST (
    CODELISTID,            -- Code List ID [sccl_codelist_id]
    VERSIONNUMBER,         -- Version Number [sccl_version_number]
    DESCRIPTION,           -- Description [sccl_codelist_description]
    TRANSPORTED,           -- TRUE [boole_d]
    NAMESPACE,             -- Namespace [namespace]
    ORIGINALLANGUAGE,      -- Original Language [sccl_language]
    ORIGINALRELEASE,       -- Release [sccl_release]
    PUBLISHSTATE,          -- Publish State [sccl_publish_state]
    CODELENGTH,            -- code length [sccl_code_length]
    TABLE_NAME_C,          -- table name [sccl_table_name]
    TABLE_NAME_T,          -- table name [sccl_table_name]
    DATA_ELEMENT_NAME_C,   -- Custom code list data element name [sccl_data_element_name]
    DATA_ELEMENT_NAME_T,   -- Custom code list data element name [sccl_data_element_name]
    CDS_VIEW_NAME_C,       -- cds view name [sccl_cds_view_name]
    CDS_VIEW_NAME_T,       -- cds view name [sccl_cds_view_name]
    ABAP_VIEW_NAME_C,      -- ABAP view name [sccl_abap_view_name]
    ABAP_VIEW_NAME_T,      -- ABAP view name [sccl_abap_view_name]
    DOMAIN_NAME_C,         -- Custom code list data element name [sccl_data_element_name]
    DOMAIN_NAME_T,         -- Custom code list data element name [sccl_data_element_name]
    BALLOG_HANDLE,         -- Handle [balloghndl]
    JOB_NAME,              -- Job Name [btcjob]
    JOB_COUNT,             -- Job No. [btcjobcnt]
    LAST_ACTION,           -- lifecycle action [sccl_action]
    DATA_EXTRACTION_TYPE,  -- Data Extraction Type [sccl_data_extraction_type]
    PRIMARY KEY (CODELISTID, VERSIONNUMBER)
);

Learn More