DPR_TS_TASK_DAT_FLAT SAP (Task Data (Flat List)) Structure details

Dictionary Type: Structure
Description: Task Data (Flat List)




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




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

DPR_TS_TASK_DAT_FLAT 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 "Task Data (Flat List)" 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_TASK_DAT_FLAT TYPE DPR_TS_TASK_DAT_FLAT.

The DPR_TS_TASK_DAT_FLAT table consists of various fields, each holding specific information or linking keys about Task Data (Flat List) data available in SAP. These include IS_TEMPLATE (Template (Yes/No)), EXTERNAL_ID (Task Number), ACTUAL_START (Actual Start), ACTUAL_FINISH (Actual Finish).. 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_TASK_DAT_FLAT 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
LEVEL Task Level in the Hierarchy0
IS_TEMPLATETemplate (Yes/No) DPR_TV_IS_TEMPLATECHAR1CHAR1
EXTERNAL_IDTask Number DPR_TV_TASK_IDCHAR24
ACTUAL_STARTActual Start DPR_TV_ACTUAL_STARTDATS8
ACTUAL_FINISHActual Finish DPR_TV_ACTUAL_FINISHDATS8
COMPLETIONPercentage of Completion CGPL_COMPLETIONNUMC3CGPL_COMPLETION
CONSTRAINT_TYPEConstraint on Start Date DPR_TV_START_CONSTRAINTCHAR1DPR_START_CONSTRAINT
START_DATE_FIXFixed Start Date DPR_TV_START_DATE_FIXDATS8
DURATIONProcessing Time DPR_TV_DURATIONQUAN4
CALENDAR_IDCalendar DPR_TV_CALENDAR_IDCHAR2Assigned to domainWFCID
CONSTR_TYPE_FINConstraint on Finish Date DPR_TV_FINISH_CONSTRAINTCHAR1DPR_FINISH_CONSTRAINT
FINISH_DATE_FIXFixed Predefined Finish Date DPR_TV_FINISH_DATE_FIXDATS8
SORT_NUMBERSort Number DPR_TV_SORT_NUMBERNUMC5
TSK_TYPETask Type DPR_TV_TSK_TYPECHAR15DPR_TSK_TYPEDPR_TYPE
GROUPINGGrouping DPR_TV_GROUPINGCHAR40
SEARCH_FIELDSearch Field DPR_TV_SEARCH_FIELDCHAR40
OBLIGATORYMandatory DPR_TV_OBLIGATORYCHAR1DPR_BOOLEAN
APP_RELEVANTRelevant for Approval DPR_TV_APPROVAL_RELEVANTCHAR1DPR_BOOLEAN
PROCESSProcess DPR_TV_PROCESSCHAR15DPR_PROCESSDPR_PROCESS
WORK_EFFORTWork DPR_TV_WORKQUAN9(2) DPR_WORK
WORK_UNITUnit for Work DPR_TV_WORK_UNITUNIT3Assigned to domainCUNITMEINS
DESCRIPTIONProject Element Name DPR_TV_NAMECHAR40TEXT40
MILESTONEMilestone Indicator DPR_TV_MILESTONECHAR1DPR_BOOLEAN
STAT_PROFILE_TSKStatus Profile Template DPR_TV_STAT_PROFILE_TSKCHAR8TJ21J_STSMA
ACT_WRK_EFFORT_EXTConfirmation DPR_TV_ACT_WORK_EXTQUAN9(2) DPR_WORK
ACT_WRK_UNIT_EXTConfirmation Unit DPR_TV_ACT_WRK_UNITUNIT3Assigned to domainCUNITMEINS
REM_WRK_EFFORT_EXTRemaining Work DPR_TV_REM_WORK_EXTQUAN9(2) DPR_WORK
REM_WRK_UNIT_EXTUnit for Remaining Work DPR_TV_REM_WRK_UNITUNIT3Assigned to domainCUNITMEINS
FLG_MAN_REM_WORKEnter Remaining Work Manually DPR_TV_MAN_REM_WORKCHAR1DPR_BOOLEAN
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
PRIORITYPriority CGPL_PRIORITYNUMC3CGPL_PRIONUMC3
FORECASTED_STARTForecasted Start Date DPR_TV_FORECASTED_STARTDATS8
FORECASTED_FINISHForecasted Finish Date DPR_TV_FORECASTED_FINISHDATS8
EXTENDED_ATTRIBUTES 0
EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
.INCLU--AP 0
/XPPM/MAN_WEIGHT/XPPM/MAN_WEIGHT /XPPM/MAN_WEIGHTNUMC3
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
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
SCHEDULED_START_LATELatest Start Date DPR_TV_SCHEDULED_START_LATEDATS8
SCHEDULED_FINISH_LATELatest Finish Date DPR_TV_SCHEDULED_FINISH_LATEDATS8
TOTAL_FLOATTotal Float DPR_TV_TOTAL_FLOATQUAN8
DURATION_UNITTime Unit for Execution Duration CGPL_DURATION_UNITUNIT3Assigned to domainCUNITMEINS
GUID_CHARUnique Object Key DPR_TV_OBJECT_GUID_CHARCHAR32SYSUUID_C
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
TSK_TYPE_TEXTText for Task Type DPR_TV_TSK_TYPE_TEXTCHAR40DPR_TEXT
CALENDER_TEXTFactory calendar name SC_TXTFACCHAR40TEXT40
PROCESS_TEXTProcess Description DPR_TV_PROCESS_TEXTCHAR40DPR_TEXT
WORK_UNIT_MSEHTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
WORK_UNIT_MSEHLDescription of Unit of Measure for Work DPR_TV_WORK_UNIT_MSEHLCHAR30TEXT30
ACT_WRK_UNIT_EXT_MSEHTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
ACT_WRK_UNIT_EXT_MSEHLDescription of Unit of Measurement for Confirmation DPR_TV_ACT_WRK_UNIT_MSEHLCHAR30TEXT30
REM_WRK_UNIT_EXT_MSEHTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
REM_WRK_UNIT_EXT_MSEHLDescription of Unit of Measurement for Remaining Work DPR_TV_REM_WRK_UNIT_MSEHLCHAR30TEXT30
THRESHOLD_TEXTThreshold Value Description EVE_TV_THRESHOLD_DESCRIPTIONCHAR40EVE_DESCRIPTION
SEVERITY_TEXTSeverity of Threshold Value Description EVE_TV_SEVERITY_DESCRIPTIONCHAR40EVE_DESCRIPTION
MIRRORED_TASKMirrored Task DPR_TV_MIRRORED_TASKCHAR1DPR_BOOLEAN
DURATION_UNIT_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
COST_RATE_DEFCost per Activity Unit DPR_TV_COST_VALUECURR11(2) PREIS
REVENUE_RATE_DEFRevenues per Activity Unit DPR_TV_REVENUE_VALUECURR11(2) PREIS
SUMMARY_TASKSummary Task DPR_TV_SUMMARY_TASKCHAR1DPR_BOOLEAN
TASK_IDTask Number DPR_TV_TASK_IDCHAR24
TIME_UNIT_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
CURRENCY_TEXTUnit of Measurement Text (Maximum 10 Characters) MSEHTCHAR10TEXT10
.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
TASK_IDINTTask Number DPR_TV_TASK_IDCHAR24
SORT_NUMBERINTSort Number DPR_TV_SORT_NUMBERNUMC5
VERSION_NUMBERINTVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
TSK_TYPEINTTask Type DPR_TV_TSK_TYPECHAR15DPR_TSK_TYPEDPR_TYPE
GROUPINGINTGrouping DPR_TV_GROUPINGCHAR40
SEARCH_FIELDINTSearch Field DPR_TV_SEARCH_FIELDCHAR40
OBLIGATORYINTMandatory DPR_TV_OBLIGATORYCHAR1DPR_BOOLEAN
APP_RELEVANTINTRelevant for Approval DPR_TV_APPROVAL_RELEVANTCHAR1DPR_BOOLEAN
PROCESSINTProcess DPR_TV_PROCESSCHAR15DPR_PROCESSDPR_PROCESS
WORK_EFFORTINTWork DPR_TV_WORKQUAN9(2) DPR_WORK
WORK_UNITINTUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
STAT_PROFILE_TSKINTStatus Profile Template DPR_TV_STAT_PROFILE_TSKCHAR8Assigned to domainJ_STSMA
ACT_WORK_EFFORTINTConfirmation (Insternal Display) DPR_TV_ACT_WORKQUAN16(3) DPR_WORK_LONG
ACT_WORK_UNITINTUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
ACT_WRK_UNIT_EXTINTUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
REM_WORK_EFFORTINTRemaining Work DPR_TV_REM_WORKQUAN16(3) DPR_WORK_LONG
REM_WORK_UNITINTUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
REM_WRK_UNIT_EXTINTUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
FLG_MAN_REM_WORKINTEnter Remaining Work Manually DPR_TV_MAN_REM_WORKCHAR1DPR_BOOLEAN
CONF_GUIDINTGUID of a Confirmation Document DPR_TV_CONF_GUIDRAW16
MIRRORED_TASKINTMirrored Task DPR_TV_MIRRORED_TASKCHAR1DPR_BOOLEAN
SCHEDULE_INDINTStatus of Scheduling Data PPM_SCHEDULE_INDICATORCHAR1PPM_SCHEDULE_INDICATOR
SCHED_BEHAVIOURINTScheduling Behavior DPR_TV_SCHED_BEHAVIOURCHAR1DPR_SCHEDULE_BEHAVIOUR
SUMMARY_TASKINTSummary Task DPR_TV_SUMMARY_TASKCHAR1DPR_BOOLEAN
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
CANC_REM_WORKINTRemaining Work Before Task Is Canceled DPR_TV_CANC_REM_WORKQUAN16(3) DPR_WORK_LONG
EA_DUMMYINTDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
.INCLU--AP 0
/XPPM/MAN_WEIGHTINT/XPPM/MAN_WEIGHT /XPPM/MAN_WEIGHTNUMC3
STATUS 0
TEXTS 0
DOCUMENTS 0
OBJECT_LINKS 0
SKILLS 0
PARTICIPANT_LINKS 0
COLLABORATIONS 0

Key field Non-key field



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

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

How to access SAP table DPR_TS_TASK_DAT_FLAT

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