SAP ABAP View BW_FI_TV_SHDR (View for Table PTRV_SHDR)
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_SHDR | |
Short Description | View for Table PTRV_SHDR | |
Root table | PTRV_SHDR | Trip Statistics - Trip Amounts |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PTRV_SHDR | PTRV_SHDR |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | PTRV_SHDR | MANDT | MANDT | Client | |||
2 | PERNR | PTRV_SHDR | PERNR | PERNR_D | Personnel Number | |||
3 | REINR | PTRV_SHDR | REINR | REINR | Trip Number | |||
4 | PERIO | PTRV_SHDR | PERIO | PTRV_PEROD | Trip Period Number | |||
5 | SEQNO | PTRV_SHDR | SEQNO | PTRV_SHDRSEQNO | Sequential number for trip totals | |||
6 | ADDIT_AMNT | PTRV_SHDR | ADDIT_AMNT | PTRV_ADDIT_AMNT | Additional Amount of a Trip (Taxable for Employee) | |||
7 | SUM_REIMBU | PTRV_SHDR | SUM_REIMBU | PTRV_SUM_REIMBU | Reimbursement Amount for a Trip | |||
8 | SUM_ADVANC | PTRV_SHDR | SUM_ADVANC | PTRV_SUM_ADVANC | Total Advances for a Trip | |||
9 | SUM_PAYOUT | PTRV_SHDR | SUM_PAYOUT | PTRV_SUM_PAYOUT | Payment Amount | |||
10 | SUM_PAIDCO | PTRV_SHDR | SUM_PAIDCO | PTRV_SUM_PAIDCO | Travel Expenses Paid by Company | |||
11 | TRIP_TOTAL | PTRV_SHDR | TRIP_TOTAL | PTRV_TRIP_TOTAL | Total Cost of Trip | |||
12 | PD_FOOD | PTRV_SHDR | PD_FOOD | PTRV_PD_FOOD | Reimbursement Amount (Total) for Meals per Diems | |||
13 | PD_HOUSING | PTRV_SHDR | PD_HOUSING | PTRV_PD_HOUSING | Reimbursement Amount (Total) for Accommodations per Diems | |||
14 | PD_MILEAGE | PTRV_SHDR | PD_MILEAGE | PTRV_PD_MILEAGE | Reimbursement Amount (Total) for Travel Flat Rates | |||
15 | SHDR_CURRENCY | PTRV_SHDR | CURRENCY | TRVWAERS | Currency Key | |||
16 | M_TOTAL | PTRV_SHDR | M_TOTAL | KMGES | Total Miles/Kilometers | |||
17 | TRIPDUR | PTRV_SHDR | TRIPDUR | PTRV_TRIPDUR | Trip Duration in Days | |||
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 | 20020108 |
SAP Release Created in |