SAP ABAP View BW_FI_TV_KEY_PL (View for Header, Period, and Planning Key Fields)
Hierarchy
☛
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
⤷ FI-TV (Application Component) Travel Management
⤷ FTBW (Package) Data Transfer FI-TV to BW
⤷ FI-TV (Application Component) Travel Management
⤷ FTBW (Package) Data Transfer FI-TV to BW
Basic Data
View Type | D | Database View |
Database View | BW_FI_TV_KEY_PL | |
Short Description | View for Header, Period, and Planning Key Fields | |
Root table | PTRV_HEAD | General Trip Data |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PTRV_HEAD | PTRV_HEAD | ||
2 | PTRV_PERIO | |||
3 | FTPT_PLAN |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | PTRV_PERIO | MANDT | JL | EQ | 0 | 0 | ||||
2 | PTRV_HEAD | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | PTRV_PERIO | PERNR | JL | EQ | 0 | 0 | ||||
4 | PTRV_HEAD | PERNR | JR | EQ | AND | 0 | 0 | |||
5 | PTRV_PERIO | HDVRS | JL | EQ | 0 | 0 | ||||
6 | PTRV_HEAD | HDVRS | JR | EQ | AND | 0 | 0 | |||
7 | PTRV_PERIO | REINR | JL | EQ | 0 | 0 | ||||
8 | PTRV_HEAD | REINR | JR | EQ | AND | 0 | 0 | |||
9 | FTPT_PLAN | MANDT | JL | EQ | 0 | 0 | ||||
10 | PTRV_HEAD | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | FTPT_PLAN | PERNR | JL | EQ | 0 | 0 | ||||
12 | PTRV_HEAD | PERNR | JR | EQ | AND | 0 | 0 | |||
13 | FTPT_PLAN | REINR | JL | EQ | 0 | 0 | ||||
14 | PTRV_HEAD | REINR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | PTRV_HEAD | MANDT | MANDT | Client | |||
2 | PERNR | PTRV_HEAD | PERNR | PERNR_D | Personnel Number | |||
3 | REINR | PTRV_HEAD | REINR | REINR | Trip Number | |||
4 | HDVRS | PTRV_HEAD | HDVRS | PTRV_HDVRS | Sequential Number of Travel Expenses Table THEADER | |||
5 | PERIO | PTRV_PERIO | PERIO | PTRV_PEROD | Trip Period Number | |||
6 | PDVRS | PTRV_PERIO | PDVRS | PTRV_PDVRS | Sequential Number of Period | |||
7 | PLANNR | FTPT_PLAN | PLANNR | PLAN_NR | Travel Plan Number (Sequential Number) | |||
8 | PLAN_STATUS | FTPT_PLAN | STATUS | PLAN_STATUS | Travel Plan Status | |||
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 | 20130529 |
SAP Release Created in |