SGBT_NTE_TYPE

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

Notes: Definition of Note Types

SGBT_NTE_TYPE is an SAP database table in S/4HANA. Notes: Definition of Note Types. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_APNANoteType view_entity from BASIC Note Type
Sgbt_Nte_Cds_Ntype view from BASIC CDS View für Notiztypen für Notizen am Anwendungsobjekt

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY name NTE_NTYNAME Name
langdep NTE_LANGDEP Language-Dependent
maxlength NTE_MAXLENGTH Maximum Length
multiple NTE_MULTIPLE Multiple Notes
no_subject NTE_NOSUBJECT No subject
changer NTE_CHANGER Last Changed By
changed NTE_CHANGED Last Changed at
profile NTE_PROFILE Profile
dpclass NTE_DPCLASS Data Provider Class

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: Definition of Note Types
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGBT_NTE_TYPE (
    MANDT,       -- Client [MANDT]
    NAME,        -- Name [NTE_NTYNAME]
    LANGDEP,     -- Language-Dependent [NTE_LANGDEP]
    MAXLENGTH,   -- Maximum Length [NTE_MAXLENGTH]
    MULTIPLE,    -- Multiple Notes [NTE_MULTIPLE]
    NO_SUBJECT,  -- No subject [NTE_NOSUBJECT]
    CHANGER,     -- Last Changed By [NTE_CHANGER]
    CHANGED,     -- Last Changed at [NTE_CHANGED]
    PROFILE,     -- Profile [NTE_PROFILE]
    DPCLASS,     -- Data Provider Class [NTE_DPCLASS]
    PRIMARY KEY (MANDT, NAME)
);

Learn More