SAP ABAP View D_RPM_ARCH_ITM_S (Item join with its status, and status group)
Hierarchy
☛
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
⤷
PPM-PFM (Application Component) Portfolio Management
⤷
RPM_DATAARCHIVING (Package) RPM Data Archiving
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0⤷
PPM-PFM (Application Component) Portfolio Management⤷
RPM_DATAARCHIVING (Package) RPM Data Archiving
Basic Data
| View Type | D | Database View |
| Database View | D_RPM_ARCH_ITM_S | |
| Short Description | Item join with its status, and status group | |
| Root table | /RPM/ITEM_D | Operational item persisted data |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /RPM/ITEM_D |
/RPM/ITEM_D | ||
| 2 | /RPM/PORTFOLIO_D |
|||
| 3 | /RPM/BUCKET_D |
|||
| 4 | /RPM/ITEM_STATUS |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /RPM/ITEM_D |
CLIENT | JL | EQ | 0 | 0 | ||||
| 2 | /RPM/PORTFOLIO_D |
CLIENT | JR | EQ | AND | 0 | 0 | |||
| 3 | /RPM/ITEM_D |
PORTFOLIO_GUID | JL | EQ | 0 | 0 | ||||
| 4 | /RPM/PORTFOLIO_D |
GUID | JR | EQ | AND | 0 | 0 | |||
| 5 | /RPM/ITEM_D |
CLIENT | JL | EQ | 0 | 0 | ||||
| 6 | /RPM/BUCKET_D |
CLIENT | JR | EQ | AND | 0 | 0 | |||
| 7 | /RPM/ITEM_D |
PARENT_GUID | JL | EQ | 0 | 0 | ||||
| 8 | /RPM/BUCKET_D |
GUID | JR | EQ | AND | 0 | 0 | |||
| 9 | /RPM/ITEM_D |
CLIENT | JL | EQ | 0 | 0 | ||||
| 10 | /RPM/ITEM_STATUS |
CLIENT | JR | EQ | AND | 0 | 0 | |||
| 11 | /RPM/ITEM_D |
ITEM_TYPE | JL | EQ | 0 | 0 | ||||
| 12 | /RPM/ITEM_STATUS |
ITEM_TYPE | JR | EQ | AND | 0 | 0 | |||
| 13 | /RPM/ITEM_D |
STATUS | JL | EQ | 0 | 0 | ||||
| 14 | /RPM/ITEM_STATUS |
STATUS | JR | EQ | AND | 0 | 0 | |||
| 15 | /RPM/ITEM_D |
VERSION_ITEM | EQ | ' ' | AND | 0 | 0 | |||
| 16 | /RPM/ITEM_D |
ITEM_CLASS | EQ | ' ' | OR | 0 | 0 | |||
| 17 | /RPM/ITEM_D |
ITEM_CLASS | EQ | '2' | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  CLIENT |
/RPM/ITEM_D |
CLIENT | MANDT | Client | |||
| 2 | ITEM_ID |
/RPM/ITEM_D |
EXTERNAL_ID | /RPM/TV_EXTID | Business Object ID | |||
| 3 | ITEM_D_GUID |
/RPM/ITEM_D |
GUID | /RPM/TV_GUID | Guid for application objects | |||
| 4 | ITEM_H_GUID |
/RPM/ITEM_D |
PORTFL_ITEM_GUID | RPM_TV_GUID | Guid for application objects | |||
| 5 | PORTFOLIO_ID |
/RPM/PORTFOLIO_D |
EXTERNAL_ID | /RPM/TV_EXTID | Business Object ID | |||
| 6 | BUCKET_ID |
/RPM/BUCKET_D |
EXTERNAL_ID | /RPM/TV_EXTID | Business Object ID | |||
| 7 | ITEM_TYPE |
/RPM/ITEM_D |
ITEM_TYPE | /RPM/TV_ITEM_ID | Type | |||
| 8 | STATUS |
/RPM/ITEM_D |
STATUS | /RPM/TV_STATUS_COMMON | Status | |||
| 9 | STATUS_GROUP |
/RPM/ITEM_STATUS |
STATUS_GROUP | /RPM/TV_ITEM_STATUS_GROUP | Status Group | |||
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 | 600_740 |
