SAP ABAP Table FTPS_WEB_ITEM_SERVICE (Item Service (Portal RFC Interface))
Hierarchy
EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   FI-TV-PL (Application Component) Travel Planning
     PTRP_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Planning
Basic Data
Table Category INTTAB    Structure 
Structure FTPS_WEB_ITEM_SERVICE   Table Relationship Diagram
Short Description Item Service (Portal RFC Interface)    
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 .INCLUDE       0   0   (Portal RFC-Interface)  
2 ITEM ITEMPOS_NR FTPD_ITEM_ID NUMC 3   0   Travel Request Item Number (Sequential Number) *
3 SERVICE FTPD_WEB_SERVICE_ID   NUMC 3   0   Service Number  
4 .INCLUDE       0   0   Service Common Data (Portal RFC-Interface)  
5 REAL_CAT CATEGORY FTPD_ITEM_CATEGORY CHAR 1   0   Travel service category  
6 REAL_CAT_TEXT VAL_TEXT DDTEXT CHAR 60   0   Short Text for Fixed Values  
7 CATEGORY ITEMPOS_USER_CAT FTPD_USER_CAT CHAR 1   0   Enterprise-Specific Travel Service Category *
8 CATEGORY_TEXT ITEMPOS_USER_CAT_NAME TEXT30 CHAR 30   0   Description  
9 .INCLUDE       0   0   Reason Code  
10 REASON_CODE REASON_CODE FTPD_REASON_CODE CHAR 2   0   Reason Code *
11 REASON_TEXT REASON_TEXT TEXT132 CHAR 132   0   Reason Text  
12 REASON_CODE_TEXT REASON_NAME FTPD_NAME CHAR 40   0   Reason description  
13 STATUS SERVICE_STATUS FTPD_SERVICE_STATUS CHAR 2   0   Service status  
14 STATUS_TEXT VAL_TEXT DDTEXT CHAR 60   0   Short Text for Fixed Values  
15 FF_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
16 CONF_NUMBER_TEXT FTPD_WEB_LONG_TEXT TEXT255 CHAR 255   0   Long Text  
17 MEMBERSHIP_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
18 CANCELLATION_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
19 PRICE_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
20 ITEM_RATE_LOC FTPD_WEB_RATE FTPD_PRICE CURR 10   2   Rate in Local Currency  
21 ITEM_CURR_LOC FTPD_WEB_CURR WAERS CUKY 5   0   Item Local Currency *
22 REF_ITEM ITEMPOS_REF_NR FTPD_ITEM_ID NUMC 3   0   Reference to another request (return flight) *
23 COUNTRY_BEG LAND1 LAND1 CHAR 3   0   Country Key *
24 COUNTRY_END LAND1 LAND1 CHAR 3   0   Country Key *
25 RES_SYSTEM RESERVATION_SYSTEM FTPD_PROVIDER_CODE CHAR 3   0   Reservation System *
26 .INCLUDE       0   0   Flight (Portal RFC Interface)  
27 .INCLUDE       0   0   Flight Title (Portal RFC Interface)  
28 AIRLINE FLIGHT_AIRLINE FTPD_PROVIDER_CODE CHAR 3   0   Airline *
29 FLIGHT_NR FLIGHT_NR FTPD_FLIGHT_NR CHAR 6   0   Flight Number  
30 OP_AIRLINE FLIGHT_AIRLINE FTPD_PROVIDER_CODE CHAR 3   0   Airline *
31 FLIGHT_HEADER_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
32 .INCLUDE       0   0   Flight Departure (Portal RFC Interface)  
33 DATE_DEP FLIGHT_DATE_DEP FTPD_DATE DATS 8   0   Flight departure date  
34 TIME_DEP FLIGHT_TIME_DEP FTPD_TIME TIMS 6   0   Flight departure time  
35 LOC_DEP FLIGHT_SLOC_DEP FTPD_IATA_LOCATION CHAR 3   0   Departure Location *
36 DAY_DEP TAGBEZ CHAR15 CHAR 15   0   Day name  
37 TERM_DEP FLIGHT_TERM_DEP FTPD_TERMINAL CHAR 2   0   Terminal Code (Departure)  
38 GATE_DEP FLIGHT_GATE_DEP FTPD_FLIGHT_GATE CHAR 6   0   Flight departure terminal  
39 DEP_LONG_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
40 COUNTRY_DEP LAND1 LAND1 CHAR 3   0   Country Key *
41 COUNTRY_DEP_TEXT LANDX TEXT15 CHAR 15   0   Country Name  
42 DATE_DEP_GMT FLIGHT_DATE_DEP FTPD_DATE DATS 8   0   Flight departure date  
43 TIME_DEP_GMT FLIGHT_TIME_DEP FTPD_TIME TIMS 6   0   Flight departure time  
44 DAY_DEP_GMT TAGBEZ CHAR15 CHAR 15   0   Day name  
45 .INCLUDE       0   0   Flight Arrival (Portal RFC Interface)  
46 DATE_ARR FLIGHT_DATE_ARR FTPD_DATE DATS 8   0   Flight arrival date  
47 TIME_ARR FLIGHT_TIME_ARR FTPD_TIME TIMS 6   0   Flight arrival time  
48 LOC_ARR FLIGHT_SLOC_ARR FTPD_IATA_LOCATION CHAR 3   0   Flight Arrival Location *
49 DAY_ARR TAGBEZ CHAR15 CHAR 15   0   Day name  
50 TERM_ARR FLIGHT_TERM_ARR FTPD_TERMINAL CHAR 2   0   Terminal code (arrival)  
51 GATE_ARR FLIGHT_GATE_ARR FTPD_FLIGHT_GATE CHAR 6   0   Flight arrival terminal  
52 ARR_LONG_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
53 COUNTRY_ARR LAND1 LAND1 CHAR 3   0   Country Key *
54 COUNTRY_ARR_TEXT LANDX TEXT15 CHAR 15   0   Country Name  
55 DATE_ARR_GMT FLIGHT_DATE_ARR FTPD_DATE DATS 8   0   Flight arrival date  
56 TIME_ARR_GMT FLIGHT_TIME_ARR FTPD_TIME TIMS 6   0   Flight arrival time  
57 DAY_ARR_GMT TAGBEZ CHAR15 CHAR 15   0   Day name  
58 CABIN FLIGHT_CABIN FTPD_FLIGHT_CABIN CHAR 1   0   Flight Cabin Class  
59 RBD FLIGHT_RBD FTPD_FLIGHT_RBD CHAR 1   0   Flight Booking Code (RBD)  
60 CABIN_TEXT VAL_TEXT DDTEXT CHAR 60   0   Short Text for Fixed Values  
61 SEAT_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
62 SEAT_STATUS_TEXT VAL_TEXT DDTEXT CHAR 60   0   Short Text for Fixed Values  
63 SEAT_STATUS FLIGHT_SEAT_STATUS FTPD_LEG_STATUS CHAR 2   0   Flight seat status  
64 ETIX_POSSIBLE FLIGHT_ELEC_TKT CHAR1_X CHAR 1   0   Electronic ticketing for flight is possible  
65 .INCLUDE       0   0   Hotel (Portal RFC Interface)  
66 .INCLUDE       0   0   Hotel Title (Portal RFC Interface)  
67 HOTEL_RES_SYSTEM HOTEL_RES_SYSTEM FTPD_HOTEL_RES_SYSTEM CHAR 1   0   Hotel Reservation Systems Supported by Travel Planning  
68 HOTEL HOTEL_PROVIDER FTPD_PROVIDER_CODE CHAR 3   0   Hotel Chain *
69 PROPERTY HOTEL_PROPERTY FTPD_HOTEL_PROP CHAR 6   0   Hotel Code (Key for an Individual Hotel)  
70 HOTEL_NUMBER HRS_HOTEL_NUMBER CHAR10 CHAR 10   0   HRS Hotel Number  
71 LOC HOTEL_SLOCATION FTPD_IATA_LOCATION CHAR 3   0   Hotel Location *
72 HOTEL_NAME HOTEL_NAME TEXT40 CHAR 40   0   Name of Hotel  
73 HOTEL_CHAIN PROVIDER_NAME TEXT30 CHAR 30   0   Provider Name  
74 HOTEL_LOCATION_TEXT IATA_LOCATION_NAME TEXT30 CHAR 30   0   IATA Location Name  
75 .INCLU-_H       0   0   Hotel Date (Portal RFC Interface)  
76 DATE_ARR_H HOTEL_DATE_ARR FTPD_DATE DATS 8   0   Arrival Date Hotel  
77 DATE_DEP_H HOTEL_DATE_DEP FTPD_DATE DATS 8   0   Departure Date Hotel  
78 DAY_ARR_H TAGBEZ CHAR15 CHAR 15   0   Day name  
79 DAY_DEP_H TAGBEZ CHAR15 CHAR 15   0   Day name  
80 ROOM_LONG_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
81 ADD_INFO_TEXT HOTEL_ADD_INFO FTPD_INFO CHAR 132   0   Additional hotel information  
82 HOTEL_ADDRESS_L1 HOTEL_ADDRESS TEXT132 CHAR 132   0   Hotel Address (address string separated by #)  
83 HOTEL_ADDRESS_L2 HOTEL_ADDRESS TEXT132 CHAR 132   0   Hotel Address (address string separated by #)  
84 HOTEL_PHONE FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
85 MEALS_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
86 HOTEL_PRICE HOTEL_PRICE FTPD_PRICE CURR 10   2   Total Price for Hotel Stay  
87 HOTEL_RATE HOTEL_RATE FTPD_PRICE CURR 10   2   Rate/Price Per Night  
88 HOTEL_CURRENCY HOTEL_CURRENCY WAERS CUKY 5   0   Currency *
89 .INCLUDE       0   0   (Portal RFC Interface)  
90 .INCLUDE       0   0   Car Title (Portal RFC Interface)  
91 PROVIDER CAR_PROVIDER FTPD_PROVIDER_CODE CHAR 3   0   Car Rental Provider *
92 PROVIDER_NAME PROVIDER_NAME TEXT30 CHAR 30   0   Provider Name  
93 CAR_DESC_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
94 .INCLU-_C       0   0   (Portal RFC-Interface)  
95 DATE_BEG_C CAR_DATE_BEG FTPD_DATE DATS 8   0   Start Date for Rental Car  
96 TIME_BEG_C CAR_TIME_BEG FTPD_TIME TIMS 6   0   Rental Car Starting Time  
97 LOC_BEG_C CAR_LOC_BEG FTPD_IATA_LOCATION CHAR 3   0   Rental Car Starting Location *
98 DAY_BEG_C TAGBEZ CHAR15 CHAR 15   0   Day name  
99 PICKUP_LOCATION_TEXT_C FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
100 PICKUP_LOC_ADD_INFO_C FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
101 .INCLU-_C       0   0   (Portal RFC Interface)  
102 DATE_END_C CAR_DATE_END FTPD_DATE DATS 8   0   End date for car rental  
103 TIME_END_C CAR_TIME_END FTPD_TIME TIMS 6   0   End time for car rental  
104 LOC_END_C CAR_LOC_END FTPD_IATA_LOCATION CHAR 3   0   Dropoff Location *
105 DAY_END_C TAGBEZ CHAR15 CHAR 15   0   Day name  
106 DROPOFF_LOCATION_TEXT_C FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
107 DROPOFF_LOC_ADD_INFO_C FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
108 CAR_TOTAL_RATE CAR_TOTAL_RATE_AMOUNT FTPD_PRICE CURR 10   2   Total Price for Car Rental  
109 CAR_CURRENCY CAR_CURRENCY WAERS CUKY 5   0   Currency *
110 CAR_PICKUP_LOC CAR_PICKUP_LOC CHAR6 CHAR 6   0   Car rental branch office for vehicle pickup  
111 CAR_DROPOFF_LOC CAR_DROPOFF_LOC CHAR6 CHAR 6   0   Car rental office for dropoff  
112 CAR_CLASS CAR_CLASS FTPD_CAR_CLASS CHAR 1   0   Rental Car Vehicle Class  
113 CAR_TYPE CAR_TYPE FTPD_CAR_TYPE CHAR 1   0   Rental Car Vehicle Type  
114 CAR_TRANSMISSION CAR_TRANSMISSION FTPD_CAR_TRANSMISSION CHAR 1   0   Car Transmission  
115 CAR_AIR_CONDITION CAR_AIR_CONDITION FTPD_CAR_AIR_CONDITION CHAR 1   0   Vehicle Air-Conditioning  
116 CAR_RATE_CODE CAR_RATECODE CHAR12 CHAR 12   0   Rental Car Rate Key (Provider-Dependent)  
117 CAR_DELIVERY_ADDR CAR_DELIVERY_ADDRESS CHAR60 CHAR 60   0   Address to Which Car Is Delivered  
118 CAR_COLLECTION_ADDR CAR_COLLECTION_ADDRESS CHAR60 CHAR 60   0   Address at Which Car Is Collected  
119 .INCLUDE       0   0   (Portal RFC Interface)  
120 .INCLU-_T       0   0   (Portal RFC-Interface)  
121 TRAIN_RES_SYSTEM_T TRAIN_RES_SYSTEM FTPD_TRAIN_RES_SYSTEM CHAR 1   0   Rail Reservation Systems Supported by Travel Planning  
122 PROVIDER_T TRAIN_PROVIDER FTPD_PROVIDER_CODE CHAR 3   0   Train provider *
123 TRAIN_NR_T TRAIN_NR FTPD_FLIGHT_NR CHAR 6   0   Train number  
124 TRAIN_HEADER_TEXT_T FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
125 .INCLU-_T       0   0   (Portal RFC Interface) Train Data Specific to NVS  
126 PRICE_T RAIL_ORDER_PRICE FTPD_PRICE CURR 10   2   Price of a Rail Order  
127 PRICE_CURR_T RAIL_ORDER_PRICE_CURR WAERS CUKY 5   0   Currency of Rail Order Price *
128 CLASS_TEXT_T     CHAR 16   0    
129 REBATE_TEXT_T     CHAR 48   0    
130 BAHNTIX_INFO_T     CHAR 64   0    
131 .INCLU-_T       0   0   (Portal RFC Interface) Train Data Specific to Rail Portal  
132 ORDER_NR_T PNR_RECORD_LOCATOR FTPD_PNR_RECORD_LOCATOR CHAR 20   0   Passenger Name Record Locator  
133 ORDER_PRICE_T RAIL_ORDER_PRICE FTPD_PRICE CURR 10   2   Price of a Rail Order  
134 ORDER_PRICE_CURR_T RAIL_ORDER_PRICE_CURR WAERS CUKY 5   0   Currency of Rail Order Price *
135 TICKET_1_INFO_T FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
136 TICKET_2_INFO_T FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
137 .INCLU-_T       0   0   (Portal RFC-Interface)  
138 DATE_DEP_T TRAIN_DATE_DEP FTPD_DATE DATS 8   0   Start date  
139 TIME_DEP_T TRAIN_TIME_DEP FTPD_TIME TIMS 6   0   Start time  
140 DAY_DEP_T TAGBEZ CHAR15 CHAR 15   0   Day name  
141 LOC_DEP_T TRAIN_LOC_DEP FTPD_GEO_ID CHAR 3   0   Departure loc.  
142 GATE_DEP_T TRAIN_GATE_DEP FTPD_FLIGHT_GATE CHAR 6   0   Departure platform  
143 TRAIN_DEP_TEXT_T FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
144 .INCLU-_T       0   0   (Portal-RFC Interface)  
145 DATE_ARR_T TRAIN_DATE_ARR FTPD_DATE DATS 8   0   Arrival date  
146 TIME_ARR_T TRAIN_TIME_ARR FTPD_TIME TIMS 6   0   Arrival time  
147 DAY_ARR_T TAGBEZ CHAR15 CHAR 15   0   Day name  
148 LOC_ARR_T TRAIN_LOC_ARR FTPD_GEO_ID CHAR 3   0   Arrival Location  
149 GATE_ARR_T TRAIN_GATE_ARR FTPD_FLIGHT_GATE CHAR 6   0   Arrival platform  
150 TRAIN_ARR_TEXT_T FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
151 COACH_NR TRAIN_COACH_NR CHAR4 CHAR 4   0   Coach number  
152 SEAT_NR TRAIN_SEAT_NR CHAR4 CHAR 4   0   Seat Number  
153 SEAT_PRICE TRAIN_SEAT_PRICE FTPD_PRICE CURR 10   2   Price of Seat Reservation  
154 SEAT_PRICE_CURR TRAIN_SEAT_PRICE_CURRENCY WAERS CUKY 5   0   Currency for Seat Reservation Price *
155 RES_INFO_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
156 SEAT_PRICE_TEXT FTPD_WEB_LONG_NAME TEXT100 CHAR 100   0   Long Text  
157 SUPPLEMENT TRAIN_SUPPLEMENT FTPD_PRICE CURR 10   2   Supplement for Train Connection  
158 SUPPLEMENT_CURR TRAIN_SUPPLEMENT_CURR WAERS CUKY 5   0   Currency for Supplement (Train) *
159 .INCLU-_O       0   0   Structure "Other Service" for Web RFC and Itinerary  
160 SERVICE_CODE_O OTHER_SERVICE_CODE FTPD_OS_CODE CHAR 1   0   Other Travel Service: Code  
161 SERVICE_NAME_O OTHER_SERVICE_NAME TEXT30 CHAR 30   0   Other Travel Service: Name  
162 DATE_BEG_O OS_DATE_BEG FTPD_DATE DATS 8   0   Start Date of Other Service  
163 TIME_BEG_O OS_TIME_BEG FTPD_TIME TIMS 6   0   Start Time of Other Service  
164 DAY_BEG_O TAGBEZ CHAR15 CHAR 15   0   Day name  
165 LOC_BEG_O OS_LOC_BEG FTPD_IATA_LOCATION CHAR 3   0   Start Location of Other Service (IATA) *
166 LOC_BEG_TEXT_O OS_LOC_BEG_TEXT FTPD_OS_LOC_TEXT CHAR 32   0   Start Location of Other Service  
167 DATE_END_O OS_DATE_END FTPD_DATE DATS 8   0   End Date of Other Service  
168 TIME_END_O OS_TIME_END FTPD_TIME TIMS 6   0   End Time of Other Service  
169 DAY_END_O TAGBEZ CHAR15 CHAR 15   0   Day name  
170 LOC_END_O OS_LOC_END FTPD_IATA_LOCATION CHAR 3   0   End Location of Other Service (IATA) *
171 LOC_END_TEXT_O OS_LOC_END_TEXT FTPD_OS_LOC_TEXT CHAR 32   0   End Location of Other Service  
172 STATUS_O OS_STATUS FTPD_OTHER_SERVICE_STATUS CHAR 1   0   Status of Other Service  
173 CONF_NUMBER_O OS_CONF_NUMBER FTPD_OS_CONF_NR NUMC 16   0   Confirmation Code of Other Service  
174 COMMENT1_O OS_COMMENT FTPD_OS_COMMENT CHAR 255   0   Comment for Other Service  
175 COMMENT2_O OS_COMMENT FTPD_OS_COMMENT CHAR 255   0   Comment for Other Service  
176 PRICE_O ITEMPOS_PRICE FTPD_PRICE CURR 10   2   Price of request item  
177 CURRENCY_O ITEMPOS_CURRENCY WAERS CUKY 5   0   Currency of request item *
History
Last changed by/on SAP  20130529 
SAP Release Created in 200