SGBT_NTE_TYASSGN

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

Notes: Zuordnung Notiztyp zum ObjectNodeType

SGBT_NTE_TYASSGN is an SAP database table in S/4HANA. Notes: Zuordnung Notiztyp zum ObjectNodeType. 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: Zuordnung Notiztyp zum ObjectNodeType
-- 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