SETHEADER

Transparent Table Customizing Table
23 Fields 17 CDS Views

Set Header and Directory

SETHEADER is an SAP database table in S/4HANA. Set Header and Directory. It contains 23 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
ESH_N_COST_CENTER_GRP_ER_GROUP view from Set Header and Directory
FAC_CDS_SET_ACTIVITYTYPENODE view from Universal Hier Activity Type Node
FAC_CDS_SET_CE_GLACC_NODE view from Cost Element Group and GL Account Group
FAC_CDS_SET_COSTCENTERNODE view from Universal Hierarchy Cost Center Node
FAC_CDS_SET_FUNCNLAREANODE view from Universal Hierarchy Functional Area Node
FAC_CDS_SET_ORDERNODE view from Universal Hier Order Node
FAC_CDS_SET_PRFTCENTERNODE view from Universal Hierarchy Cost Center Node
FAC_CDS_SET_STSTCLKEYFIGNODE view from Universal Hier Stat Key Figure Node
FAC_CDS_SET_WBS_NODE view from Universal Hier WBS Type Node
I_DeliveryNetworkHier view from BASIC Delivery Network Hierarchy
I_MeasurementPtHier view from BASIC Measurement Point Hierarchy
I_SetHeader view from BASIC Set Header
I_WellCompletionHier view from BASIC Well Completion Hierarchy
P_CommitmentItemSetNode view from BASIC
P_FundedProgramSetNode view from BASIC
P_FUNDSCENTERSETNODE view from BASIC
P_FUNDSETNODE view from BASIC

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY setclass SETCLASS Set Class
KEY subclass SETSUBCLS Org. Unit
KEY setname SETNAMENEW Set Name
settype STYPE Set Type
xdynamic SETFLGDYN Dynamic Set
authgr AUTHGR Authorization
xuniq SETFLGSUQ Must Be Unique
rvalue SETVALREP Repres. Value
creuser CRNAM Created By
credate CRDAT Created On
cretime CR_TIME Time
upduser UPNAM Changed By
upddate UPDAT Changed on
updtime UP_TIME Time
saprl SYSAPRL SAP Release
tabname TABNAME Table Name
fieldname FIELDNAME Field Name
rollname SETDTEL_D Repr. Data Elem
set_olangu SET_OLANGU Original Lang.
no_rwsheader SET_NO_RWSHEADER No Entries Exist in Table RWSHEADER for This Set
no_rwsline SET_NO_RWSLINE No Entries Exist in Table RWSLINE for This Set
no_setlinet SET_NO_SETLINET No Entries Exist in Table SETLINET for This Set

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.

-- Set Header and Directory
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SETHEADER (
    MANDT,         -- Client [MANDT]
    SETCLASS,      -- Set Class [SETCLASS]
    SUBCLASS,      -- Org. Unit [SETSUBCLS]
    SETNAME,       -- Set Name [SETNAMENEW]
    SETTYPE,       -- Set Type [STYPE]
    XDYNAMIC,      -- Dynamic Set [SETFLGDYN]
    AUTHGR,        -- Authorization [AUTHGR]
    XUNIQ,         -- Must Be Unique [SETFLGSUQ]
    RVALUE,        -- Repres. Value [SETVALREP]
    CREUSER,       -- Created By [CRNAM]
    CREDATE,       -- Created On [CRDAT]
    CRETIME,       -- Time [CR_TIME]
    UPDUSER,       -- Changed By [UPNAM]
    UPDDATE,       -- Changed on [UPDAT]
    UPDTIME,       -- Time [UP_TIME]
    SAPRL,         -- SAP Release [SYSAPRL]
    TABNAME,       -- Table Name [TABNAME]
    FIELDNAME,     -- Field Name [FIELDNAME]
    ROLLNAME,      -- Repr. Data Elem [SETDTEL_D]
    SET_OLANGU,    -- Original Lang. [SET_OLANGU]
    NO_RWSHEADER,  -- No Entries Exist in Table RWSHEADER for This Set [SET_NO_RWSHEADER]
    NO_RWSLINE,    -- No Entries Exist in Table RWSLINE for This Set [SET_NO_RWSLINE]
    NO_SETLINET,   -- No Entries Exist in Table SETLINET for This Set [SET_NO_SETLINET]
    PRIMARY KEY (MANDT, SETCLASS, SUBCLASS, SETNAME)
);

Learn More