SAP DPR_TS_UI_TABLE_DATA Project Management: Project Data in Table View Table data and field list

DPR_TS_UI_TABLE_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 "Project Management: Project Data in Table View" 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_UI_TABLE_DATA TYPE DPR_TS_UI_TABLE_DATA.

The DPR_TS_UI_TABLE_DATA table consists of various fields, each holding specific information or linking keys about Project Management: Project Data in Table View data available in SAP. These include LEVEL (Stage in Project Management Structure), OBJECT_TYPE (Object Category in Project Planning), GUID (Unique Object Key (CHAR32)), EXPLANATION (General Explanation (such as ID or Short Text) of an Object)... 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_UI_TABLE_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP DPR_TS_UI_TABLE_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_UI_TABLE_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
LEVELStage in Project Management Structure DPR_TV_BAPI_LEVELNUMC3NUMC3
OBJECT_TYPEObject Category in Project Planning DPR_TV_BAPI_OBJECT_TYPECHAR3CHAR3
GUIDUnique Object Key (CHAR32) DPR_TV_GUID_BAPICHAR32SYSUUID_C
EXPLANATIONGeneral Explanation (such as ID or Short Text) of an Object DPR_TV_BAPI_EXPLANATIONCHAR80CHAR80
SUPERIOR_OBJECT_TYPEObject Category of Superior Object in Project Planning DPR_TV_BAPI_SUP_OBJECT_TYPECHAR3CHAR3
SUPERIOR_GUIDUnique Object Key (CHAR32) of Superior Object DPR_TV_SUP_GUID_BAPICHAR32SYSUUID_C
PARENT_GUIDUnique Object Key (CHAR32) DPR_TV_GUID_BAPICHAR32SYSUUID_C
ICON_SOURCE Path to Icon for Object Category0
ICON_TOOLTIP Quick Info for Object Category0
STATUS_ICON_SOURCE Path to Icon for Severity0
STATUS_ICON_TOOLTIP Quick Info for Severity0
CHANGE_MODEReplacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEANCHAR1WDY_BOOLEAN
IS_LEAFReplacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEANCHAR1WDY_BOOLEAN
EXPANDEDReplacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEANCHAR1WDY_BOOLEAN
CHILDREN_LOADEDReplacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEANCHAR1WDY_BOOLEAN
CELL_DESIGNWeb Dynpro: TableCellDesign WDUI_TABLE_CELL_DESIGNNUMC2WDUI_TABLE_CELL_DESIGN
SORT_NUMBERSort Number DPR_TV_SORT_NUMBERNUMC5
ENABLEDReplacement for Real Boolean Type: 'X' == True '' == False WDY_BOOLEANCHAR1WDY_BOOLEAN
ROW_DTI_NAME Drop Target Info0
STSMAStatus Profile J_STSMACHAR8Assigned to domainJ_STSMA
STATTXTConcatenated Status Text of an Object DPR_TV_STATUS_TXTSTRG0
SHORTTEXTProject Element Name DPR_TV_NAMECHAR40TEXT40
STATUS_KEYChange Status DPR_TV_STATUS_CHANGECHAR17
CONSTRAINT_TYPEConstraint on Start Date DPR_TV_START_CONSTRAINTCHAR1DPR_START_CONSTRAINT
CONSTR_TYPE_FINConstraint on Finish Date DPR_TV_FINISH_CONSTRAINTCHAR1DPR_FINISH_CONSTRAINT
CONSTR_START_DATEConstraint Start Date DPR_TV_START_DATE_CONSTRAINTDATS8
CONSTR_FINISH_DATEPredefined Finish Date DPR_TV_FINISH_DATE_CONSTRAINTDATS8
CALCULATED_START_DATECalculated Start Date DPR_TV_SCHEDULED_STARTDATS8
CALCULATED_FINISH_DATECalculated Finish Date DPR_TV_SCHEDULED_FINISHDATS8
DOCUMENT_COUNTNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
COLLAB_COUNTNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
OBJLINK_COUNTNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
DMS_COUNTNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
RESP_ABSTR_ROLEResponsible Role DPR_TV_ABSTR_ROLE_GUIDCHAR32SYSUUID_C
RESP_CONCR_ROLEResponsible Resource DPR_TV_CONCR_ROLE_GUIDCHAR32SYSUUID_C
RESP_BUPAS Responsible Business Partner0
ICON_CRITICAL_PATH Icon Element on Critical Path0
CALCULATED_EARLY_START_DATEEarliest Start Date DPR_TV_SCHEDULED_START_EARLYDATS8
CALCULATED_EARLY_FINISH_DATEEarliest Finish Date DPR_TV_SCHEDULED_FINISH_EARLYDATS8
CALCULATED_LATE_START_DATELatest Start Date DPR_TV_SCHEDULED_START_LATEDATS8
CALCULATED_LATE_FINISH_DATELatest Finish Date DPR_TV_SCHEDULED_FINISH_LATEDATS8
DURATIONProcessing Time DPR_TV_DURATIONQUAN4
DURATION_UNITTime Unit for Execution Duration CGPL_DURATION_UNITUNIT3Assigned to domainCUNITMEINS
COMPLETIONPercentage of Completion CGPL_COMPLETIONNUMC3CGPL_COMPLETION
RESULT_CKL_ITEMResult for Checklist Item DPR_TV_CKLITEM_RESULTCHAR1DPR_CKLITEM_RESULT
FLAG_OKOK DPR_TV_CHECKLIST_ITEM_OKCHAR1DPR_BOOLEAN
FLAG_NOKNot OK DPR_TV_CHECKLIST_ITEM_NOKCHAR1DPR_BOOLEAN
FLAG_NOT_RELEVANTNot Relevant DPR_TV_NOT_RELEVANTCHAR1DPR_BOOLEAN
TYPEShort Text for Type DPR_TV_TYPE_TEXTCHAR40DPR_TEXT
PRIORITYPriority CGPL_PRIORITYNUMC3NUMC3
GROUPINGGrouping DPR_TV_GROUPINGCHAR40
SEARCH_FIELDSearch Field DPR_TV_SEARCH_FIELDCHAR40
PROCESSProcess DPR_TV_PROCESSCHAR15Assigned to domainDPR_PROCESS
FLAG_MANDATORYMandatory DPR_TV_OBLIGATORYCHAR1DPR_BOOLEAN
FLAG_APPROVAL_RELEVANTRelevant for Approval DPR_TV_APPROVAL_RELEVANTCHAR1DPR_BOOLEAN
FLAG_MILESTONEMilestone Indicator DPR_TV_MILESTONECHAR1DPR_BOOLEAN
PLANNED_WORKWork DPR_TV_WORKQUAN9(2) DPR_WORK
PLANNED_WORK_UNITUnit for Work DPR_TV_WORK_UNITUNIT3Assigned to domainCUNITMEINS
PLANNED_WORK_UNIT_TEXTUnit of Measurement MSEHIUNIT3Assigned to domainCUNITMEINS
ACTUAL_WORKConfirmation DPR_TV_ACT_WORK_EXTQUAN9(2) DPR_WORK
ACTUAL_WORK_UNITConfirmation Unit DPR_TV_ACT_WRK_UNITUNIT3Assigned to domainCUNITMEINS
ACTUAL_WORK_UNIT_TEXTUnit of Measurement MSEHIUNIT3Assigned to domainCUNITMEINS
REM_WRK_EFFORT_EXTRemaining Work DPR_TV_REM_WORK_EXTQUAN9(2) DPR_WORK
REM_WRK_UNIT_EXTUnit for Remaining Work DPR_TV_REM_WRK_UNITUNIT3Assigned to domainCUNITMEINS
REM_WRK_UNIT_TEXTUnit of Measurement MSEHIUNIT3Assigned to domainCUNITMEINS
ICON_CRITICAL_PATH_TT Tooltip critical paht0
ACTUAL_STARTActual Start DPR_TV_ACTUAL_STARTDATS8
ACTUAL_FINISHActual Finish DPR_TV_ACTUAL_FINISHDATS8
STATUS_KEY_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
RESP_ABSTR_ROLE_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
RESP_CONCR_ROLE_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CONSTRAINT_TYPE_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CONSTR_TYPE_FIN_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CONSTR_START_DATE_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CONSTR_FINISH_DATE_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
DURATION_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
RESULT_CKL_ITEM_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
COMPLETION_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
PRIORITY_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
PROCESS_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
GROUPING_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
SEARCH_FIELD_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
FLAG_MILESTONE_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
FLAG_APPROVAL_RELEVANT_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
FLAG_MANDATORY_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
PLANNED_WORK_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
ACTUAL_WORK_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
REM_WRK_EFFORT_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
DESCRIPTION_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
ACTUAL_START_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
ACTUAL_FINISH_ROData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CELLVARIANT Cell Variant0

Key field Non-key field



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

As DPR_TS_UI_TABLE_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_UI_TABLE_DATA as there is no data to select.

How to access SAP table DPR_TS_UI_TABLE_DATA

Within an ECC or HANA version of SAP you can also view further information about DPR_TS_UI_TABLE_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).