SAP ABAP View V_DPR_TASK (View for CGPL_TASK and DPR_TASK)
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
View Type | D | Database View |
Database View | V_DPR_TASK | |
Short Description | View for CGPL_TASK and DPR_TASK | |
Root table | CGPL_TASK | Project Planning: Attribute Table for Activities |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | CGPL_TASK | CGPL_TASK | ||
2 | DPR_TASK | |||
3 | CGPL_ENTITY |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | CGPL_TASK | CLIENT | JL | EQ | 0 | 0 | ||||
2 | DPR_TASK | CLIENT | JR | EQ | AND | 0 | 0 | |||
3 | CGPL_TASK | GUID | JL | EQ | 0 | 0 | ||||
4 | DPR_TASK | GUID | JR | EQ | AND | 0 | 0 | |||
5 | CGPL_ENTITY | CLIENT | JL | EQ | 0 | 0 | ||||
6 | CGPL_TASK | CLIENT | JR | EQ | AND | 0 | 0 | |||
7 | CGPL_ENTITY | GUID | JL | EQ | 0 | 0 | ||||
8 | CGPL_TASK | GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | CLIENT | CGPL_TASK | CLIENT | MANDT | Client | |||
2 | GUID | CGPL_TASK | GUID | CGPL_TASK_GUID | Project Planning: 16 Character GUID for Tasks | |||
3 | PRIORITY | CGPL_TASK | PRIORITY | CGPL_PRIORITY | Priority | |||
4 | OBJECT_TYPE | CGPL_TASK | OBJECT_TYPE | CGPL_OBJECT_TYPE | Object Type in Project Planning | |||
5 | INTERNAL | CGPL_ENTITY | INTERNAL | BOOLE_D | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | |||
6 | * | DPR_TASK | * | |||||
7 | - | DPR_TASK | CLIENT | MANDT | Client | |||
8 | - | DPR_TASK | GUID | DPR_TV_ENTITY_GUID | Application Object GUID (Entity with Conversion Exit) | |||
9 | PROC_STATUS_OWN | DPR_TASK | PROC_STATUS_OWN | DPR_TV_PROC_STATUS_OWN | Object Processing Status | |||
10 | PROC_STATUS_SUP | DPR_TASK | PROC_STATUS_SUP | DPR_TV_PROC_STATUS_SUP | Processing Status of Higher-Level Object | |||
11 | TASK_ID | DPR_TASK | TASK_ID | DPR_TV_TASK_ID | Task Number | |||
12 | - | DPR_TASK | VERSION_NUMBER | CGPL_TV_VERSION | Version Number | |||
13 | TSK_TYPE | DPR_TASK | TSK_TYPE | DPR_TV_TSK_TYPE | Task Type | |||
14 | GROUPING | DPR_TASK | GROUPING | DPR_TV_GROUPING | Grouping | |||
15 | SEARCH_FIELD | DPR_TASK | SEARCH_FIELD | DPR_TV_SEARCH_FIELD | Search Field | |||
16 | OBLIGATORY | DPR_TASK | OBLIGATORY | DPR_TV_OBLIGATORY | Mandatory | |||
17 | APP_RELEVANT | DPR_TASK | APP_RELEVANT | DPR_TV_APPROVAL_RELEVANT | Relevant for Approval | |||
18 | PROCESS | DPR_TASK | PROCESS | DPR_TV_PROCESS | Process | |||
19 | - | DPR_TASK | WORK_EFFORT | DPR_TV_WORK | Work | |||
20 | - | DPR_TASK | WORK_UNIT | DPR_TV_UNIT | Unit | |||
21 | - | DPR_TASK | STAT_PROFILE_TSK | DPR_TV_STAT_PROFILE_TSK | Status Profile Template | |||
22 | - | DPR_TASK | ACT_WORK_EFFORT | DPR_TV_ACT_WORK | Confirmation (Insternal Display) | |||
23 | - | DPR_TASK | ACT_WORK_UNIT | DPR_TV_UNIT | Unit | |||
24 | - | DPR_TASK | ACT_WRK_UNIT_EXT | DPR_TV_UNIT | Unit | |||
25 | REM_WORK_EFFORT | DPR_TASK | REM_WORK_EFFORT | DPR_TV_REM_WORK | Remaining Work | |||
26 | REM_WORK_UNIT | DPR_TASK | REM_WORK_UNIT | DPR_TV_UNIT | Unit | |||
27 | REM_WRK_UNIT_EXT | DPR_TASK | REM_WRK_UNIT_EXT | DPR_TV_UNIT | Unit | |||
28 | FLG_MAN_REM_WORK | DPR_TASK | FLG_MAN_REM_WORK | DPR_TV_MAN_REM_WORK | Enter Remaining Work Manually | |||
29 | - | DPR_TASK | CONF_GUID | DPR_TV_CONF_GUID | GUID of a Confirmation Document | |||
30 | MIRRORED_TASK | DPR_TASK | MIRRORED_TASK | DPR_TV_MIRRORED_TASK | Mirrored Task | |||
31 | SCHEDULE_IND | DPR_TASK | SCHEDULE_IND | PPM_SCHEDULE_INDICATOR | Status of Scheduling Data | |||
32 | SCHED_BEHAVIOUR | DPR_TASK | SCHED_BEHAVIOUR | DPR_TV_SCHED_BEHAVIOUR | Scheduling Behavior | |||
33 | SUMMARY_TASK | DPR_TASK | SUMMARY_TASK | DPR_TV_SUMMARY_TASK | Summary Task | |||
34 | RATE | DPR_TASK | RATE | DPR_TV_RATE | Cost Rate/Revenue Rate for Project Costing | |||
35 | REVENUE_RATE | DPR_TASK | REVENUE_RATE | DPR_TV_REVENUE_RATE_MANUAL | Different Revenue | |||
36 | CURRENCY | DPR_TASK | CURRENCY | WAERS_CURC | Currency Key | |||
37 | COST_RATE | DPR_TASK | COST_RATE | DPR_TV_COST_RATE_MANUAL | Different Costs | |||
38 | CURRENCY_COST | DPR_TASK | CURRENCY_COST | WAERS_CURC | Currency Key | |||
39 | TIME_UNIT | DPR_TASK | TIME_UNIT | DPR_TV_TIME_UNIT_MANUAL | Activity Unit for Deviating Costs and Revenues | |||
40 | CANC_REM_WORK | DPR_TASK | CANC_REM_WORK | DPR_TV_CANC_REM_WORK | Remaining Work Before Task Is Canceled | |||
41 | - | DPR_TASK | EA_DUMMY | DPR_TV_EA_DUMMY | Dummy Data Element for Enhanced Proj. Mgmt Attributes | |||
42 | VERSION | DPR_TASK | VERSION_NUMBER | CGPL_TV_VERSION | Version Number | |||
43 | EXTERNAL_ID | DPR_TASK | SORT_NUMBER | DPR_TV_SORT_NUMBER | Sort Number | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20141109 |
SAP Release Created in | 100 |