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

Basic Data

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