SAP ABAP Table FTPS_PNR_INTERF_CAR (PNR Car Rental)
Hierarchy
☛
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
⤷ FI-TV-PL (Application Component) Travel Planning
⤷ PTRP (Package) Travel Planning
⤷ FI-TV-PL (Application Component) Travel Planning
⤷ PTRP (Package) Travel Planning
Basic Data
Table Category | INTTAB | Structure |
Structure | FTPS_PNR_INTERF_CAR | Table Relationship Diagram |
Short Description | PNR Car Rental |
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 | LINE_NUMBER_C | C_LINE_NUMBER | NUMC | 5 | 0 | Line Number (CHAR Format) | |||
2 | PROVIDER | CAR_PROVIDER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Car Rental Provider | * | |
3 | LOC_BEG | CAR_LOC_BEG | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Rental Car Starting Location | * | |
4 | DATE_BEG | CAR_DATE_BEG | FTPD_DATE | DATS | 8 | 0 | Start Date for Rental Car | ||
5 | TIME_BEG | CAR_TIME_BEG | FTPD_TIME | TIMS | 6 | 0 | Rental Car Starting Time | ||
6 | LOC_END | CAR_LOC_END | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Dropoff Location | * | |
7 | DATE_END | CAR_DATE_END | FTPD_DATE | DATS | 8 | 0 | End date for car rental | ||
8 | TIME_END | CAR_TIME_END | FTPD_TIME | TIMS | 6 | 0 | End time for car rental | ||
9 | PICKUP_LOC | CAR_PICKUP_LOC | CHAR6 | CHAR | 6 | 0 | Car rental branch office for vehicle pickup | ||
10 | DROPOFF_LOC | CAR_DROPOFF_LOC | CHAR6 | CHAR | 6 | 0 | Car rental office for dropoff | ||
11 | ARRIVAL_INFO | ARRIVAL_INFO | CHAR | 36 | 0 | Car Rental Info | |||
12 | RETURN_TIME_INFO | CHAR6 | CHAR6 | CHAR | 6 | 0 | Character field of length 6 | ||
13 | STATUS_CODE | CAR_STATUS | FTPD_SERVICE_STATUS | CHAR | 2 | 0 | Car Rental Status | ||
14 | QUANTITY | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
15 | CLASS | CAR_CLASS | FTPD_CAR_CLASS | CHAR | 1 | 0 | Rental Car Vehicle Class | ||
16 | TYPE | CAR_TYPE | FTPD_CAR_TYPE | CHAR | 1 | 0 | Rental Car Vehicle Type | ||
17 | TRANSMISSION | CAR_TRANSMISSION | FTPD_CAR_TRANSMISSION | CHAR | 1 | 0 | Car Transmission | ||
18 | AIR_CONDITION | CAR_AIR_CONDITION | FTPD_CAR_AIR_CONDITION | CHAR | 1 | 0 | Vehicle Air-Conditioning | ||
19 | NAME_GIVEN | CHAR25 | CHAR25 | CHAR | 25 | 0 | User field for cluster PC (national) | ||
20 | RATE_CODE | CAR_RATECODE | CHAR12 | CHAR | 12 | 0 | Rental Car Rate Key (Provider-Dependent) | ||
21 | CONF_NUM | CAR_CONFIRMATION_NUMBER | FTPD_CAR_CONF_NUMBER | CHAR | 17 | 0 | Car Rental Reservation Number | ||
22 | BOOKING_SOURCE | BOOKING_SOURCE | CHAR40 | CHAR | 40 | 0 | Identification for booking/reservations | ||
23 | CORPORATE_ID | CAR_CORPORATE_ID | FTPD_CORPORATION_ID | CHAR | 30 | 0 | Company ID for Negotiated Rates | ||
24 | MEMBERSHIP_ID | PROV_PROGRAM_NR | CHAR20 | CHAR | 20 | 0 | Customer number | ||
25 | SPECIAL_INFO | CHAR_132 | CHAR | 132 | 0 | Text of length 132 | |||
26 | .INCLUDE | 0 | 0 | Rental Car Rate | |||||
27 | RATE_PROVIDER | CAR_PROVIDER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Car Rental Provider | * | |
28 | CURRENCY | CAR_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
29 | BASE_RATE | CAR_PRICE | FTPD_PRICE | CURR | 10 | 2 | Car Rental Price Per Day/Week/Etc. | ||
30 | RATE_TYPE | CAR_RATE_PLAN | CHAR8 | CHAR | 8 | 0 | Rental Car Rate Rule (by day/weekend/week/month) | ||
31 | EXTRA_CHARGE | CAR_EXTRA_CHARGE | FTPD_PRICE | CURR | 10 | 2 | Surcharge for Car Rental Excess Usage | ||
32 | EXTRA_CHARGE_TYPE | CAR_EXTRA_CHARGE_TYPE | FTPD_CAR_RATE_CODE | CHAR | 3 | 0 | Surcharge time unit for car rental usage exceeding | ||
33 | TOTAL_RATE | CAR_TOTAL_RATE_AMOUNT | FTPD_PRICE | CURR | 10 | 2 | Total Price for Car Rental | ||
34 | PERMILE_CHARGE | CAR_EXTRA_MILAGE | FTPD_PRICE | CURR | 10 | 2 | Surcharge for Exceeding Miles/Kms Limit for Rental Car | ||
35 | UNLIMITED_IND | CHAR | 1 | 0 | |||||
36 | FREE_MILES | CAR_FREE_MILES | CHAR5 | CHAR | 5 | 0 | Distance Restriction (miles/kilometers) | ||
37 | DISTANCE_TYPE | CHAR | 1 | 0 | |||||
38 | ADDITIONAL_INFO | CHAR | 132 | 0 | |||||
39 | DROP_OFF_CHARGE | CAR_DROPOFF_CHARGE | FTPD_PRICE | CURR | 10 | 2 | Charges for Rental Car Dropoff | ||
40 | BOOKING_AGENT | CHAR12 | CHAR12 | CHAR | 12 | 0 | Character Field of Length 12 | ||
41 | FREQUENT_TRAVELLER_NUMBER | CHAR26 | CHAR26 | CHAR | 26 | 0 | Character field length 26 | ||
42 | OPTIONAL_EQUIPMENT | CHAR15 | CHAR15 | CHAR | 15 | 0 | Char 15 | ||
43 | GUARANTEE_CREDIT_CARD_VENDOR | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
44 | GUARANTEE_CREDIT_CARD_NUMBER | CHAR21 | CHAR21 | CHAR | 21 | 0 | Field Name | ||
45 | GUARANTEE_CREDIT_CARD_DATE | CHAR7 | CHAR7 | CHAR | 7 | 0 | Character field, length 7 | ||
46 | PASSENGER_ID_C | C_PASS_ID | NUMC | 5 | 0 | Passenger Number | |||
47 | .INCLU--AP | 0 | 0 | Append Structure for FTPS_PNR_INTERF_CAR | |||||
48 | NON_GDS_PUP_LOC | CAR_PICKUP_LOC_NONGDS | CHAR11 | CHAR | 11 | 0 | Car Rental Branch Office for Pickup (Provider-Specific) | ||
49 | NON_GDS_DO_LOC | CAR_DROPOFF_LOC_NONGDS | CHAR11 | CHAR | 11 | 0 | Car Rental Branch Office for Dropoff (Provider-Specific) |
History
Last changed by/on | SAP | 20071120 |
SAP Release Created in | 461 |