SAP DPR_TS_APPROVAL_PRT Approval Data Table data and field list

DPR_TS_APPROVAL_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 "Approval 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_APPROVAL_PRT TYPE DPR_TS_APPROVAL_PRT.

The DPR_TS_APPROVAL_PRT table consists of various fields, each holding specific information or linking keys about Approval Data data available in SAP. These include DESCRIPTION (Language-Dependent Description), EXTENDED_ATTRIBUTES (), EA_DUMMY (Dummy Data Element for Enhanced Proj. Mgmt Attributes), DOC_SIGN (Approval Document)... 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_APPROVAL_PRT 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_APPROVAL_PRT 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_APPROVAL_PRT 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
IS_TEMPLATETemplate (Yes/No) DPR_TV_IS_TEMPLATECHAR1CHAR1
DESCRIPTIONLanguage-Dependent Description CGPL_TEXT1CHAR40TEXT40
EXTENDED_ATTRIBUTES 0
EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
DOC_SIGNApproval Document DPR_TV_APPROVAL_DOCUMENTRSTR0DPR_APPROVAL_DOCUMENT
DOC_TYPE_SIGNDocument Category DPR_TV_APPROVAL_DOCUMENT_TYPECHAR3DPR_APPROVAL_DOCUMENT_TYPE
DOC_SIZE_SIGNDocument Size DPR_TV_APPROVAL_DOCUMENT_SIZEINT410
FNGR_PRNT_SIGNHash Value (160 Bits) HASH160XRAW20
GUIDApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
EXTERNAL_IDApproval Number DPR_TV_APPROVAL_IDCHAR24CGPL_EXTID
VERSION_NUMBERVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
CREATED_BYCreated By DPR_TV_CREATED_BYCHAR12Assigned to domainXUBNAME
CREATED_BY_NAMEName of Person Who Created the Project Element DPR_TV_CREATED_BY_NAMECHAR80TEXT80
CREATED_ONCreated On DPR_TV_CREATED_ON_DATEDATS8
CHANGED_BYLast Changed By DPR_TV_CHANGED_BYCHAR12Assigned to domainXUBNAME
CHANGED_BY_NAMEName of Person Who Last Changed the Project Element DPR_TV_CHANGED_BY_NAMECHAR80TEXT80
CHANGED_ONChanged On DPR_TV_CHANGED_ON_DATEDATS8
VERSIONApproval Version DPR_TV_APPROVAL_VERSIONCHAR10DPR_VERSION
ACTIVE_VERSIONActive Version of Approval DPR_TV_APPROVAL_ACTIVE_VERSIONCHAR1
DECISIONApproval/Individual Approval Decision DPR_TV_APPROVAL_DECISIONCHAR1DPR_APPROVAL_DECISION
DECISION_TEXTApproval/Individual Approval Decision DPR_TV_APPROVAL_DECISION_TEXTCHAR60DDTEXT
DECIDED_BYDecision Maker DPR_TV_DECIDED_BYCHAR12Assigned to domainXUBNAME
DECIDED_BY_NAMEName of Person Who Made the Approval Decision DPR_TV_DECIDED_BY_NAMECHAR80TEXT80
DECIDED_ON_DATEDate of Approval Decision DPR_TV_DECIDED_ON_DATEDATS8
DECIDED_AT_TIMETime of Approval Decision DPR_TV_DECIDED_AT_TIMETIMS6
SIGNATURE_TYPEType of Signature DPR_TV_SIGNATURE_TYPECHAR1DPR_SIGNATURE_TYPE
SIGNATURE_METHODSignature Method DPR_TV_SIGNATURE_METHODCHAR1DPR_SIGNATURE_METHOD
DOCUMENTApproval Document DPR_TV_APPROVAL_DOCUMENTRSTR0DPR_APPROVAL_DOCUMENT
DOCUMENT_TYPEDocument Category DPR_TV_APPROVAL_DOCUMENT_TYPECHAR3DPR_APPROVAL_DOCUMENT_TYPE
DOCUMENT_SIZEDocument Size DPR_TV_APPROVAL_DOCUMENT_SIZEINT410
FINGER_PRINTHash Value (160 Bits) HASH160XRAW20
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
GUID_CHARUnique Object Key DPR_TV_OBJECT_GUID_CHARCHAR32SYSUUID_C
.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
DOCUMENTINTApproval Document DPR_TV_APPROVAL_DOCUMENTRSTR0DPR_APPROVAL_DOCUMENT
DOCUMENT_TYPEINTDocument Category DPR_TV_APPROVAL_DOCUMENT_TYPECHAR3DPR_APPROVAL_DOCUMENT_TYPE
DOCUMENT_SIZEINTDocument Size DPR_TV_APPROVAL_DOCUMENT_SIZEINT410
FINGER_PRINTINTHash Value (160 Bits) HASH160XRAW20
DOC_SIGNINTApproval Document DPR_TV_APPROVAL_DOCUMENTRSTR0DPR_APPROVAL_DOCUMENT
DOC_TYPE_SIGNINTDocument Category DPR_TV_APPROVAL_DOCUMENT_TYPECHAR3DPR_APPROVAL_DOCUMENT_TYPE
DOC_SIZE_SIGNINTDocument Size DPR_TV_APPROVAL_DOCUMENT_SIZEINT410
FNGR_PRNT_SIGNINTHash Value (160 Bits) HASH160XRAW20
VERSION_NUMBERINTVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
DECISIONINTApproval/Individual Approval Decision DPR_TV_APPROVAL_DECISIONCHAR1DPR_APPROVAL_DECISION
DECIDED_BYINTDecision Maker DPR_TV_DECIDED_BYCHAR12Assigned to domainXUBNAME
DECIDED_ONINTUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) DPR_TV_TIMESTAMPDEC15TSTPSBCOS_TSTMP
ACTIVE_VERSIONINTActive Version of Approval DPR_TV_APPROVAL_ACTIVE_VERSIONCHAR1
VERSIONINTApproval Version DPR_TV_APPROVAL_VERSIONCHAR10DPR_VERSION
SIGNATURE_TYPEINTType of Signature DPR_TV_SIGNATURE_TYPECHAR1DPR_SIGNATURE_TYPE
SIGNATURE_METHODINTSignature Method DPR_TV_SIGNATURE_METHODCHAR1DPR_SIGNATURE_METHOD
EA_DUMMYINTDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
STATUS 0
TEXTS 0
INDIVIDUAL_APPROVALS 0
DOCUMENTS 0
.INCLU-PIN 0
PRIORITYPINPriority CGPL_PRIORITYNUMC3CGPL_PRIONUMC3
DURATIONPINProcessing Time DPR_TV_DURATIONQUAN4
CALENDAR_IDPINCalendar DPR_TV_CALENDAR_IDCHAR2Assigned to domainWFCID
PHASE_IDPINPhase Number DPR_TV_PHASE_IDCHAR24
PHA_TYPEPINPhase Type DPR_TV_PHA_TYPECHAR15DPR_PHA_TYPEDPR_TYPE
GROUPINGPINGrouping DPR_TV_GROUPINGCHAR40
SEARCH_FIELDPINSearch Field DPR_TV_SEARCH_FIELDCHAR40
DESCRIPTIONPINProject Element Name DPR_TV_NAMECHAR40TEXT40
CONSTRAINT_TYPEPINConstraint on Start Date DPR_TV_START_CONSTRAINTCHAR1DPR_START_CONSTRAINT
START_DATE_FIXPINFixed Start Date DPR_TV_START_DATE_FIXDATS8
CONSTR_TYPE_FINPINConstraint on Finish Date DPR_TV_FINISH_CONSTRAINTCHAR1DPR_FINISH_CONSTRAINT
FINISH_DATE_FIXPINFixed Predefined Finish Date DPR_TV_FINISH_DATE_FIXDATS8
STAT_PROFILE_PHAPINStatus Profile Template DPR_TV_STAT_PROFILE_PHACHAR8TJ21J_STSMA
PREDEC_PHASE_NUMBERPINUnique Object Key DPR_TV_OBJECT_GUID_CHARCHAR32SYSUUID_C
FORECASTED_STARTPINForecasted Start Date DPR_TV_FORECASTED_STARTDATS8
FORECASTED_FINISHPINForecasted Finish Date DPR_TV_FORECASTED_FINISHDATS8
EXTENDED_ATTRIBUTESPIN 0
EA_DUMMYPINDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
GUIDPINApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
VERSION_NUMBERPINVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
SCHEDULED_STARTPINCalculated Start Date DPR_TV_SCHEDULED_STARTDATS8
SCHEDULED_FINISHPINCalculated Finish Date DPR_TV_SCHEDULED_FINISHDATS8
CREATED_BYPINCreated By DPR_TV_CREATED_BYCHAR12Assigned to domainXUBNAME
CREATED_BY_NAMEPINName of Person Who Created the Project Element DPR_TV_CREATED_BY_NAMECHAR80TEXT80
CREATED_ONPINCreated On DPR_TV_CREATED_ON_DATEDATS8
CHANGED_BYPINLast Changed By DPR_TV_CHANGED_BYCHAR12Assigned to domainXUBNAME
CHANGED_BY_NAMEPINName of Person Who Last Changed the Project Element DPR_TV_CHANGED_BY_NAMECHAR80TEXT80
CHANGED_ONPINChanged On DPR_TV_CHANGED_ON_DATEDATS8
SCHEDULED_START_LATEPINLatest Start Date DPR_TV_SCHEDULED_START_LATEDATS8
SCHEDULED_FINISH_LATEPINLatest Finish Date DPR_TV_SCHEDULED_FINISH_LATEDATS8
TOTAL_FLOATPINTotal Float DPR_TV_TOTAL_FLOATQUAN8
DURATION_UNITPINTime Unit for Execution Duration CGPL_DURATION_UNITUNIT3T006CUNITMEINS
RESCHEDULEPINRescheduling Required DPR_TV_RESCHEDULECHAR1DPR_BOOLEAN
GUID_CHARPINUnique Object Key DPR_TV_OBJECT_GUID_CHARCHAR32SYSUUID_C
OBJNRPINGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
ISTATPINSystem status J_ISTATCHAR5Assigned to domainJ_ISTAT
ESTATPINUser Status J_ESTATCHAR5Assigned to domainJ_ESTAT
STSMAPINStatus Profile J_STSMACHAR8Assigned to domainJ_STSMA
SPRASPINLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
TXT04PINIndividual status of an object (short form) J_TXT04CHAR4TEXT4
TXT30PINObject status J_TXT30CHAR30TEXT30
STATTXTPINConcatenated Status Text of an Object DPR_TV_STATUS_TXTSTRG0
PHA_TYPE_TEXTPINPhase Type Text DPR_TV_PHA_TYPE_TEXTCHAR40DPR_TEXT
RELEASE_DATEPINRelease Date DPR_TV_RELEASE_DATEDATS8DATS
CALENDER_TEXTPINFactory calendar name SC_TXTFACCHAR40TEXT40
THRESHOLD_TEXTPINThreshold Value Description EVE_TV_THRESHOLD_DESCRIPTIONCHAR40EVE_DESCRIPTION
SEVERITY_TEXTPINSeverity of Threshold Value Description EVE_TV_SEVERITY_DESCRIPTIONCHAR40EVE_DESCRIPTION
DURATION_UNIT_TEXTPINUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
.INCLU-PEX 0
GUIDPEXApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
EXTERNAL_IDPEXProject Planning: External Indentifier of an Element CGPL_EXTIDCHAR24CGPL_EXTID
PROJECT_GUIDPEXProject Planning: 16 Character GUID for Projects CGPL_PROJECT_GUIDRAW16CGPLPCGPL_PROJECT_GUID
OBJECT_TYPEPEXObject Type in Project Planning CGPL_OBJECT_TYPECHAR3CHAR3
PRIORITYPEXPriority CGPL_PRIORITYNUMC3CGPL_PRIONUMC3
ACTUALSTARTPEXActual Start Date CGPL_ACTUALSTARTDEC15TSTPSBCOS_TSTMP
ACTUALFINISHPEXActual Finish Date CGPL_ACTUALFINISHDEC15TSTPSBCOS_TSTMP
PLANSTARTPEXPlanned start date CGPL_PLANSTARTDEC15TSTPSBCOS_TSTMP
PLANFINISHPEXPlanned Finish Date CGPL_PLANFINISHDEC15TSTPSBCOS_TSTMP
COMPLETIONPEXPercentage of Completion CGPL_COMPLETIONNUMC3CGPL_COMPLETION
MILESTONEPEXMilestone indicator CGPL_MILESTONECHAR1CHAR1
CONSTRAINT_TYPEPEXType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTRAINT_TIMEPEXConstraint Date CGPL_CONSTRAINT_TIMEDEC15TSTPSBCOS_TSTMP
CREATED_BYPEXName of Person Who Created Object CGPL_CREATED_BYCHAR12USNAM
CREATED_ONPEXDate When the Object Was Created CGPL_CREATED_ONDATS8DATUM
CREATED_IN_BWPEXTransfer Object to BW CGPL_CREATED_BWCHAR1CHAR1
CHANGED_BYPEXName of Person Who Changed Object CGPL_CHANGED_BYCHAR12USNAM
CHANGED_ONPEXDate on which object was last changed CGPL_CHANGED_ONDATS8DATUM
UPDATED_IN_BWPEXCurrent Object in BW CGPL_UPDATED_BWCHAR1CHAR1
BWIDENTIFIERPEXProject Planning - BW Identification CGPL_BWIDENTIFIERNUMC8CGPL_BWIDENTIFIER
PLANGROUPPEXPlanning Profile Group CGPL_SEM_PLGRPCHAR4
LATEST_STARTPEXLatest start CGPL_LATEST_STARTDEC15TSTPSBCOS_TSTMP
LATEST_FINISHPEXLatest finish date CGPL_LATEST_FINISHDEC15TSTPSBCOS_TSTMP
TOTAL_FLOATPEXTotal Float CGPL_TOTAL_FLOATDEC8(2) CGPL_FLOAT
DURATIONPEXDuration of Execution CGPL_DURATIONDEC8(2) CGPL_DURATION
DURATION_UNITPEXTime Unit for Execution Duration CGPL_DURATION_UNITUNIT3Assigned to domainCUNITMEINS
CALENDAR_IDPEXFactory Calendar WFCIDCHAR2Assigned to domainWFCIDFCI
CONSTR_TYPE_FINPEXType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTR_TIME_FINPEXConstraint Date CGPL_CONSTRAINT_TIMEDEC15TSTPSBCOS_TSTMP
APPLICATIONPEXApplication in Project Planning CGPL_APPLICATION_TYPECHAR3Assigned to domainCGPL_APPLICATION_TYPE
FORECAST_STARTPEXForecast Start CGPL_FORECAST_STARTDEC15TSTPSBCOS_TSTMP
FORECAST_FINISHPEXForecast Finish CGPL_FORECAST_FINISHDEC15TSTPSBCOS_TSTMP
PROC_STATUS_OWNPEXObject Processing Status DPR_TV_PROC_STATUS_OWNCHAR2DPR_PROC_STATUS
PROC_STATUS_SUPPEXProcessing Status of Higher-Level Object DPR_TV_PROC_STATUS_SUPCHAR2DPR_PROC_STATUS
PHASE_IDPEXPhase Number DPR_TV_PHASE_IDCHAR24
VERSION_NUMBERPEXVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
PHA_TYPEPEXPhase Type DPR_TV_PHA_TYPECHAR15DPR_PHA_TYPEDPR_TYPE
GROUPINGPEXGrouping DPR_TV_GROUPINGCHAR40
SEARCH_FIELDPEXSearch Field DPR_TV_SEARCH_FIELDCHAR40
RELEASED_ONPEXUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) DPR_TV_TIMESTAMPDEC15TSTPSBCOS_TSTMP
RESCHEDULEPEXRescheduling Required DPR_TV_RESCHEDULECHAR1DPR_BOOLEAN
STAT_PROFILE_PHAPEXStatus Profile Template DPR_TV_STAT_PROFILE_PHACHAR8Assigned to domainJ_STSMA
SCHEDULE_INDPEXStatus of Scheduling Data PPM_SCHEDULE_INDICATORCHAR1PPM_SCHEDULE_INDICATOR
SCHED_BEHAVIOURPEXScheduling Behavior DPR_TV_SCHED_BEHAVIOURCHAR1DPR_SCHEDULE_BEHAVIOUR
EA_DUMMYPEXDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
APP_RELEVANT_CHECKLIST_ITEMS 0
APP_RELEVANT_TASKS 0

Key field Non-key field



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

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

How to access SAP table DPR_TS_APPROVAL_PRT

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