SGBT_NTE_DEMO

Transparent Table Application Table
10 Fields 2 CDS Views

Notes: Test Application for Notes in Application Object

SGBT_NTE_DEMO is an SAP database table in S/4HANA. Notes: Test Application for Notes in Application Object. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Sgbt_Nte_Cds_Demotp view from TRANSACTIONAL Demo:Notizen am Anwendungsobjekt - Draft
Sgbt_Nte_Cds_Demo view from CONSUMPTION CDS View für Demo-Anwendung für Notizen am Anwendungsobjekt

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objectnodetype SBO_NODE_TYPE SAP Obj Node Type
KEY objectid NTE_OBJECTID Object ID
descr NTE_TITLE Title
creator NTE_CREATOR Created By
created NTE_CREATED Created At
changer NTE_CHANGER Last Changed By
changed NTE_CHANGED Last Changed at
supp_ntypes NTE_SUPPNTYPES Note Types
change_objectid NTE_CHNG_OBJECTID Change Object ID

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: Test Application 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_DEMO (
    MANDT,            -- Client [MANDT]
    OBJECTNODETYPE,   -- SAP Obj Node Type [SBO_NODE_TYPE]
    OBJECTID,         -- Object ID [NTE_OBJECTID]
    DESCR,            -- Title [NTE_TITLE]
    CREATOR,          -- Created By [NTE_CREATOR]
    CREATED,          -- Created At [NTE_CREATED]
    CHANGER,          -- Last Changed By [NTE_CHANGER]
    CHANGED,          -- Last Changed at [NTE_CHANGED]
    SUPP_NTYPES,      -- Note Types [NTE_SUPPNTYPES]
    CHANGE_OBJECTID,  -- Change Object ID [NTE_CHNG_OBJECTID]
    PRIMARY KEY (MANDT, OBJECTNODETYPE, OBJECTID)
);

Learn More