SCCL_CODE

Transparent Table System Table (transport)
6 Fields 1 CDS Views

Custom Code List Code Value

SCCL_CODE is an SAP database table in S/4HANA. Custom Code List Code Value. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
S_Ccl_Code_A view from Code List Code Value Core View

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY codelistid sccl_codelist_id Code List ID
KEY versionnumber sccl_version_number Version Number
KEY code sccl_code_value Code Value
isdisabled boole_d TRUE
description sccl_code_description Description
transported boole_d TRUE

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 List Code Value
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCCL_CODE (
    CODELISTID,     -- Code List ID [sccl_codelist_id]
    VERSIONNUMBER,  -- Version Number [sccl_version_number]
    CODE,           -- Code Value [sccl_code_value]
    ISDISABLED,     -- TRUE [boole_d]
    DESCRIPTION,    -- Description [sccl_code_description]
    TRANSPORTED,    -- TRUE [boole_d]
    PRIMARY KEY (CODELISTID, VERSIONNUMBER, CODE)
);

Learn More