DPR_TS_PART_PRT SAP (Project Participant Data) Structure details

Dictionary Type: Structure
Description: Project Participant Data




ABAP Code to SELECT data from DPR_TS_PART_PRT
Related tables to DPR_TS_PART_PRT
Access table DPR_TS_PART_PRT




Structure field list including key, data, relationships and ABAP select examples

DPR_TS_PART_PRT 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 Participant Data" 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_PART_PRT TYPE DPR_TS_PART_PRT.

The DPR_TS_PART_PRT table consists of various fields, each holding specific information or linking keys about Project Participant Data data available in SAP. These include GUID (Application Object GUID), VERSION_NUMBER (Version Number), SCHEDULED_START (Calculated Start Date), SCHEDULED_FINISH (Calculated Finish Date).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP DPR_TS_PART_PRT structure 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
IS_TEMPLATETemplate (Yes/No) DPR_TV_IS_TEMPLATECHAR1CHAR1
GUIDApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
VERSION_NUMBERVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
SCHEDULED_STARTCalculated Start Date DPR_TV_SCHEDULED_STARTDATS8
SCHEDULED_FINISHCalculated Finish Date DPR_TV_SCHEDULED_FINISHDATS8
COST_RATE_DEFCost per Activity Unit DPR_TV_COST_VALUECURR11(2) PREIS
REVENUE_RATE_DEFRevenues per Activity Unit DPR_TV_REVENUE_VALUECURR11(2) PREIS
WORK_UNIT_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
TIME_UNIT_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
ACT_WRK_UNIT_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
CONCRETE_ROLEShadow Role (= Concrete Role) DPR_TV_CONCRETE_ROLECHAR1CHAR1
AREAArea DPR_TV_AREACHAR4Assigned to domainDPR_AREA
AREA_TEXTArea Text DPR_TV_AREA_TEXTCHAR30TEXT30
OBJNRGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
ISTATSystem status J_ISTATCHAR5Assigned to domainJ_ISTAT
ESTATUser Status J_ESTATCHAR5Assigned to domainJ_ESTAT
STSMAStatus Profile J_STSMACHAR8Assigned to domainJ_STSMA
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
TXT04Individual status of an object (short form) J_TXT04CHAR4TEXT4
TXT30Object status J_TXT30CHAR30TEXT30
STATTXTConcatenated Status Text of an Object DPR_TV_STATUS_TXTSTRG0
SORT_NUMBERSort Number DPR_TV_SORT_NUMBERNUMC5
PARTICIPANT_ROLERole Type for Projects DPR_TV_PARTICIPANT_ROLECHAR15DPR_PART_ROLEDPR_PARTICIPANT_ROLE
BEG_TMSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
END_TMSTMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
WORK_EFFORTDemand or Assigned Effort DPR_TV_EFFORTQUAN9(2) DPR_WORK
WORK_UNITUnit for Demand or Effort DPR_TV_EFFORT_UNITUNIT3Assigned to domainCUNITMEINS
C_OBJIDObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
PARTNER_ROLEBP Role DPR_TV_BU_ROLECHAR6Assigned to domainBU_RLTYPBUPA_ROLE
VACANTVacant Checkbox of Role DPR_TV_VACANTCHAR1DPR_BOOLEAN
CAND_IN_WORKLISTRole Is Displayed in Candidate Manager's Worklist DPR_TV_CANDIDATE_IN_WORKLISTCHAR1DPR_BOOLEAN
STAT_PROFILE_PRTStatus Profile Template DPR_TV_STAT_PROFILE_PRTCHAR8Assigned to domainJ_STSMA
VC_BUPA_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15Assigned to domainDPR_RATE_TYPE
REVENUE_RATEDifferent Revenue DPR_TV_REVENUE_RATE_MANUALCURR11(2) PREIS
CURRENCYCurrency Key WAERS_CURCCUKY5Assigned to domainWAERSFWS
COST_RATEDifferent Costs DPR_TV_COST_RATE_MANUALCURR11(2) PREIS
CURRENCY_COSTCurrency Key WAERS_CURCCUKY5Assigned to domainWAERSFWS
TIME_UNITActivity Unit for Deviating Costs and Revenues DPR_TV_TIME_UNIT_MANUALUNIT3Assigned to domainCUNITMEINS
ACT_WRK_EFFORT_EXTConfirmation DPR_TV_ACT_WORK_EXTQUAN9(2) DPR_WORK
ACT_WRK_UNIT_EXTConfirmation Unit DPR_TV_ACT_WRK_UNITUNIT3Assigned to domainCUNITMEINS
CONF_GUIDGUID of a Confirmation Document DPR_TV_CONF_GUIDRAW16
EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
EXTERNAL_IDProject Planning: External Indentifier of an Element CGPL_EXTIDCHAR24CGPL_EXTID
BEG_DATEStart Date BEGDADATS8DATUM
END_DATEEnd Date ENDDADATS8DATUM
DESCRIPTIONLanguage-Dependent Description CGPL_TEXT1CHAR40TEXT40
PARTICIPANT_ROLE_TEXTName of Role Type DPR_TV_PARTICIPANT_ROLE_TEXTCHAR40DPR_TEXT
PARTICIPANT_IDRole ID DPR_TV_PART_IDCHAR24CHAR24
ROLE_FUNCTION_IDID of Role Function DPR_TV_ROLE_FUNCTION_IDCHAR15DPR_ROLE_FUNCDPR_ROLE_FUNCTION_ID
LOCATIONLocation DPR_TV_LOCATIONCHAR4Assigned to domainDPR_LOCATION
URGENCYUrgency DPR_TV_URGENCYCHAR2DPR_URGENCY
.INCLU-INT 0
GUIDINTApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
EXTERNAL_IDINTProject Planning: External Indentifier of an Element CGPL_EXTIDCHAR24CGPL_EXTID
PROJECT_GUIDINTProject Planning: 16 Character GUID for Projects CGPL_PROJECT_GUIDRAW16CGPLPCGPL_PROJECT_GUID
OBJECT_TYPEINTObject Type in Project Planning CGPL_OBJECT_TYPECHAR3CHAR3
PRIORITYINTPriority CGPL_PRIORITYNUMC3CGPL_PRIONUMC3
ACTUALSTARTINTActual Start Date CGPL_ACTUALSTARTDEC15TSTPSBCOS_TSTMP
ACTUALFINISHINTActual Finish Date CGPL_ACTUALFINISHDEC15TSTPSBCOS_TSTMP
PLANSTARTINTPlanned start date CGPL_PLANSTARTDEC15TSTPSBCOS_TSTMP
PLANFINISHINTPlanned Finish Date CGPL_PLANFINISHDEC15TSTPSBCOS_TSTMP
COMPLETIONINTPercentage of Completion CGPL_COMPLETIONNUMC3CGPL_COMPLETION
MILESTONEINTMilestone indicator CGPL_MILESTONECHAR1CHAR1
CONSTRAINT_TYPEINTType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTRAINT_TIMEINTConstraint Date CGPL_CONSTRAINT_TIMEDEC15TSTPSBCOS_TSTMP
CREATED_BYINTName of Person Who Created Object CGPL_CREATED_BYCHAR12USNAM
CREATED_ONINTDate When the Object Was Created CGPL_CREATED_ONDATS8DATUM
CREATED_IN_BWINTTransfer Object to BW CGPL_CREATED_BWCHAR1CHAR1
CHANGED_BYINTName of Person Who Changed Object CGPL_CHANGED_BYCHAR12USNAM
CHANGED_ONINTDate on which object was last changed CGPL_CHANGED_ONDATS8DATUM
UPDATED_IN_BWINTCurrent Object in BW CGPL_UPDATED_BWCHAR1CHAR1
BWIDENTIFIERINTProject Planning - BW Identification CGPL_BWIDENTIFIERNUMC8CGPL_BWIDENTIFIER
PLANGROUPINTPlanning Profile Group CGPL_SEM_PLGRPCHAR4
LATEST_STARTINTLatest start CGPL_LATEST_STARTDEC15TSTPSBCOS_TSTMP
LATEST_FINISHINTLatest finish date CGPL_LATEST_FINISHDEC15TSTPSBCOS_TSTMP
TOTAL_FLOATINTTotal Float CGPL_TOTAL_FLOATDEC8(2) CGPL_FLOAT
DURATIONINTDuration of Execution CGPL_DURATIONDEC8(2) CGPL_DURATION
DURATION_UNITINTTime Unit for Execution Duration CGPL_DURATION_UNITUNIT3Assigned to domainCUNITMEINS
CALENDAR_IDINTFactory Calendar WFCIDCHAR2Assigned to domainWFCIDFCI
CONSTR_TYPE_FININTType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTR_TIME_FININTConstraint Date CGPL_CONSTRAINT_TIMEDEC15TSTPSBCOS_TSTMP
APPLICATIONINTApplication in Project Planning CGPL_APPLICATION_TYPECHAR3Assigned to domainCGPL_APPLICATION_TYPE
FORECAST_STARTINTForecast Start CGPL_FORECAST_STARTDEC15TSTPSBCOS_TSTMP
FORECAST_FINISHINTForecast Finish CGPL_FORECAST_FINISHDEC15TSTPSBCOS_TSTMP
PROC_STATUS_OWNINTObject Processing Status DPR_TV_PROC_STATUS_OWNCHAR2DPR_PROC_STATUS
PROC_STATUS_SUPINTProcessing Status of Higher-Level Object DPR_TV_PROC_STATUS_SUPCHAR2DPR_PROC_STATUS
SORT_NUMBERINTSort Number DPR_TV_SORT_NUMBERNUMC5
VERSION_NUMBERINTVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
PARTICIPANT_ROLEINTRole Type for Projects DPR_TV_PARTICIPANT_ROLECHAR15DPR_PART_ROLEDPR_PARTICIPANT_ROLE
BEG_TMSTMPINTUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
END_TMSTMPINTUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
WORK_EFFORTINTDemand or Assigned Effort DPR_TV_EFFORTQUAN9(2) DPR_WORK
WORK_UNITINTUnit for Demand or Effort DPR_TV_EFFORT_UNITUNIT3Assigned to domainCUNITMEINS
C_OBJIDINTObject ID HROBJIDNUMC8Assigned to domainHROBJIDPON
PARTNER_ROLEINTBP Role DPR_TV_BU_ROLECHAR6Assigned to domainBU_RLTYPBUPA_ROLE
VACANTINTVacant Checkbox of Role DPR_TV_VACANTCHAR1DPR_BOOLEAN
CAND_IN_WORKLISTINTRole Is Displayed in Candidate Manager's Worklist DPR_TV_CANDIDATE_IN_WORKLISTCHAR1DPR_BOOLEAN
STAT_PROFILE_PRTINTStatus Profile Template DPR_TV_STAT_PROFILE_PRTCHAR8Assigned to domainJ_STSMA
VC_BUPA_GUIDINTApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
RATEINTCost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15Assigned to domainDPR_RATE_TYPE
REVENUE_RATEINTDifferent Revenue DPR_TV_REVENUE_RATE_MANUALCURR11(2) PREIS
CURRENCYINTCurrency Key WAERS_CURCCUKY5Assigned to domainWAERSFWS
COST_RATEINTDifferent Costs DPR_TV_COST_RATE_MANUALCURR11(2) PREIS
CURRENCY_COSTINTCurrency Key WAERS_CURCCUKY5Assigned to domainWAERSFWS
TIME_UNITINTActivity Unit for Deviating Costs and Revenues DPR_TV_TIME_UNIT_MANUALUNIT3Assigned to domainCUNITMEINS
ACT_WORK_EFFORTINTConfirmation (Insternal Display) DPR_TV_ACT_WORKQUAN16(3) DPR_WORK_LONG
ACT_WORK_UNITINTConfirmation Unit DPR_TV_ACT_WRK_UNITUNIT3Assigned to domainCUNITMEINS
ACT_WRK_UNIT_EXTINTConfirmation Unit DPR_TV_ACT_WRK_UNITUNIT3Assigned to domainCUNITMEINS
CONF_GUIDINTGUID of a Confirmation Document DPR_TV_CONF_GUIDRAW16
CONCRETE_ROLEINTShadow Role (= Concrete Role) DPR_TV_CONCRETE_ROLECHAR1CHAR1
PARTICIPANT_IDINTRole ID DPR_TV_PART_IDCHAR24CHAR24
URGENCYINTUrgency DPR_TV_URGENCYCHAR2DPR_URGENCY
ROLE_FUNCTION_IDINTID of Role Function DPR_TV_ROLE_FUNCTION_IDCHAR15DPR_ROLE_FUNCDPR_ROLE_FUNCTION_ID
LOCATIONINTLocation DPR_TV_LOCATIONCHAR4DPR_LOCATIONDPR_LOCATION
STAFF_PERCENTINTPercent Staffed DPR_TV_STAFF_PERCENTNUMC3NUMC3
EA_DUMMYINTDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
TEXTS 0
BUPA_LINKS 0
BUPA_FAVOS 0
SKILLS 0
ENTITY_LINKS 0
DOCUMENTS 0
PART_DIST 0
BUPA_DIST 0
OBJECT_LINKS 0

Key field Non-key field



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

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

How to access SAP table DPR_TS_PART_PRT

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!