SAP DPR_MSP_RESOURCES_INT Modified MSP Resources Table data and field list

DPR_MSP_RESOURCES_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 "Modified MSP Resources" 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_RESOURCES_INT TYPE DPR_MSP_RESOURCES_INT.

The DPR_MSP_RESOURCES_INT table consists of various fields, each holding specific information or linking keys about Modified MSP Resources data available in SAP. These include UID (The unique identifier of the resource.), ID (The position of the resource within the list of resources), NAME (The name of the resource.), TYPE (The type of resource. Values are: 0=Material, 1=Work)... 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_RESOURCES_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_RESOURCES_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_RESOURCES_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
RESOURCE_DATA 0
UID The unique identifier of the resource.0
ID The position of the resource within the list of resources0
NAME The name of the resource.0
TYPE The type of resource. Values are: 0=Material, 1=Work0
IS_NULL Specifies whether the resource is null.0
INITIALS The initials of the resource.0
PHONETICS The phonetic spelling of the resource name.0
NTACCOUNT The NT account associated with the resource.0
MATERIAL_LABEL The unit of measure for the material resource.0
CODE The code or other information about the resource.0
GROUP The group to which the resource belongs.0
WORK_GROUP The type of workgroup to which the resource belongs.0
EMAIL_ADDRESS The email address of the resource.0
HYPERLINK The title of the hyperlink associated with the resource.0
HYPERLINK_ADDRESS The hyperlink associated with the resource.0
HYPERLINK_SUB_ADDRESS Document bookmark of hyperlink associated with the resource.0
MAX_UNITS The maximum number of units available for that resource.0
PEAK_UNITS The largest number of units of that resource assigned ever0
OVER_ALLOCATED specifies whether the resource is overallocated0
AVAILABLE_FROMConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
AVAILABLE_TOConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
STARTConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
FINISHConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
CAN_LEVEL specifies whether the resource can be leveled.0
ACCRUE_AT specifies how cost is accrued against the resource.0
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
OVERTIME_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
ACTUAL_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
REMAINING_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
REMAINING_OVERTIME_WORKMSP Work Effort DPR_TV_MSP_WORKQUAN16(3) DPR_TV_MSP_WORK
PERCENT_WORK_COMPLETE The percentage of work completed across all tasks.0
STANDARD_RATE The standard rate of the resource.0
STANDARD_RATE_FORMAT The units used by MS Project to display the standard rate.0
COST Total project cost for the resource across all assigned task0
OVERTIME_RATE The overtime rate of the resource.0
OVERTIME_RATE_FORMAT The units used by MS Project to display the overtime rate.0
OVERTIME_COST Total overtime cost for the resource (actual + remaining)0
COST_PER_USE The cost per use of the resource.0
ACTUAL_COST Actual cost incurred by a resource across all assigned tasks0
ACTUAL_OVERTIME_COST The actual overtime cost incurred by the resource.0
REMAINING_COST remaining projectedcost of the resource to complete alltasks0
REMAINING_OVERTIME_COST remaining projected overtimecost of res to complete alltasks0
WORK_VARIANCE Difference between baseline work & work as minutes * 10000
COST_VARIANCE The difference between the baseline cost and the cost.0
SV value schedule variance, through the project status date0
CV Earned value cost variance, through the project status date0
ACWP The actual cost of the work performed on the task to-date0
CALENDAR_UIDCalendar DPR_TV_MSP_CALENDAR_IDCHAR2WFCID
NOTES Text notes associated with the resource.0
BCWS The budget cost of work scheduled for the resource.0
BCWP budgeted cost of the work performed by the resource to-date0
IS_GENERIC Specifies whether the resource is generic.0
IS_INACTIVE Specifies whether the resource is set to inactive.0
IS_ENTERPRISE Specifies whether the resource is an Enterprise resource.0
BOOKING_TYPE Specifies bookingtype of the resource.1=Commited, 2=Proposed0
ACTUAL_WORK_PROTECTED The duration through which actual work is protected0
ACTUAL_OVERTIME_WORK_PROTECTED The duration through which actual overtime work is protected0
ACTIVE_DIRECTORY_GUID The Active Directory GUID for the resource.0
CREATION_DATEConverted Dates for MSP Project DPR_TV_MSP_DATEDATS8DPR_TV_MSP_DATE
WORK_UNIT 0
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
ASSIGNMENTS 0

Key field Non-key field



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

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

How to access SAP table DPR_MSP_RESOURCES_INT

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