SAP ABAP View CUSNOTER (Assignment of notes to customizing projects)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-CUS-TOL-IMG (Application Component) Implementation Guide
⤷ SCS4 (Package) R/3 Customizing Tools 4.0
⤷ BC-CUS-TOL-IMG (Application Component) Implementation Guide
⤷ SCS4 (Package) R/3 Customizing Tools 4.0
Basic Data
View Type | D | Database View |
Database View | CUSNOTER | |
Short Description | Assignment of notes to customizing projects | |
Root table | TNOTFPR | Notes: Project link |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TNOTFPR | TNOTFPR | ||
2 | TNODEIMGR | |||
3 | TPR_INDEX | |||
4 | TNOTEP | |||
5 | TNODEIMG |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | TPR_INDEX | NODE_ID | JL | EQ | 0 | 0 | ||||
2 | TNODEIMG | NODE_ID | JR | EQ | AND | 0 | 0 | |||
3 | TNODEIMG | REFNODE_ID | JL | EQ | 0 | 0 | ||||
4 | TNODEIMGR | NODE_ID | JR | EQ | AND | 0 | 0 | |||
5 | TNODEIMGR | REF_OBJECT | JL | EQ | 0 | 0 | ||||
6 | TNOTFPR | ID | JR | EQ | AND | 0 | 0 | |||
7 | TPR_INDEX | PROJECT_ID | JL | EQ | 0 | 0 | ||||
8 | TNOTEP | PROJECT_ID | JR | EQ | AND | 0 | 0 | |||
9 | TNOTEP | NOTETYPE | JL | EQ | 0 | 0 | ||||
10 | TNOTFPR | NOTETYPE | JR | EQ | AND | 0 | 0 | |||
11 | TNODEIMGR | 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 |