SCCL_D2_CODE_T

Transparent Table Application Table
11 Fields 2 CDS Views

I_SCCL_LIST_TP I_SCCL_CODE_T_TP

SCCL_D2_CODE_T is an SAP database table in S/4HANA. I_SCCL_LIST_TP I_SCCL_CODE_T_TP. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
S_Ccl_Code_T_U view left_outer
S_Ccl_Code_T_U view union_all

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
rootdraftuuid /bobf/uuid Key
codelistid sccl_codelist_id Code List ID
code sccl_code_value Code Value
language sccl_language Original Language
languageforedit sccl_language Original Language
description sccl_code_description Description
transported boole_d TRUE
hasactiveentity sdraft_has_active Has active

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.

-- I_SCCL_LIST_TP I_SCCL_CODE_T_TP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCCL_D2_CODE_T (
    MANDT,            -- Client [mandt]
    DRAFTUUID,        -- Key [/bobf/uuid]
    PARENTDRAFTUUID,  -- Key [/bobf/uuid]
    ROOTDRAFTUUID,    -- Key [/bobf/uuid]
    CODELISTID,       -- Code List ID [sccl_codelist_id]
    CODE,             -- Code Value [sccl_code_value]
    LANGUAGE,         -- Original Language [sccl_language]
    LANGUAGEFOREDIT,  -- Original Language [sccl_language]
    DESCRIPTION,      -- Description [sccl_code_description]
    TRANSPORTED,      -- TRUE [boole_d]
    HASACTIVEENTITY,  -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More