SCCL_D2_CODE_T

Transparent Table Application Table
16 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 16 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 (16)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More