SGBT_NTE_ATTRDEF

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

Definition of Attributes

SGBT_NTE_ATTRDEF is an SAP database table in S/4HANA. Definition of Attributes. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
sgbt_nte_cds_attrdef view from BASIC Definition von Zusatzattributen

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objectnodetype SBO_NODE_TYPE SAP Obj Node Type
KEY notetype NTE_NTYNAME Name
KEY attr_position NTE_ATTR_POSITION Position
attr_data_element ROLLNAME Data Element
attr_control_type NTE_ATTR_CONTROL_TYPE UI Control Type
attr_default_value NTE_ATTR_DEFAULT_VALUE Default Value
attr_readonly NTE_READONLY Read-only
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.

-- Definition of Attributes
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGBT_NTE_ATTRDEF (
    MANDT,               -- Client [MANDT]
    OBJECTNODETYPE,      -- SAP Obj Node Type [SBO_NODE_TYPE]
    NOTETYPE,            -- Name [NTE_NTYNAME]
    ATTR_POSITION,       -- Position [NTE_ATTR_POSITION]
    ATTR_DATA_ELEMENT,   -- Data Element [ROLLNAME]
    ATTR_CONTROL_TYPE,   -- UI Control Type [NTE_ATTR_CONTROL_TYPE]
    ATTR_DEFAULT_VALUE,  -- Default Value [NTE_ATTR_DEFAULT_VALUE]
    ATTR_READONLY,       -- Read-only [NTE_READONLY]
    CHANGER,             -- Last Changed By [NTE_CHANGER]
    CHANGED,             -- Last Changed at [NTE_CHANGED]
    PRIMARY KEY (MANDT, OBJECTNODETYPE, NOTETYPE, ATTR_POSITION)
);

Learn More