DPR_PART SAP (Project Participants) Table details
Dictionary Type: Table
Description: Project Participants
Description: Project Participants
Table field list including key, data, relationships and ABAP select examples
DPR_PART is a standard SAP Table which is used to store Project Participants data and is available within R/3 SAP systems depending on the version and release level.
The DPR_PART table consists of various fields, each holding specific information or linking keys about Project Participants data available in SAP. These include GUID (Application Object GUID (Entity with Conversion Exit)), PROC_STATUS_OWN (Object Processing Status), PROC_STATUS_SUP (Processing Status of Higher-Level Object), SORT_NUMBER (Sort Number).. 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. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DPR_PART table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID | Application Object GUID (Entity with Conversion Exit) | DPR_TV_ENTITY_GUID | RAW | 16 | DPRCE | DPR_ENTITY_GUID | |||
PROC_STATUS_OWN | Object Processing Status | DPR_TV_PROC_STATUS_OWN | CHAR | 2 | DPR_PROC_STATUS | ||||
PROC_STATUS_SUP | Processing Status of Higher-Level Object | DPR_TV_PROC_STATUS_SUP | CHAR | 2 | DPR_PROC_STATUS | ||||
SORT_NUMBER | Sort Number | DPR_TV_SORT_NUMBER | NUMC | 5 | |||||
VERSION_NUMBER | Version Number | CGPL_TV_VERSION | CHAR | 24 | CGPL_VERSION | ||||
PARTICIPANT_ROLE | Role Type for Projects | DPR_TV_PARTICIPANT_ROLE | CHAR | 15 | DPR_PART_ROLE | DPR_PARTICIPANT_ROLE | |||
BEG_TMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
END_TMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
WORK_EFFORT | Demand or Assigned Effort | DPR_TV_EFFORT | QUAN | 9(2) | DPR_WORK | ||||
WORK_UNIT | Unit for Demand or Effort | DPR_TV_EFFORT_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
C_OBJID | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
PARTNER_ROLE | BP Role | DPR_TV_BU_ROLE | CHAR | 6 | Assigned to domain | BU_RLTYP | BUPA_ROLE | ||
VACANT | Vacant Checkbox of Role | DPR_TV_VACANT | CHAR | 1 | DPR_BOOLEAN | ||||
CAND_IN_WORKLIST | Role Is Displayed in Candidate Manager's Worklist | DPR_TV_CANDIDATE_IN_WORKLIST | CHAR | 1 | DPR_BOOLEAN | ||||
STAT_PROFILE_PRT | Status Profile Template | DPR_TV_STAT_PROFILE_PRT | CHAR | 8 | Assigned to domain | J_STSMA | |||
VC_BUPA_GUID | Application Object GUID | DPR_TV_GUID | RAW | 16 | DPR_GUID | ||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | Assigned to domain | DPR_RATE_TYPE | |||
REVENUE_RATE | Different Revenue | DPR_TV_REVENUE_RATE_MANUAL | CURR | 11(2) | PREIS | ||||
CURRENCY | Currency Key | WAERS_CURC | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
COST_RATE | Different Costs | DPR_TV_COST_RATE_MANUAL | CURR | 11(2) | PREIS | ||||
CURRENCY_COST | Currency Key | WAERS_CURC | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
TIME_UNIT | Activity Unit for Deviating Costs and Revenues | DPR_TV_TIME_UNIT_MANUAL | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACT_WORK_EFFORT | Confirmation (Insternal Display) | DPR_TV_ACT_WORK | QUAN | 16(3) | DPR_WORK_LONG | ||||
ACT_WORK_UNIT | Confirmation Unit | DPR_TV_ACT_WRK_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ACT_WRK_UNIT_EXT | Confirmation Unit | DPR_TV_ACT_WRK_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CONF_GUID | GUID of a Confirmation Document | DPR_TV_CONF_GUID | RAW | 16 | |||||
CONCRETE_ROLE | Shadow Role (= Concrete Role) | DPR_TV_CONCRETE_ROLE | CHAR | 1 | CHAR1 | ||||
PARTICIPANT_ID | Role ID | DPR_TV_PART_ID | CHAR | 24 | CHAR24 | ||||
URGENCY | Urgency | DPR_TV_URGENCY | CHAR | 2 | DPR_URGENCY | ||||
ROLE_FUNCTION_ID | ID of Role Function | DPR_TV_ROLE_FUNCTION_ID | CHAR | 15 | DPR_ROLE_FUNC | DPR_ROLE_FUNCTION_ID | |||
LOCATION | Location | DPR_TV_LOCATION | CHAR | 4 | DPR_LOCATION | DPR_LOCATION | |||
STAFF_PERCENT | Percent Staffed | DPR_TV_STAFF_PERCENT | NUMC | 3 | NUMC3 | ||||
EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | DPR_TV_EA_DUMMY | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table DPR_PART using ABAP code
The following ABAP code Example will allow you to do a basic selection on DPR_PART to SELECT all data from the tableDATA: WA_DPR_PART TYPE DPR_PART.
SELECT SINGLE *
FROM DPR_PART
INTO CORRESPONDING FIELDS OF WA_DPR_PART
WHERE...
How to access SAP table DPR_PART
Within an ECC or HANA version of SAP you can also view further information about DPR_PART and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects