SGBT_NTE_CONT_D

Transparent Table Application Table
23 Fields 1 CDS Views

I_SGBT_NTE_CDS_APITP I_SGBT_NTE_CDS_APITP

SGBT_NTE_CONT_D is an SAP database table in S/4HANA. I_SGBT_NTE_CDS_APITP I_SGBT_NTE_CDS_APITP. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_APNANoteContentDraft view_entity from BASIC Notes Management - Draft

Fields (23)

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
dp_item_key NTE_DP_KEY DP Note ID
readonly NTE_READONLY Read-only
activeuuid /BOBF/UUID Key
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_SGBT_NTE_CDS_APITP I_SGBT_NTE_CDS_APITP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGBT_NTE_CONT_D (
    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]
    DP_ITEM_KEY,                    -- DP Note ID [NTE_DP_KEY]
    READONLY,                       -- Read-only [NTE_READONLY]
    ACTIVEUUID,                     -- Key [/BOBF/UUID]
    HASACTIVEENTITY,                -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, NOTEID)
);

Learn More