FPB_PERSPARM

Transparent Table Customizing Table
19 Fields 8 CDS Views

Personalization: User Settings

FPB_PERSPARM is an SAP database table in S/4HANA. Personalization: User Settings. It contains 19 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_GteeMMyGrantMasterBasic view left_outer BASIC Grantee Management My Grant Master Basic
P_FmavcAcoDataUser view inner BASIC
P_FmavcOcoDataUser view inner BASIC
P_GMAVCDataUser view left_outer BASIC
P_GMAVCSetLocCurr view left_outer BASIC
P_GMAVCSetLocCurr view union_all BASIC
P_GTEEMMYEXPIRINGGRANTS view left_outer BASIC
P_RetailStorePrsnlznFramework view from BASIC

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY perskeytp FPB_KEYTP Key Type
KEY perskey FPB_KEY Personaliz. Key
KEY applid FPB_APPID Personaliz. App
KEY fieldname FIELDNAME Field Name
KEY origin FPB_ORIGIN Origin of Data
KEY dateto DATUM Date
KEY fieldindex FPB_FIELDINDEX Index
KEY pers_subcontext FPB_APPSUBCON Subcontext
datefrom DATUM Date
noauth FPB_NOAUTH No Auth. Extraction
username USNAM User Name
timestmp FPB_HZSTMP Time Created
fieldtype FPB_FTYPE Field Type
sel_sign S_SIGN Sign
sel_option SEL_OPTION Option
low FPB_LOW From Value
high FPB_HIGH To Value
pers_variable FPB_VARIABLE Pers. Variable

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.

-- Personalization: User Settings
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FPB_PERSPARM (
    MANDT,            -- Client [MANDT]
    PERSKEYTP,        -- Key Type [FPB_KEYTP]
    PERSKEY,          -- Personaliz. Key [FPB_KEY]
    APPLID,           -- Personaliz. App [FPB_APPID]
    FIELDNAME,        -- Field Name [FIELDNAME]
    ORIGIN,           -- Origin of Data [FPB_ORIGIN]
    DATETO,           -- Date [DATUM]
    FIELDINDEX,       -- Index [FPB_FIELDINDEX]
    PERS_SUBCONTEXT,  -- Subcontext [FPB_APPSUBCON]
    DATEFROM,         -- Date [DATUM]
    NOAUTH,           -- No Auth. Extraction [FPB_NOAUTH]
    USERNAME,         -- User Name [USNAM]
    TIMESTMP,         -- Time Created [FPB_HZSTMP]
    FIELDTYPE,        -- Field Type [FPB_FTYPE]
    SEL_SIGN,         -- Sign [S_SIGN]
    SEL_OPTION,       -- Option [SEL_OPTION]
    LOW,              -- From Value [FPB_LOW]
    HIGH,             -- To Value [FPB_HIGH]
    PERS_VARIABLE,    -- Pers. Variable [FPB_VARIABLE]
    PRIMARY KEY (MANDT, PERSKEYTP, PERSKEY, APPLID, FIELDNAME, ORIGIN, DATETO, FIELDINDEX, PERS_SUBCONTEXT)
);

Learn More