USER_PERS_DATA

Transparent Table Application Table
39 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 39 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 (39)

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
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]
    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