/SAM4U/BTL_CCNSS

Transparent Table Application Table
12 Fields 3 CDS Views

Consolidation. Systems

/SAM4U/BTL_CCNSS is an SAP database table in S/4HANA. Consolidation. Systems. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/SAM4U/BTL_L_CONSOLIDATION_SYS view from Consolidation System
/SAM4U/BTL_LIST_PROFILE_ROLE view from List Of Profile/Role
/SAM4U/BTL_STAR_SIMULATION_LOG view left_outer Star Simulation Log

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY consolidationguid /sam4u/btl_guid Object GUID
KEY systemid /sam4u/btl_system System ID
datasetguid /sam4u/btl_guid Object GUID
createdat timestamp Time Stamp
createdby uname User Name
changedat timestamp Time Stamp
changedby uname User Name
is_archived /sam4u/btl_is_archived Archived
is_deleted /sam4u/btl_is_deleted Deleted
is_favorite /sam4u/btl_is_favorite Favorite
ruleset /sam4u/btl_ruleset

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.

-- Consolidation. Systems
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAM4U/BTL_CCNSS (
    MANDT,              -- Client [mandt]
    CONSOLIDATIONGUID,  -- Object GUID [/sam4u/btl_guid]
    SYSTEMID,           -- System ID [/sam4u/btl_system]
    DATASETGUID,        -- Object GUID [/sam4u/btl_guid]
    CREATEDAT,          -- Time Stamp [timestamp]
    CREATEDBY,          -- User Name [uname]
    CHANGEDAT,          -- Time Stamp [timestamp]
    CHANGEDBY,          -- User Name [uname]
    IS_ARCHIVED,        -- Archived [/sam4u/btl_is_archived]
    IS_DELETED,         -- Deleted [/sam4u/btl_is_deleted]
    IS_FAVORITE,        -- Favorite [/sam4u/btl_is_favorite]
    RULESET,            -- /sam4u/btl_ruleset
    PRIMARY KEY (MANDT, CONSOLIDATIONGUID, SYSTEMID)
);

Learn More