SAP DPR_MSP_TASKS_INT The collection of tasks that make up the project Table data and field list

DPR_MSP_TASKS_INT 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 "The collection of tasks that make up the project" 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_MSP_TASKS_INT TYPE DPR_MSP_TASKS_INT.

The DPR_MSP_TASKS_INT table consists of various fields, each holding specific information or linking keys about The collection of tasks that make up the project data available in SAP. These include UID (The unique ID of the task.), ID (The position identifier of the task within the list of tasks), NAME (The name of the task.), TYPE (Type of task.(Vals:0=FixedUnits,1=FixedDuration,2=Fixedwork))... 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_MSP_TASKS_INT 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_MSP_TASKS_INT 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_MSP_TASKS_INT 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
TASK_DATA 0
UID The unique ID of the task.0
ID The position identifier of the task within the list of tasks0
NAME The name of the task.0
TYPE Type of task.(Vals:0=FixedUnits,1=FixedDuration,2=Fixedwork)0
IS_NULLMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
CREATE_DATEConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
CONTACT Specifies the contact person for the task.0
WBS The 'work breakdown structure' code of the task.0
WBSLEVEL The rightmost WBS level of the task.0
OUTLINE_NUMBER The outline number of the task.0
OUTLINE_LEVEL The outline level of the task.0
PRIORITY The priority of the task. Ranges from 0 to 1000.0
STARTConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
FINISHConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DURATIONMS Project Duration DPR_TV_MSP_DURATIONDEC10(2)
DURATION_FORMAT The format for expressing the Duration of the Task.0
DURATION_NUMBERMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
STOPConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
RESUMEConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
RESUME_VALIDMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
EFFORT_DRIVENMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
RECURRINGMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
OVER_ALLOCATEDMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
ESTIMATEDMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
MILESTONEMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
SUMMARYMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
CRITICALMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
IS_SUBPROJECTMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
IS_SUBPROJECT_READ_ONLYMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
SUBPROJECT_NAME The source location of the inserted project.0
EXTERNAL_TASKMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
EXTERNAL_TASK_PROJECT The source location and task identifier of the external task0
EARLY_STARTConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
EARLY_FINISHConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
LATE_STARTConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
LATE_FINISHConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
START_VARIANCE Variance of task strtdate from baseline strtdate as min*10000
FINISH_VARIANCE Variance of tsk finshdate from baseln finshdate as min*10000
WORK_VARIANCE Variance of task work from baseline task work as min * 10000
FREE_SLACK The amount of free slack.0
TOTAL_SLACK The amount of total slack.0
FIXED_COST The fixed cost of the task.0
FIXED_COST_ACCRUAL Specifies how the fixed cost is accrued against the task.0
PERCENT_COMPLETE The percentage of the task duration completed.0
PERCENT_WORK_COMPLETE The percentage of the task work completed.0
COST The projected or scheduled cost of the task.0
OVERTIME_COST The sum of actual and remaining overtime costs of the task0
OVERTIME_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
ACTUAL_STARTConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
ACTUAL_FINISHConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
ACTUAL_DURATION The actual duration of the task.0
ACTUAL_COST The actual cost of the task.0
ACTUAL_OVERTIME_COST The actual overtime cost of the task.0
ACTUAL_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
ACTUAL_OVERTIME_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
REGULAR_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
REMAINING_DURATION Amount of time required to complete the unfinished portion.0
REMAINING_COST The remaining projected cost of completing the task.0
REMAINING_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
REMAINING_OVERTIME_COST The remaining overtime cost projected to finish the task.0
REMAINING_OVERTIME_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
ACWP The actual cost of work performed on the task to-date.0
CV Earned value cost variance.0
CONSTRAINT_TYPE The constraint on the start or finish date of the task.0
CALENDAR_UIDCalendar DPR_TV_MSP_CALENDAR_IDCHAR2WFCID
CONSTRAINT_DATEConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DEADLINEConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
LEVEL_ASSIGNMENTSMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
LEVELING_CAN_SPLITMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
LEVELING_DELAY The delay caused by leveling the task.0
LEVELING_DELAY_FORMAT The format for expressing the duration of the delay.0
PRE_LEVELED_STARTConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
PRE_LEVELED_FINISHConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
HYPERLINK The title of the hyperlink associated with the task.0
HYPERLINK_ADDRESS The hyperlink associated with the task.0
HYPERLINK_SUB_ADDRESS Document bookmark of the hyperlink associated with the task.0
IGNORE_RESOURCE_CALENDARMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
NOTES Text notes associated with the task.0
HIDE_BARMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
ROLLUPMS Project Type for Boolean DPR_TV_MSP_BOOLCHAR1DPR_MSP_BOOL
BCWS The budgeted cost of work scheduled for the task.0
BCWP The budgeted cost of work performed on the task to-date.0
PHYSICAL_PERCENT_COMPLETE The percentage complete value entered by the Project Manager0
EARNED_VALUE_METHOD The method for calculating earned value.0
ACTUAL_WORK_PROTECTED The duration through which actual work is protected.0
ACTUAL_OVERTIME_WORK_PROTECTED The duration through which actual overtime work is protected0
WORK_UNIT 0
DURATION_UNIT 0
PHASE_DESCRIPTION 0
GUID_CHARUnique Object Key DPR_TV_OBJECT_GUID_CHARCHAR32SYSUUID_C
TEXT1 Enterprise Text Field 10
TEXT2 Enterprise Text Field 20
TEXT3 Enterprise Text Field 30
TEXT4 Enterprise Text Field 40
TEXT5 Enterprise Text Field 50
TEXT6 Enterprise Text Field 60
TEXT7 Enterprise Text Field 70
TEXT8 Enterprise Text Field 80
TEXT9 Enterprise Text Field 90
TEXT10 Enterprise Text Field 100
TEXT11 Enterprise Text Field 110
TEXT12 Enterprise Text Field 120
TEXT13 Enterprise Text Field 130
TEXT14 Enterprise Text Field 140
TEXT15 Enterprise Text Field 150
TEXT16 Enterprise Text Field 160
TEXT17 Enterprise Text Field 170
TEXT18 Enterprise Text Field 180
TEXT19 Enterprise Text Field 190
TEXT20 Enterprise Text Field 200
TEXT21 Enterprise Text Field 210
TEXT22 Enterprise Text Field 220
TEXT23 Enterprise Text Field 230
TEXT24 Enterprise Text Field 240
TEXT25 Enterprise Text Field 250
TEXT26 Enterprise Text Field 260
TEXT27 Enterprise Text Field 270
TEXT28 Enterprise Text Field 280
TEXT29 Enterprise Text Field 290
TEXT30 Enterprise Text Field 300
NUMBER1 Enterprise Number Field 10
NUMBER2 Enterprise Number Field 20
NUMBER3 Enterprise Number Field 30
NUMBER4 Enterprise Number Field 40
NUMBER5 Enterprise Number Field 50
NUMBER6 Enterprise Number Field 60
NUMBER7 Enterprise Number Field 70
NUMBER8 Enterprise Number Field 80
NUMBER9 Enterprise Number Field 90
NUMBER10 Enterprise Number Field 100
NUMBER11 Enterprise Number Field 110
NUMBER12 Enterprise Number Field 120
NUMBER13 Enterprise Number Field 130
NUMBER14 Enterprise Number Field 140
NUMBER15 Enterprise Number Field 150
NUMBER16 Enterprise Number Field 160
NUMBER17 Enterprise Number Field 170
NUMBER18 Enterprise Number Field 180
NUMBER19 Enterprise Number Field 190
NUMBER20 Enterprise Number Field 200
DATE1Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE2Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE3Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE4Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE5Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE6Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE7Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE8Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE9Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
DATE10Converted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
OUTLINECODE1 Outline Code for MSP Project0
OUTLINECODE2 Outline Code for MSP Project0
OUTLINECODE3 Outline Code for MSP Project0
OUTLINECODE4 Outline Code for MSP Project0
OUTLINECODE5 Outline Code for MSP Project0
OUTLINECODE6 Outline Code for MSP Project0
OUTLINECODE7 Outline Code for MSP Project0
OUTLINECODE8 Outline Code for MSP Project0
OUTLINECODE9 Outline Code for MSP Project0
OUTLINECODE10 Outline Code for MSP Project0
DISPLAY_AS_SUMMARY 0
START_SLACK 0
FINISH_SLACK 0
ACTIVE 0
MANUAL 0
MANUAL_START 0
MANUAL_FINISH 0
MANUAL_DURATION 0
START_TEXT 0
FINISH_TEXT 0
ASSIGNMENTS 0
PREDECESSOR_LINK 0

Key field Non-key field



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

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

How to access SAP table DPR_MSP_TASKS_INT

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

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