SAP ABAP Table DPR_TS_TASK_PRT_FLAT (Task Data (Flat List))
Hierarchy
☛
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
⤷ PPM-PRO-STR (Application Component) Structure
⤷ DEVELOPMENT_PROJECTS_TASK (Package) Project Management - Tasks
⤷ PPM-PRO-STR (Application Component) Structure
⤷ DEVELOPMENT_PROJECTS_TASK (Package) Project Management - Tasks
Basic Data
Table Category | INTTAB | Structure |
Structure | DPR_TS_TASK_PRT_FLAT | Table Relationship Diagram |
Short Description | Task Data (Flat List) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | LEVEL | CHAR | 3 | 0 | |||||
2 | IS_TEMPLATE | DPR_TV_IS_TEMPLATE | CHAR1 | CHAR | 1 | 0 | Template (Yes/No) | ||
3 | .INCLUDE | 0 | 0 | Task in External Display | |||||
4 | .INCLUDE | 0 | 0 | Modifiable Task Attributes | |||||
5 | EXTERNAL_ID | DPR_TV_TASK_ID | CHAR | 24 | 0 | Task Number | |||
6 | ACTUAL_START | DPR_TV_ACTUAL_START | DATS | 8 | 0 | Actual Start | |||
7 | ACTUAL_FINISH | DPR_TV_ACTUAL_FINISH | DATS | 8 | 0 | Actual Finish | |||
8 | COMPLETION | CGPL_COMPLETION | CGPL_COMPLETION | NUMC | 3 | 0 | Percentage of Completion | ||
9 | CONSTRAINT_TYPE | DPR_TV_START_CONSTRAINT | DPR_START_CONSTRAINT | CHAR | 1 | 0 | Constraint on Start Date | ||
10 | START_DATE_FIX | DPR_TV_START_DATE_FIX | DATS | 8 | 0 | Fixed Start Date | |||
11 | DURATION | DPR_TV_DURATION | QUAN | 4 | 0 | Processing Time | |||
12 | CALENDAR_ID | DPR_TV_CALENDAR_ID | WFCID | CHAR | 2 | 0 | Calendar | * | |
13 | CONSTR_TYPE_FIN | DPR_TV_FINISH_CONSTRAINT | DPR_FINISH_CONSTRAINT | CHAR | 1 | 0 | Constraint on Finish Date | ||
14 | FINISH_DATE_FIX | DPR_TV_FINISH_DATE_FIX | DATS | 8 | 0 | Fixed Predefined Finish Date | |||
15 | SORT_NUMBER | DPR_TV_SORT_NUMBER | NUMC | 5 | 0 | Sort Number | |||
16 | TSK_TYPE | DPR_TV_TSK_TYPE | DPR_TYPE | CHAR | 15 | 0 | Task Type | DPR_TSK_TYPE | |
17 | GROUPING | DPR_TV_GROUPING | CHAR | 40 | 0 | Grouping | |||
18 | SEARCH_FIELD | DPR_TV_SEARCH_FIELD | CHAR | 40 | 0 | Search Field | |||
19 | OBLIGATORY | DPR_TV_OBLIGATORY | DPR_BOOLEAN | CHAR | 1 | 0 | Mandatory | ||
20 | APP_RELEVANT | DPR_TV_APPROVAL_RELEVANT | DPR_BOOLEAN | CHAR | 1 | 0 | Relevant for Approval | ||
21 | PROCESS | DPR_TV_PROCESS | DPR_PROCESS | CHAR | 15 | 0 | Process | DPR_PROCESS | |
22 | WORK_EFFORT | DPR_TV_WORK | DPR_WORK | QUAN | 9 | 2 | Work | ||
23 | WORK_UNIT | DPR_TV_WORK_UNIT | MEINS | UNIT | 3 | 0 | Unit for Work | * | |
24 | DESCRIPTION | DPR_TV_NAME | TEXT40 | CHAR | 40 | 0 | Project Element Name | ||
25 | MILESTONE | DPR_TV_MILESTONE | DPR_BOOLEAN | CHAR | 1 | 0 | Milestone Indicator | ||
26 | STAT_PROFILE_TSK | DPR_TV_STAT_PROFILE_TSK | J_STSMA | CHAR | 8 | 0 | Status Profile Template | TJ21 | |
27 | ACT_WRK_EFFORT_EXT | DPR_TV_ACT_WORK_EXT | DPR_WORK | QUAN | 9 | 2 | Confirmation | ||
28 | ACT_WRK_UNIT_EXT | DPR_TV_ACT_WRK_UNIT | MEINS | UNIT | 3 | 0 | Confirmation Unit | * | |
29 | REM_WRK_EFFORT_EXT | DPR_TV_REM_WORK_EXT | DPR_WORK | QUAN | 9 | 2 | Remaining Work | ||
30 | REM_WRK_UNIT_EXT | DPR_TV_REM_WRK_UNIT | MEINS | UNIT | 3 | 0 | Unit for Remaining Work | * | |
31 | FLG_MAN_REM_WORK | DPR_TV_MAN_REM_WORK | DPR_BOOLEAN | CHAR | 1 | 0 | Enter Remaining Work Manually | ||
32 | RATE | DPR_TV_RATE | DPR_RATE_TYPE | CHAR | 15 | 0 | Cost Rate/Revenue Rate for Project Costing | * | |
33 | REVENUE_RATE | DPR_TV_REVENUE_RATE_MANUAL | PREIS | CURR | 11 | 2 | Different Revenue | ||
34 | CURRENCY | WAERS_CURC | WAERS | CUKY | 5 | 0 | Currency Key | * | |
35 | COST_RATE | DPR_TV_COST_RATE_MANUAL | PREIS | CURR | 11 | 2 | Different Costs | ||
36 | CURRENCY_COST | WAERS_CURC | WAERS | CUKY | 5 | 0 | Currency Key | * | |
37 | TIME_UNIT | DPR_TV_TIME_UNIT_MANUAL | MEINS | UNIT | 3 | 0 | Activity Unit for Deviating Costs and Revenues | * | |
38 | PRIORITY | CGPL_PRIORITY | NUMC3 | NUMC | 3 | 0 | Priority | CGPL_PRIO | |
39 | FORECASTED_START | DPR_TV_FORECASTED_START | DATS | 8 | 0 | Forecasted Start Date | |||
40 | FORECASTED_FINISH | DPR_TV_FORECASTED_FINISH | DATS | 8 | 0 | Forecasted Finish Date | |||
41 | EXTENDED_ATTRIBUTES | DPR_TS_TASK_EXTENDED_ATTR | STRU | 0 | 0 | ||||
42 | EA_DUMMY | DPR_TV_EA_DUMMY | CHAR1 | CHAR | 1 | 0 | Dummy Data Element for Enhanced Proj. Mgmt Attributes | ||
43 | .INCLUDE | 0 | 0 | ||||||
44 | .INCLUDE | 0 | 0 | ||||||
45 | .INCLUDE | 0 | 0 | Non-Modifiable Task Attributes | |||||
46 | GUID | DPR_TV_GUID | DPR_GUID | RAW | 16 | 0 | Application Object GUID | ||
47 | VERSION_NUMBER | CGPL_TV_VERSION | CGPL_VERSION | CHAR | 24 | 0 | Version Number | ||
48 | SCHEDULED_START | DPR_TV_SCHEDULED_START | DATS | 8 | 0 | Calculated Start Date | |||
49 | SCHEDULED_FINISH | DPR_TV_SCHEDULED_FINISH | DATS | 8 | 0 | Calculated Finish Date | |||
50 | CREATED_BY | DPR_TV_CREATED_BY | XUBNAME | CHAR | 12 | 0 | Created By | * | |
51 | CREATED_BY_NAME | DPR_TV_CREATED_BY_NAME | TEXT80 | CHAR | 80 | 0 | Name of Person Who Created the Project Element | ||
52 | CREATED_ON | DPR_TV_CREATED_ON_DATE | DATS | 8 | 0 | Created On | |||
53 | CHANGED_BY | DPR_TV_CHANGED_BY | XUBNAME | CHAR | 12 | 0 | Last Changed By | * | |
54 | CHANGED_BY_NAME | DPR_TV_CHANGED_BY_NAME | TEXT80 | CHAR | 80 | 0 | Name of Person Who Last Changed the Project Element | ||
55 | CHANGED_ON | DPR_TV_CHANGED_ON_DATE | DATS | 8 | 0 | Changed On | |||
56 | SCHEDULED_START_LATE | DPR_TV_SCHEDULED_START_LATE | DATS | 8 | 0 | Latest Start Date | |||
57 | SCHEDULED_FINISH_LATE | DPR_TV_SCHEDULED_FINISH_LATE | DATS | 8 | 0 | Latest Finish Date | |||
58 | TOTAL_FLOAT | DPR_TV_TOTAL_FLOAT | QUAN | 8 | 0 | Total Float | |||
59 | DURATION_UNIT | CGPL_DURATION_UNIT | MEINS | UNIT | 3 | 0 | Time Unit for Execution Duration | * | |
60 | GUID_CHAR | DPR_TV_OBJECT_GUID_CHAR | SYSUUID_C | CHAR | 32 | 0 | Unique Object Key | ||
61 | .INCLUDE | 0 | 0 | Development Projects: Status (External) | |||||
62 | OBJNR | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
63 | ISTAT | J_ISTAT | J_ISTAT | CHAR | 5 | 0 | System status | * | |
64 | ESTAT | J_ESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
65 | STSMA | J_STSMA | J_STSMA | CHAR | 8 | 0 | Status Profile | * | |
66 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
67 | TXT04 | J_TXT04 | TEXT4 | CHAR | 4 | 0 | Individual status of an object (short form) | ||
68 | TXT30 | J_TXT30 | TEXT30 | CHAR | 30 | 0 | Object status | ||
69 | STATTXT | DPR_TV_STATUS_TXT | STRG | 0 | 0 | Concatenated Status Text of an Object | |||
70 | TSK_TYPE_TEXT | DPR_TV_TSK_TYPE_TEXT | DPR_TEXT | CHAR | 40 | 0 | Text for Task Type | ||
71 | CALENDER_TEXT | SC_TXTFAC | TEXT40 | CHAR | 40 | 0 | Factory calendar name | ||
72 | PROCESS_TEXT | DPR_TV_PROCESS_TEXT | DPR_TEXT | CHAR | 40 | 0 | Process Description | ||
73 | WORK_UNIT_MSEHT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
74 | WORK_UNIT_MSEHL | DPR_TV_WORK_UNIT_MSEHL | TEXT30 | CHAR | 30 | 0 | Description of Unit of Measure for Work | ||
75 | ACT_WRK_UNIT_EXT_MSEHT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
76 | ACT_WRK_UNIT_EXT_MSEHL | DPR_TV_ACT_WRK_UNIT_MSEHL | TEXT30 | CHAR | 30 | 0 | Description of Unit of Measurement for Confirmation | ||
77 | REM_WRK_UNIT_EXT_MSEHT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
78 | REM_WRK_UNIT_EXT_MSEHL | DPR_TV_REM_WRK_UNIT_MSEHL | TEXT30 | CHAR | 30 | 0 | Description of Unit of Measurement for Remaining Work | ||
79 | THRESHOLD_TEXT | EVE_TV_THRESHOLD_DESCRIPTION | EVE_DESCRIPTION | CHAR | 40 | 0 | Threshold Value Description | ||
80 | SEVERITY_TEXT | EVE_TV_SEVERITY_DESCRIPTION | EVE_DESCRIPTION | CHAR | 40 | 0 | Severity of Threshold Value Description | ||
81 | MIRRORED_TASK | DPR_TV_MIRRORED_TASK | DPR_BOOLEAN | CHAR | 1 | 0 | Mirrored Task | ||
82 | DURATION_UNIT_TEXT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
83 | COST_RATE_DEF | DPR_TV_COST_VALUE | PREIS | CURR | 11 | 2 | Cost per Activity Unit | ||
84 | REVENUE_RATE_DEF | DPR_TV_REVENUE_VALUE | PREIS | CURR | 11 | 2 | Revenues per Activity Unit | ||
85 | SUMMARY_TASK | DPR_TV_SUMMARY_TASK | DPR_BOOLEAN | CHAR | 1 | 0 | Summary Task | ||
86 | TASK_ID | DPR_TV_TASK_ID | CHAR | 24 | 0 | Task Number | |||
87 | TIME_UNIT_TEXT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
88 | CURRENCY_TEXT | MSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
89 | LAST_CHANGED_TIMESTAMP | DPR_TV_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit) | ||
90 | .INCLUDE | 0 | 0 | Object header data | |||||
91 | SHOW_PROJECT | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
92 | SHOW_PHASE | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
93 | SHOW_TASK | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
94 | SHOW_CHECKLIST | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
95 | SHOW_CHECKLIST_ITEM | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
96 | SHOW_CHECKLIST_STATUS | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
97 | SHOW_PROJECT_STATUS | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
98 | SHOW_PHASE_STATUS | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
99 | SHOW_PHASE_DATES | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
100 | PROJECT_NAME | DPR_TV_NAME | TEXT40 | CHAR | 40 | 0 | Project Element Name | ||
101 | PROJECT_STATUS | J_TXT30 | TEXT30 | CHAR | 30 | 0 | Object status | ||
102 | PHASE_NAME | DPR_TV_NAME | TEXT40 | CHAR | 40 | 0 | Project Element Name | ||
103 | PHASE_START | DPR_TV_SCHEDULED_START | DATS | 8 | 0 | Calculated Start Date | |||
104 | PHASE_FINISH | DPR_TV_SCHEDULED_FINISH | DATS | 8 | 0 | Calculated Finish Date | |||
105 | PHASE_STATUS | J_TXT30 | TEXT30 | CHAR | 30 | 0 | Object status | ||
106 | CHECKLIST_NAME | DPR_TV_NAME | TEXT40 | CHAR | 40 | 0 | Project Element Name | ||
107 | CHECKLIST_STATUS | J_TXT30 | TEXT30 | CHAR | 30 | 0 | Object status | ||
108 | CHECKLIST_ITEM_NAME | DPR_TV_NAME | TEXT40 | CHAR | 40 | 0 | Project Element Name | ||
109 | TASK_NAME | DPR_TV_NAME | TEXT40 | CHAR | 40 | 0 | Project Element Name | ||
110 | PATH | DPR_TV_PATH_STRING | CHAR | 250 | 0 | Hierarchy Path | |||
111 | STATUS | DPR_TT_STATUS_EXT | TTYP | 0 | 0 | ||||
112 | TEXTS | DPR_TT_TEXT_EXT | TTYP | 0 | 0 | ||||
113 | DOCUMENTS | DPR_TT_DOCUMENT_PRT | TTYP | 0 | 0 | ||||
114 | OBJECT_LINKS | DPR_TT_OBJLINK_PRT | TTYP | 0 | 0 | ||||
115 | SKILLS | DPR_TT_SKILL_PRT | TTYP | 0 | 0 | ||||
116 | PARTICIPANT_LINKS | DPR_TT_ENTITY_LINK_PRT | TTYP | 0 | 0 | ||||
117 | COLLABORATIONS | DPR_TT_COLL_LINK_PRT | TTYP | 0 | 0 | ||||
118 | RESPONSIBLES | DPR_TT_RESPONSIBLE_DAT | TTYP | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DPR_TS_TASK_PRT_FLAT | PRIORITY | CGPL_PRIO | PRIORITY | KEY | 1 | CN |
2 | DPR_TS_TASK_PRT_FLAT | PROCESS | DPR_PROCESS | PROCESS | |||
3 | DPR_TS_TASK_PRT_FLAT | STAT_PROFILE_TSK | TJ21 | STSMA | REF | 1 | CN |
4 | DPR_TS_TASK_PRT_FLAT | TSK_TYPE | DPR_TSK_TYPE | TSK_TYPE | KEY |
History
Last changed by/on | SAP | 20141109 |
SAP Release Created in | 450 |