SAP DPR_TS_API_ROOT_USER_DATA API: User-Specific Settings Table data and field list

DPR_TS_API_ROOT_USER_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "API: User-Specific Settings" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DPR_TS_API_ROOT_USER_DATA TYPE DPR_TS_API_ROOT_USER_DATA.

The DPR_TS_API_ROOT_USER_DATA table consists of various fields, each holding specific information or linking keys about API: User-Specific Settings data available in SAP. These include DEFAULT_PRO_CAUSE (Reason for Project), DEFAULT_PHA_TYPE (Phase Type), DEFAULT_TSK_TYPE (Task Type), DEFAULT_CLH_TYPE (Checklist Type)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

DPR_TS_API_ROOT_USER_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP DPR_TS_API_ROOT_USER_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DPR_TS_API_ROOT_USER_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
DEFAULT_PRO_TYPEProject Type DPR_TV_PRO_TYPECHAR15DPR_PRO_TYPEDPR_TYPEDPR_PROJECT_TYPE
DEFAULT_PRO_CAUSEReason for Project DPR_TV_CAUSECHAR15DPR_CAUSEDPR_CAUSE
DEFAULT_PHA_TYPEPhase Type DPR_TV_PHA_TYPECHAR15DPR_PHA_TYPEDPR_TYPE
DEFAULT_TSK_TYPETask Type DPR_TV_TSK_TYPECHAR15DPR_TSK_TYPEDPR_TYPE
DEFAULT_CLH_TYPEChecklist Type DPR_TV_CLH_TYPECHAR15DPR_CLH_TYPEDPR_TYPE
DEFAULT_CALENDARCalendar DPR_TV_CALENDAR_IDCHAR2TFACDWFCID
SHOW_CHANGE_DOCSDisplay Change Documents DPR_TV_SHOW_CHANGE_DOCSCHAR1BOOLE
FONT_SIZEFont Size in Navigation Tree, Gantt Chart, and Table DPR_TV_FONT_SIZECHAR30DPR_FONT_SIZE
SHOW_HEADERDisplay Application Header DPR_TV_SHOW_HEADERCHAR1BOOLE
DATESEarliest and Latest Dates of Bar in Gantt Chart DPR_TV_DATESCHAR1DPR_DATES
DEFAULT_MODEProcessing Mode When Opening an Object in Project Management DPR_TV_DEFAULT_MODECHAR1DPR_DEFAULT_MODE
INFO_URLURL for Project Management Information Page (Projects) DPR_TV_INFO_URLCHAR255DPR_URL
USE_APPLET_FOR_EDMSObsolete: 'Java Applet f.Document Proc.' no Longer Supported DPR_TV_USE_APPLET_FOR_EDMSCHAR1CHAR1
USE_FILE_EXPLORERUse Microsoft Windows File Explorer Integration DPR_TV_USE_FILE_EXPLORERCHAR1CHAR1
DATE_SETDate Type DPR_TV_DATE_SETCHAR15Assigned to domainDPR_TYPE
DOCUMENT_UPLOADDocument Import Procedure: New Version or Overwrite DPR_TV_DOC_UPLOADCHAR1DPR_DOC_UPLOAD
DEFAULT_DETAIL_VIEWObject Type in Project Planning CGPL_OBJECT_TYPECHAR3CHAR3
DEFAULT_PLANNING_VIEWNatural Number INT4INT410INT4
DEFAULT_PROJECT_VIEWNatural Number INT4INT410INT4
DEFAULT_MYOBJECTS_VIEWNatural Number INT4INT410INT4
DEFAULT_FIN_GECCO_VIEWSingle-Character Indicator CHAR1CHAR1CHAR1
CHANGE_DOCS_FROMTime Period of Change Documents: From DPR_TV_CHANGE_DOCS_FROMDATS8
CHANGE_DOCS_TOTime Period of Change Documents: To DPR_TV_CHANGE_DOCS_TODATS8
CHANGE_DOCS_MANUALTime Frame for Selecting Change Documents DPR_TV_CHANGE_DOCS_PERIODCHAR2DPR_CHANGE_DOCS_PERIOD
TEXT_LANGUAGESelect Language for Text in Project DPR_TV_MASTER_LANGU_SELECTCHAR1DPR_MASTER_LANGU_SELECT
DEFAULT_PROJECT_MYOBJECTS_VIEW 0
DEFAULT_TASK_MYOBJECTS_VIEW 0
DEFAULT_CL_ITEM_MYOBJECTS_VIEW 0
DEFAULT_CTRLP_MYOBJECTS_VIEW 0
DEFAULT_VERSION_MYOBJECTS_VIEW 0
DEFAULT_VER_SIM_MYOBJECTS_VIEW 0
DEFAULT_VER_SNP_MYOBJECTS_VIEW 0
DEFAULT_TEMPL_MYOBJECTS_VIEW 0
DEFAULT_CKL_T_MYOBJECTS_VIEW 0
DEFAULT_CTRLP_T_MYOBJECTS_VIEW 0
DEFAULT_PRO_T_MYOBJECTS_VIEW 0
DEFAULT_EVA_OP_MYOBJECTS_VIEW 0
DEFAULT_EVA_SIM_MYOBJECTS_VIEW 0
DEFAULT_EVA_SNP_MYOBJECTS_VIEW 0
TABLE_SCROLLINGActivate Scrolling for Table View DPR_TV_TABLE_SCROLLINGCHAR1BOOLEAN
TREE_SCROLLINGActivate Scrolling for Tree and Role Navigator DPR_TV_TREE_SCROLLINGCHAR1BOOLEAN
TREE_WIDTHSpecify Width (in Pixels) for Project Structure DPR_TV_TREE_WIDTHNUMC3
SCHEDULE_ON_REQUESTTrigger Scheduling - Manually (='X') / Automatically (= ' ') DPR_TV_SCHEDULE_ON_REQUESTCHAR1BOOLE
DEFAULT_RES_MAXIMUM_HITSNatural Number INT4INT410INT4
DEFAULT_RES_MINIMUM_AVAILDummy for B20 int1 (Local Everywhere) INT1INT13INT1
DEFAULT_RES_MINIMUM_SKILLPercent Staffed DPR_TV_STAFF_PERCENTNUMC3NUMC3
GANTT_HIDDEN_COLUMNS Hidden Columns in GANTT (<256 Characters)0
GANTT_HIDE_RELATIONS Hide Relationships in GANTT0
GANTT_HIDDEN_COLUMNS2 Hidden Columns in GANTT (<256 Characters)0
GANTT_HIDE_SCHEDULE_CONFLICTS Do not highlight the scheduling conflicts in the GANTT chart0
DELETE_WITHOUT_CONFIRMDelete Project Elements Without Confirmation DPR_TV_DELETE_WITHOUT_CONFIRMCHAR1BOOLE
NO_DETAIL_NAVIGATIONNo Navigation to Detail Data When Creating New Element DPR_TV_NO_DETAIL_AT_CREATECHAR1BOOLE
DEFAULT_VIEWDefault Start Views for Project Management DPR_TV_DEFAULT_VIEWNUMC2DPR_TV_DEFAULT_VIEW
FILTER_START_DATEDate DPR_TV_DATEDATS8DATS
FILTER_END_DATEDate DPR_TV_DATEDATS8DATS
FILTER_REF_DATEDate DPR_TV_DATEDATS8DATS
FILTER_TYPEObject Type DPR_TV_TYPECHAR15Assigned to domainDPR_TYPE
FILTER_TODAYData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
FILTER_RANGESelection for Filter Period (User Settings) DPR_FILTER_RANGENUMC2DPR_FILTER_RANGE_LIST
FILTER_PAGE_NUMNatural Number INT4INT410INT4
GANTT_MORE_INFORMATION More information in GANTT (1-255 Characters)0
OPTIMIZED_FOR_RESOLUTIONSettings Optimized for Resolution DPR_TV_OPTIMIZED_FOR_RESCHAR12DPR_OPTIMIZED_FOR_RESOLUTION

Key field Non-key field



How do I retrieve data from SAP structure DPR_TS_API_ROOT_USER_DATA using ABAP code?

As DPR_TS_API_ROOT_USER_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DPR_TS_API_ROOT_USER_DATA as there is no data to select.

How to access SAP table DPR_TS_API_ROOT_USER_DATA

Within an ECC or HANA version of SAP you can also view further information about DPR_TS_API_ROOT_USER_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).