USER_PERS_DATA - Advanced user setting details
Advanced user setting details information is stored in SAP table USER_PERS_DATA.
It is part of development package APPL_MM_COMP_EMPL_SETTINGS in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "Employee/User Personalisation".
It is part of development package APPL_MM_COMP_EMPL_SETTINGS in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "Employee/User Personalisation".
Fields for table USER_PERS_DATA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| EMPLOYEE | Employee ID | X | MMPUR_D_EMP_ID | CHAR | 120 | |
| PERSONALIZATIONID | Personalization ID | X | MMPUR_D_PERS_ID | RAW | 16 | |
| BUSINESSOBJECTTYPE | Object Type | X | SWO_OBJTYP | CHAR | 20 | |
| ROLE | BP Role | BU_PARTNERROLE | CHAR | 12 | ||
| PLANT | Plant | WERKS_D | CHAR | 8 | ||
| ACCOUNTASSIGNMENTCATEGORY | Account Assignment Category | KNTTP | CHAR | 2 | ||
| MATERIALGROUP | Material Group | MATKL | CHAR | 18 | ||
| DELIVERYDATE | Delivery date | LFDAT | DATS | 16 | ||
| CURRENCY | Currency Key | WAERS | CUKY | 10 | ||
| PURCHASINGGROUP | Purchasing Group | EKGRP | CHAR | 6 | ||
| SOURCEDETERMINATION | Automatic Source Determination | MMPUR_D_SOURCE_DET | CHAR | 2 | ||
| SUPPLYINGPLANT | Plant (Own or External) | WERKS_EXT | CHAR | 8 | ||
| STORAGELOCATION | Storage location | LGORT_D | CHAR | 8 | ||
| REQUISITIONERNAME | Name of requisitioner/requester | AFNAM | CHAR | 24 | ||
| COSTCENTER | Cost Center | KOSTL | CHAR | 20 | ||
| PURCHASINGDOCUMENTTYPE | Purchasing Document Type | ESART | CHAR | 8 | ||
| PURCHASINGORGANIZATION | Purchasing organization | EKORG | CHAR | 8 | ||
| COMPANYCODE | Company Code | BUKRS | CHAR | 8 | ||
| LASTCHANGEDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| CHANGEDBY | Last Changed By | SCMG_CHANGE_USER | CHAR | 24 | ||
| WBSELEMENTINTERNALID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | ||
| WBSELEMENT | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | CHAR | 48 | ||
| PROJECTNETWORK | Network Number for Account Assignment | NPLNR | CHAR | 24 | ||
| ORDERID | Order Number | AUFNR | CHAR | 24 | ||
| PROJECTNETWORKINTERNALID | Routing number of operations in the order | CO_AUFPL | NUMC | 20 | ||
| ASSET | Main Asset Number | ANLN1 | CHAR | 24 | ||
| ASSETSUBNUMBER | Asset Subnumber | ANLN2 | CHAR | 8 | ||
| GLACCOUNT | G/L Account Number | SAKNR | CHAR | 20 | ||
| .INCLUDE | USER_PERS_DATA_INCL_EEW_PS | 0 | ||||
| DUMMY_USER_PERS_INCL_EEW_PS | Extension in user defaults | USER_PERS_DATA_INCL_EEW | CHAR | 2 | ||
| COMMSYST | Communication System ID | MMPUR_D_COMM_SYS | CHAR | 120 | ||
| LOGICALSYSTEM | Logical System | MMPUR_D_HUB_LOGSYS | CHAR | 20 | ||
| SOURCESYSTEM | Connected System ID | MMPUR_D_SOURCE_SYS | CHAR | 20 | ||
| SOB_TYPE | Shop on Behalf Type | MMPUR_D_SOB | CHAR | 4 | ||
| EXPERT_MODE | Expert Mode | MMPUR_D_EXPERT_MODE | CHAR | 2 | ||
| EXTPURCHASINGDOCUMENTTYPE | PR Document Type of Connected System | MM_PUR_HUB_REQ_DOC_TYPE | CHAR | 8 | ||
| PURCHASEORDERPRICETYPE | Use Requisition Price in Purchase Order | BPUEB | CHAR | 2 | ||
| PURREQNHEADERCURRENCYSOURCE | Source of Total Value Currency | MMPUR_REQ_D_PR_HDR_CURR_SRC | CHAR | 2 |