SGBT_NTE_CONT

Transparent Table Application Table
14 Fields 7 CDS Views

Notes: Content Table for Notes in Application Object

SGBT_NTE_CONT is an SAP database table in S/4HANA. Notes: Content Table for Notes in Application Object. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_InsurClmIncidentDetails view inner BASIC Schadenortbeschreibung
I_InsurClmLossDesc view inner BASIC Schadenbeschreibung
I_InsurClmLossLocDesc view inner BASIC Schadenortbeschreibung
I_NOTEBASIC view from BASIC Notiz zum zugeordneten Objekt
R_APNANoteContent view_entity from BASIC Notes Management Active Notes Entity
R_NoteBasic view_entity from BASIC Basis-View für die Notizen
Sgbt_Nte_Cds_Cont view from BASIC CDS View für Notizen am Anwendungsobjekt

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY noteid NTE_ID Note ID
objectnodetype SBO_NODE_TYPE SAP Obj Node Type
objectid NTE_OBJECTID Object ID
notetype NTE_NTYNAME Name
langu NTE_LANGU Lang.
title NTE_TITLE Title
mimetype NTE_MIMETYPE MIME Type
length NTE_LENGTH Length
creator NTE_CREATOR Created By
created NTE_CREATED Created At
changer NTE_CHANGER Last Changed By
changed NTE_CHANGED Last Changed at
content NTE_CONT Content of note

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: Content Table for Notes in Application Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGBT_NTE_CONT (
    MANDT,           -- Client [MANDT]
    NOTEID,          -- Note ID [NTE_ID]
    OBJECTNODETYPE,  -- SAP Obj Node Type [SBO_NODE_TYPE]
    OBJECTID,        -- Object ID [NTE_OBJECTID]
    NOTETYPE,        -- Name [NTE_NTYNAME]
    LANGU,           -- Lang. [NTE_LANGU]
    TITLE,           -- Title [NTE_TITLE]
    MIMETYPE,        -- MIME Type [NTE_MIMETYPE]
    LENGTH,          -- Length [NTE_LENGTH]
    CREATOR,         -- Created By [NTE_CREATOR]
    CREATED,         -- Created At [NTE_CREATED]
    CHANGER,         -- Last Changed By [NTE_CHANGER]
    CHANGED,         -- Last Changed at [NTE_CHANGED]
    CONTENT,         -- Content of note [NTE_CONT]
    PRIMARY KEY (MANDT, NOTEID)
);

Learn More