USER_PERS_DATA

Transparent Table Application Table
40 Fields 2 CDS Views

Advanced user setting details

USER_PERS_DATA is an SAP database table in S/4HANA. Advanced user setting details. It contains 40 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_UserDefaultSettingItem view from EXTENSION User Default Settings Item Extensibilty view
I_ProcmtUsrAdvncdDfltSettings view from BASIC Advanced default settings for user

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY employee MMPUR_D_EMP_ID Employee Id
KEY personalizationid MMPUR_D_PERS_ID Personalization ID
KEY businessobjecttype SWO_OBJTYP Object Type
role BU_PARTNERROLE BP Role
plant WERKS_D Plant
accountassignmentcategory KNTTP Acct Assgmt Cat
materialgroup MATKL Material Group
deliverydate LFDAT Delivery date
currency WAERS Currency
purchasinggroup EKGRP Purch. Group
sourcedetermination MMPUR_D_SOURCE_DET Determ. Source
supplyingplant WERKS_EXT Plant
storagelocation LGORT_D Location
requisitionername AFNAM Requisitioner
costcenter KOSTL Cost Center
purchasingdocumenttype ESART Document Type
purchasingorganization EKORG Purchasing Org.
companycode BUKRS Company Code
lastchangedatetime TIMESTAMPL Time Stamp
changedby SCMG_CHANGE_USER Changed By
wbselementinternalid PS_PSP_PNR WBS Element
wbselement PS_POSID_EDIT WBS Element
projectnetwork NPLNR Network
orderid AUFNR Order
projectnetworkinternalid CO_AUFPL Plan No.f.Oper.
asset ANLN1 Asset
assetsubnumber ANLN2 Sub-number
glaccount SAKNR G/L Account
dummy_user_pers_incl_eew_ps USER_PERS_DATA_INCL_EEW User Defaults Ext
commsyst MMPUR_D_COMM_SYS Comm. System
logicalsystem MMPUR_D_HUB_LOGSYS Logical System
sourcesystem MMPUR_D_SOURCE_SYS Connected System ID
sob_type MMPUR_D_SOB Shop on Behalf
expert_mode MMPUR_D_EXPERT_MODE Expert Mode
extpurchasingdocumenttype MM_PUR_HUB_REQ_DOC_TYPE PR DocTyp of ConnSys
purchaseorderpricetype BPUEB PO price
purreqnheadercurrencysource MMPUR_REQ_D_PR_HDR_CURR_SRC Src of Tot Val Crcy
goodsrecipientname WEMPF Recipient
unloadingpointname ABLAD Unloading Point

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.

-- Advanced user setting details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE USER_PERS_DATA (
    MANDT,                        -- Client [MANDT]
    EMPLOYEE,                     -- Employee Id [MMPUR_D_EMP_ID]
    PERSONALIZATIONID,            -- Personalization ID [MMPUR_D_PERS_ID]
    BUSINESSOBJECTTYPE,           -- Object Type [SWO_OBJTYP]
    ROLE,                         -- BP Role [BU_PARTNERROLE]
    PLANT,                        -- Plant [WERKS_D]
    ACCOUNTASSIGNMENTCATEGORY,    -- Acct Assgmt Cat [KNTTP]
    MATERIALGROUP,                -- Material Group [MATKL]
    DELIVERYDATE,                 -- Delivery date [LFDAT]
    CURRENCY,                     -- Currency [WAERS]
    PURCHASINGGROUP,              -- Purch. Group [EKGRP]
    SOURCEDETERMINATION,          -- Determ. Source [MMPUR_D_SOURCE_DET]
    SUPPLYINGPLANT,               -- Plant [WERKS_EXT]
    STORAGELOCATION,              -- Location [LGORT_D]
    REQUISITIONERNAME,            -- Requisitioner [AFNAM]
    COSTCENTER,                   -- Cost Center [KOSTL]
    PURCHASINGDOCUMENTTYPE,       -- Document Type [ESART]
    PURCHASINGORGANIZATION,       -- Purchasing Org. [EKORG]
    COMPANYCODE,                  -- Company Code [BUKRS]
    LASTCHANGEDATETIME,           -- Time Stamp [TIMESTAMPL]
    CHANGEDBY,                    -- Changed By [SCMG_CHANGE_USER]
    WBSELEMENTINTERNALID,         -- WBS Element [PS_PSP_PNR]
    WBSELEMENT,                   -- WBS Element [PS_POSID_EDIT]
    PROJECTNETWORK,               -- Network [NPLNR]
    ORDERID,                      -- Order [AUFNR]
    PROJECTNETWORKINTERNALID,     -- Plan No.f.Oper. [CO_AUFPL]
    ASSET,                        -- Asset [ANLN1]
    ASSETSUBNUMBER,               -- Sub-number [ANLN2]
    GLACCOUNT,                    -- G/L Account [SAKNR]
    DUMMY_USER_PERS_INCL_EEW_PS,  -- User Defaults Ext [USER_PERS_DATA_INCL_EEW]
    COMMSYST,                     -- Comm. System [MMPUR_D_COMM_SYS]
    LOGICALSYSTEM,                -- Logical System [MMPUR_D_HUB_LOGSYS]
    SOURCESYSTEM,                 -- Connected System ID [MMPUR_D_SOURCE_SYS]
    SOB_TYPE,                     -- Shop on Behalf [MMPUR_D_SOB]
    EXPERT_MODE,                  -- Expert Mode [MMPUR_D_EXPERT_MODE]
    EXTPURCHASINGDOCUMENTTYPE,    -- PR DocTyp of ConnSys [MM_PUR_HUB_REQ_DOC_TYPE]
    PURCHASEORDERPRICETYPE,       -- PO price [BPUEB]
    PURREQNHEADERCURRENCYSOURCE,  -- Src of Tot Val Crcy [MMPUR_REQ_D_PR_HDR_CURR_SRC]
    GOODSRECIPIENTNAME,           -- Recipient [WEMPF]
    UNLOADINGPOINTNAME,           -- Unloading Point [ABLAD]
    PRIMARY KEY (MANDT, EMPLOYEE, PERSONALIZATIONID, BUSINESSOBJECTTYPE)
);

Learn More