DFS_FE_STRUCAUTH

Transparent Table Application Table
11 Fields 1 CDS Views

Force element Structural Authorizations

DFS_FE_STRUCAUTH is an SAP database table in S/4HANA. Force element Structural Authorizations. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FrcElmntOrgUserStrucAuthzn view from BASIC Basic view to read Structural Authorized objects

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY profl PROFL Auth.profile
KEY plvar PLVAR Plan version
KEY otype OTYPE Object type
KEY robjid HROBJID Object ID
KEY rotype OTYPE Object type
KEY lfdnr LFDNUM Sequence number
KEY objid HROBJID Object ID
KEY usnam USNAM User Name
wegid WEGID Evaluation Path
maint MAINTAUTH Maintenance

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.

-- Force element Structural Authorizations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFS_FE_STRUCAUTH (
    MANDT,   -- Client [MANDT]
    PROFL,   -- Auth.profile [PROFL]
    PLVAR,   -- Plan version [PLVAR]
    OTYPE,   -- Object type [OTYPE]
    ROBJID,  -- Object ID [HROBJID]
    ROTYPE,  -- Object type [OTYPE]
    LFDNR,   -- Sequence number [LFDNUM]
    OBJID,   -- Object ID [HROBJID]
    USNAM,   -- User Name [USNAM]
    WEGID,   -- Evaluation Path [WEGID]
    MAINT,   -- Maintenance [MAINTAUTH]
    PRIMARY KEY (MANDT, PROFL, PLVAR, OTYPE, ROBJID, ROTYPE, LFDNR, OBJID, USNAM)
);

Learn More