SGBT_NTE_TYASSGN

Transparent Table Control Table (SAP+Cust)
6 Fields 2 CDS Views

Notes: Assignment of Note Type to Object Node Type

SGBT_NTE_TYASSGN is an SAP database table in S/4HANA. Notes: Assignment of Note Type to Object Node Type. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_DisputeCaseNoteTypes view from BASIC
R_APNANodeTypeNoteType view_entity from BASIC Node Type to Note Type Asignment

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objectnodetype SBO_NODE_TYPE SAP Obj Node Type
KEY notetype NTE_NTYNAME Name
exitclass NTE_EXITCLASS Exit Class
changer NTE_CHANGER Last Changed By
changed NTE_CHANGED Last Changed at

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.

-- Notes: Assignment of Note Type to Object Node Type
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGBT_NTE_TYASSGN (
    MANDT,           -- Client [MANDT]
    OBJECTNODETYPE,  -- SAP Obj Node Type [SBO_NODE_TYPE]
    NOTETYPE,        -- Name [NTE_NTYNAME]
    EXITCLASS,       -- Exit Class [NTE_EXITCLASS]
    CHANGER,         -- Last Changed By [NTE_CHANGER]
    CHANGED,         -- Last Changed at [NTE_CHANGED]
    PRIMARY KEY (MANDT, OBJECTNODETYPE, NOTETYPE)
);

Learn More