SAP ABAP Table BIW_FI_TV_02 (Extract Structure for Infosource 0FI_TV_02)
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
![](/abap/icon/s_instal.gif)
⤷
![](/abap/icon/s_b_tree.gif)
⤷
![](/abap/icon/s_pckstd.gif)
Basic Data
Table Category | INTTAB | Structure |
Structure | BIW_FI_TV_02 |
![]() |
Short Description | Extract Structure for Infosource 0FI_TV_02 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
![]() |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
2 | ![]() |
REINR | REINR | NUMC | 10 | 0 | Trip Number | ||
3 | ![]() |
PTRV_BW_ENTRY_TYPE | PTRV_BW_ENTRY_TYPE | CHAR | 1 | 0 | Type of Trip Data | ||
4 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
5 | ![]() |
0 | 0 | Structure for General Trip Data for BW | |||||
6 | ![]() |
MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
7 | ![]() |
MOREI | MOREI | CHAR | 2 | 0 | Trip Provision Variant | * | |
8 | ![]() |
RSCHE | RSCHE | CHAR | 2 | 0 | Trip schema | * | |
9 | ![]() |
KZREA | KZREA | CHAR | 1 | 0 | Trip Type: Statutory | * | |
10 | ![]() |
BEREI | BEREI | CHAR | 1 | 0 | Trip Type: Enterprise-Specific | * | |
11 | ![]() |
KZTKT | KZTKT | CHAR | 1 | 0 | Trip Activity Type | * | |
12 | ![]() |
LNDGR | LNDGR | CHAR | 3 | 0 | Trip Country / Trip Country Group | * | |
13 | ![]() |
HRGIO | RGION | CHAR | 5 | 0 | Region of Main Destination | * | |
14 | ![]() |
REBED | REDAT | DATS | 8 | 0 | Beginning Date of Trip Segment | ||
15 | ![]() |
REBEU | REUHR | TIMS | 6 | 0 | Beginning Time of Trip Segment | ||
16 | ![]() |
REEND | REDAT | DATS | 8 | 0 | End Date of Trip Segment | ||
17 | ![]() |
REENU | REUHR | TIMS | 6 | 0 | End Time of Trip Segment | ||
18 | ![]() |
0 | 0 | Structure for Travel Plan | |||||
19 | ![]() |
PLAN_STATUS | FTPD_PSTAT | CHAR | 1 | 0 | Travel Plan Status | ||
20 | ![]() |
PLAN_ACTIVITY | FTPD_PLAN_ACTIVITY | CHAR | 1 | 0 | Trip Activity Type | * | |
21 | ![]() |
PNR_RECORD_LOCATOR | FTPD_PNR_RECORD_LOCATOR | CHAR | 20 | 0 | Passenger Name Record Locator | ||
22 | ![]() |
0 | 0 | Structure for Request Items | |||||
23 | ![]() |
EMPLOYEE_GROUP_TP | FTPD_EMPLOYEE_GROUP | CHAR | 2 | 0 | User Grouping for Travel Planning | * | |
24 | ![]() |
ITEMPOS_USER_CAT | FTPD_USER_CAT | CHAR | 1 | 0 | Enterprise-Specific Travel Service Category | * | |
25 | ![]() |
NRBEL | NRBEL | CHAR | 3 | 0 | Document Number | ||
26 | ![]() |
CATEGORY | FTPD_ITEM_CATEGORY | CHAR | 1 | 0 | Travel service category | ||
27 | ![]() |
0 | 0 | Structure for Hotel Bookings | |||||
28 | ![]() |
HOTEL_PROVIDER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Hotel Chain | * | |
29 | ![]() |
HOTEL_PROPERTY | FTPD_HOTEL_PROP | CHAR | 6 | 0 | Hotel Code (Key for an Individual Hotel) | ||
30 | ![]() |
HOTEL_DATE_ARR | FTPD_DATE | DATS | 8 | 0 | Arrival Date Hotel | ||
31 | ![]() |
HOTEL_DATE_DEP | FTPD_DATE | DATS | 8 | 0 | Departure Date Hotel | ||
32 | ![]() |
HOTEL_SLOCATION | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Hotel Location | * | |
33 | ![]() |
HOTEL_NAME | TEXT40 | CHAR | 40 | 0 | Name of Hotel | ||
34 | ![]() |
HOTEL_ROOMTYPE | FTPD_HOTEL_ROOMTYPE | CHAR | 1 | 0 | Hotel Room Type | ||
35 | ![]() |
HOTEL_MEALS | FTPD_HOTEL_MEALS | CHAR | 1 | 0 | Hotel Meals | ||
36 | ![]() |
HOTEL_RATE | FTPD_PRICE | CURR | 10 | 2 | Rate/Price Per Night | ||
37 | ![]() |
HOTEL_PRICE | FTPD_PRICE | CURR | 10 | 2 | Total Price for Hotel Stay | ||
38 | ![]() |
HOTEL_STATUS | FTPD_SERVICE_STATUS | CHAR | 2 | 0 | Hotel Status | ||
39 | ![]() |
HOTEL_RATE_PLAN_CODE | FTPD_HOTEL_RATE_CODE | CHAR | 3 | 0 | Hotel Rate Category | * | |
40 | ![]() |
HOTEL_ROOM_RATE_CODE | CHAR3 | CHAR | 3 | 0 | Rate Code (Hotel-Specific) | ||
41 | ![]() |
HOTEL_AREA_LOC | FTPD_HOTEL_AREA | CHAR | 1 | 0 | Hotel Area | ||
42 | ![]() |
PTRV_BW_HOTEL_NIGHTS | INT4 | INT4 | 10 | 0 | No.of Hotel Nights | ||
43 | ![]() |
PTRV_BW_HOTEL_BOOKINGS | INT4 | INT4 | 10 | 0 | Number of Hotel Bookings | ||
44 | ![]() |
0 | 0 | Structure for Rental Car Bookings | |||||
45 | ![]() |
CAR_PROVIDER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Car Rental Provider | * | |
46 | ![]() |
CAR_DATE_BEG | FTPD_DATE | DATS | 8 | 0 | Start Date for Rental Car | ||
47 | ![]() |
CAR_LOC_BEG | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Rental Car Starting Location | * | |
48 | ![]() |
CAR_DATE_END | FTPD_DATE | DATS | 8 | 0 | End date for car rental | ||
49 | ![]() |
CAR_LOC_END | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Dropoff Location | * | |
50 | ![]() |
CAR_CLASS | FTPD_CAR_CLASS | CHAR | 1 | 0 | Rental Car Vehicle Class | ||
51 | ![]() |
CAR_TYPE | FTPD_CAR_TYPE | CHAR | 1 | 0 | Rental Car Vehicle Type | ||
52 | ![]() |
CAR_PRICE | FTPD_PRICE | CURR | 10 | 2 | Car Rental Price Per Day/Week/Etc. | ||
53 | ![]() |
CAR_RATECODE | CHAR12 | CHAR | 12 | 0 | Rental Car Rate Key (Provider-Dependent) | ||
54 | ![]() |
CAR_TOTAL_RATE_TYPE | FTPD_CAR_RATE_CODE | CHAR | 3 | 0 | Car rental rate indicator (total amount) | ||
55 | ![]() |
CAR_TOTAL_RATE_AMOUNT | FTPD_PRICE | CURR | 10 | 2 | Total Price for Car Rental | ||
56 | ![]() |
CAR_STATUS | FTPD_SERVICE_STATUS | CHAR | 2 | 0 | Car Rental Status | ||
57 | ![]() |
CAR_AREA | FTPD_CAR_AREA | CHAR | 1 | 0 | City of car rental office (location) | ||
58 | ![]() |
PTRV_BW_CAR_DAYS | INT4 | INT4 | 10 | 0 | Number of Car Rental Days | ||
59 | ![]() |
PTRV_BW_CAR_BOOKINGS | INT4 | INT4 | 10 | 0 | Number of Car Rental Bookings | ||
60 | ![]() |
CAR_PICKUP_LOC | CHAR6 | CHAR | 6 | 0 | Car rental branch office for vehicle pickup | ||
61 | ![]() |
0 | 0 | Structure for Flight Bookings | |||||
62 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
63 | ![]() |
FLIGHT_NR | FTPD_FLIGHT_NR | CHAR | 6 | 0 | Flight Number | ||
64 | ![]() |
FLIGHT_DATE_DEP | FTPD_DATE | DATS | 8 | 0 | Flight departure date | ||
65 | ![]() |
FLIGHT_TIME_DEP | FTPD_TIME | TIMS | 6 | 0 | Flight departure time | ||
66 | ![]() |
FLIGHT_SLOC_DEP | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Departure Location | * | |
67 | ![]() |
FLIGHT_SLOC_ARR | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Flight Arrival Location | * | |
68 | ![]() |
FFARE_TYPES | FTPD_FARE_CHOICE | CHAR | 1 | 0 | Lowest Fare Search | ||
69 | ![]() |
FLIGHT_CABIN | FTPD_FLIGHT_CABIN | CHAR | 1 | 0 | Flight Cabin Class | ||
70 | ![]() |
FLIGHT_RBD | FTPD_FLIGHT_RBD | CHAR | 1 | 0 | Flight Booking Code (RBD) | ||
71 | ![]() |
FLIGHT_STATUS | FTPD_SERVICE_STATUS | CHAR | 2 | 0 | Flight Status | ||
72 | ![]() |
PTRV_BW_FLIGHT_NUMBER | INT4 | INT4 | 10 | 0 | Number of Flights | ||
73 | ![]() |
FARE_BASIS_CODE | CHAR10 | CHAR | 10 | 0 | Basis code of rate component | ||
74 | ![]() |
0 | 0 | Structure for Flight Tickets | |||||
75 | ![]() |
LOCAL_TST | CHAR1_X | CHAR | 1 | 0 | Ticket element is local (not in booking system) | ||
76 | ![]() |
TST_LAST_DATE | FTPD_DATE | DATS | 8 | 0 | Last Ticketing Date | ||
77 | ![]() |
TST_TICKET_MODE | FTPD_TST_MODE | CHAR | 1 | 0 | Ticketing Mode of Airline Ticket | ||
78 | ![]() |
TST_SALES_IND | FTPD_TST_SALES_IND | CHAR | 4 | 0 | Sales Type of Airline Ticket Rate | ||
79 | ![]() |
TST_FARE | FTPD_PRICE | CURR | 10 | 2 | Basic rate for flight ticket without tax | ||
80 | ![]() |
TST_TOTAL_FARE | FTPD_PRICE | CURR | 10 | 2 | Total price of flight ticket | ||
81 | ![]() |
0 | 0 | Structure for Return Flights | |||||
82 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
83 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
84 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
85 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
86 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
87 | ![]() |
FLIGHT_CABIN | FTPD_FLIGHT_CABIN | CHAR | 1 | 0 | Flight Cabin Class | ||
88 | ![]() |
FLIGHT_CABIN | FTPD_FLIGHT_CABIN | CHAR | 1 | 0 | Flight Cabin Class | ||
89 | ![]() |
FLIGHT_CABIN | FTPD_FLIGHT_CABIN | CHAR | 1 | 0 | Flight Cabin Class | ||
90 | ![]() |
FLIGHT_CABIN | FTPD_FLIGHT_CABIN | CHAR | 1 | 0 | Flight Cabin Class | ||
91 | ![]() |
FLIGHT_CABIN | FTPD_FLIGHT_CABIN | CHAR | 1 | 0 | Flight Cabin Class | ||
92 | ![]() |
FLIGHT_RBD | FTPD_FLIGHT_RBD | CHAR | 1 | 0 | Flight Booking Code (RBD) | ||
93 | ![]() |
FLIGHT_RBD | FTPD_FLIGHT_RBD | CHAR | 1 | 0 | Flight Booking Code (RBD) | ||
94 | ![]() |
FLIGHT_RBD | FTPD_FLIGHT_RBD | CHAR | 1 | 0 | Flight Booking Code (RBD) | ||
95 | ![]() |
FLIGHT_RBD | FTPD_FLIGHT_RBD | CHAR | 1 | 0 | Flight Booking Code (RBD) | ||
96 | ![]() |
FLIGHT_RBD | FTPD_FLIGHT_RBD | CHAR | 1 | 0 | Flight Booking Code (RBD) | ||
97 | ![]() |
PTRV_BW_SLOC_VIA | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Connection Airport for Round Trip | * | |
98 | ![]() |
PTRV_BW_SLOC_VIA | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Connection Airport for Round Trip | * | |
99 | ![]() |
PTRV_BW_FLIGHT_RETURNS | INT4 | INT4 | 10 | 0 | Number of Return Flights | ||
100 | ![]() |
0 | 0 | Structure for Car Rental Bookings: Enhancement for 4.6B | |||||
101 | ![]() |
CAR_CORPORATE_ID | FTPD_CORPORATION_ID | CHAR | 30 | 0 | Company ID for Negotiated Rates | ||
102 | ![]() |
0 | 0 | Structure for Flight Bookings: Enhancement for 4.6B | |||||
103 | ![]() |
FLIGHT_AIRLINE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Airline | * | |
104 | ![]() |
0 | 0 | Structure for Hotel Bookings: Enhancement for 4.6B | |||||
105 | ![]() |
HOTEL_CORPORATE_ID | FTPD_CORPORATION_ID | CHAR | 30 | 0 | Company identification for room reservation | ||
106 | ![]() |
0 | 0 | Structure for Flight Tickets: Enhancement for 4.6B | |||||
107 | ![]() |
PLATING_CARRIER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Plating Carrier | * | |
108 | ![]() |
TST_ISSUE_TYPE | FTPD_TST_ISSUE_TYPE | CHAR | 1 | 0 | Airline Ticket Issue | ||
109 | ![]() |
TST_REBATED_FARE | FTPD_PRICE | CURR | 10 | 2 | Discount price of flight ticket | ||
110 | ![]() |
TICKET_NUMBER | FTPD_TICKET_NUMBER | NUMC | 15 | 0 | Ticket Number | ||
111 | ![]() |
TICKETTYPE | FTPD_TICKET_TYPE | CHAR | 1 | 0 | Ticket Type | ||
112 | ![]() |
TST_FARE_TYPE | FTPD_TST_FARE_TYPE | CHAR | 2 | 0 | Fare Type (Normal, Negotiated, Etc.) |
History
Last changed by/on | SAP | 20050409 |
SAP Release Created in |