SAP ABAP View PROJNOTE (Assignment of notes to projects)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-CUS-TOL-IMG (Application Component) Implementation Guide
⤷ SPROJECT (Package) General project management
⤷ BC-CUS-TOL-IMG (Application Component) Implementation Guide
⤷ SPROJECT (Package) General project management
Basic Data
View Type | D | Database View |
Database View | PROJNOTE | |
Short Description | Assignment of notes to projects | |
Root table | TNOTFPR | Notes: Project link |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TNOTFPR | TNOTFPR | ||
2 | TNODEPRR | |||
3 | TPR_INDEX | |||
4 | TNOTEP |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | TNODEPRR | REF_OBJECT | JL | EQ | 0 | 0 | ||||
2 | TNOTFPR | ID | JR | EQ | AND | 0 | 0 | |||
3 | TPR_INDEX | PROJECT_ID | JL | EQ | 0 | 0 | ||||
4 | TNOTEP | PROJECT_ID | JR | EQ | AND | 0 | 0 | |||
5 | TNOTEP | NOTETYPE | JL | EQ | 0 | 0 | ||||
6 | TNOTFPR | NOTETYPE | JR | EQ | AND | 0 | 0 | |||
7 | TPR_INDEX | NODE_ID | JL | EQ | 0 | 0 | ||||
8 | TNODEPRR | NODE_ID | JR | EQ | AND | 0 | 0 | |||
9 | TNODEPRR | REF_TYPE | EQ | 'NOTE' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | PROJECT_ID | TPR_INDEX | PROJECT_ID | PROJECT_ID | Project name | |||
2 | NODE_ID | TPR_INDEX | NODE_ID | HIER_GUID | Unique ID - 32 characters | |||
3 | NOTETYPE | TNOTEP | NOTETYPE | PROJ_NTYPE | Valid Document Types | |||
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 | 20130604 |
SAP Release Created in |