SAP ABAP Table FTPT_CAR (Travel Request Item - Car Rental Service)
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 | TRANSP | Transparent table |
Transparent table | FTPT_CAR | Table Relationship Diagram |
Short Description | Travel Request Item - Car Rental Service |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | Key to travel plan table | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
4 | REINR | REINR | REINR | NUMC | 10 | 0 | Trip Number | ||
5 | PLANNR | PLAN_NR | FTPD_PLAN_NR | NUMC | 2 | 0 | Travel Plan Number (Sequential Number) | * | |
6 | VARIANT | VARIANT_NR | FTPD_VARIANT_NR | NUMC | 2 | 0 | Plan variant number (sequential number) | ||
7 | VARIANTVRS | VARIANT_VERSION | FTPD_VARIANT_VERSION | NUMC | 2 | 0 | Version of travel plan | * | |
8 | ITEM | ITEMPOS_NR | FTPD_ITEM_ID | NUMC | 3 | 0 | Travel Request Item Number (Sequential Number) | FTPT_ITEM | |
9 | SERVICE | CAR_SERVICE_NR | FTPD_CAR_ID | NUMC | 3 | 0 | Rental car number | ||
10 | PROVIDER | CAR_PROVIDER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Car Rental Provider | TA21P | |
11 | DATE_BEG | CAR_DATE_BEG | FTPD_DATE | DATS | 8 | 0 | Start Date for Rental Car | ||
12 | TIME_BEG | CAR_TIME_BEG | FTPD_TIME | TIMS | 6 | 0 | Rental Car Starting Time | ||
13 | LOC_BEG | CAR_LOC_BEG | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Rental Car Starting Location | TA21L | |
14 | DATE_END | CAR_DATE_END | FTPD_DATE | DATS | 8 | 0 | End date for car rental | ||
15 | TIME_END | CAR_TIME_END | FTPD_TIME | TIMS | 6 | 0 | End time for car rental | ||
16 | LOC_END | CAR_LOC_END | FTPD_IATA_LOCATION | CHAR | 3 | 0 | Dropoff Location | TA21L | |
17 | PICKUP_LOC | CAR_PICKUP_LOC | CHAR6 | CHAR | 6 | 0 | Car rental branch office for vehicle pickup | ||
18 | ADDRESS | CAR_ADDRESS | TEXT40 | CHAR | 40 | 0 | Address of car rental branch office for pickup | ||
19 | DROPOFF_LOC | CAR_DROPOFF_LOC | CHAR6 | CHAR | 6 | 0 | Car rental office for dropoff | ||
20 | ADDRESS_DROPOFF | CAR_ADDRESS_DROPOFF | TEXT40 | CHAR | 40 | 0 | Address of car rental office for dropoff | ||
21 | CLASS | CAR_CLASS | FTPD_CAR_CLASS | CHAR | 1 | 0 | Rental Car Vehicle Class | ||
22 | TYPE | CAR_TYPE | FTPD_CAR_TYPE | CHAR | 1 | 0 | Rental Car Vehicle Type | ||
23 | TRANSMISSION | CAR_TRANSMISSION | FTPD_CAR_TRANSMISSION | CHAR | 1 | 0 | Car Transmission | ||
24 | AIR_CONDITION | CAR_AIR_CONDITION | FTPD_CAR_AIR_CONDITION | CHAR | 1 | 0 | Vehicle Air-Conditioning | ||
25 | QUANTITY | CAR_QUANTITY | FTPD_INT1 | INT1 | 3 | 0 | Number of cars | ||
26 | SEGMENT_INDEX | CAR_SEGMENT_INDEX | FTPD_INT1 | INT1 | 3 | 0 | Current line number of PNR | ||
27 | CONF_NUM | CAR_CONFIRMATION_NUMBER | FTPD_CAR_CONF_NUMBER | CHAR | 17 | 0 | Car Rental Reservation Number | ||
28 | PRICE | CAR_PRICE | FTPD_PRICE | CURR | 10 | 2 | Car Rental Price Per Day/Week/Etc. | ||
29 | RATE_PLAN | CAR_RATE_PLAN | CHAR8 | CHAR | 8 | 0 | Rental Car Rate Rule (by day/weekend/week/month) | ||
30 | RATE_CODE | CAR_RATECODE | CHAR12 | CHAR | 12 | 0 | Rental Car Rate Key (Provider-Dependent) | ||
31 | CORPORATE_ID | CAR_CORPORATE_ID | FTPD_CORPORATION_ID | CHAR | 30 | 0 | Company ID for Negotiated Rates | ||
32 | GUARANTEE_NEEDED | CAR_GUARANTEE_NEEDED | CHAR1_X | CHAR | 1 | 0 | Reservation guarantee required | ||
33 | GUARANTEE | CAR_GUARANTEE | CHAR40 | CHAR | 40 | 0 | Guarantee for rental care reservation at booking | ||
34 | DEPOSIT_NEEDED | CAR_DEPOSIT_NEEDED | CHAR1_X | CHAR | 1 | 0 | Rental car: Down payment required | ||
35 | DEPOSIT | CAR_DEPOSIT | CHAR40 | CHAR | 40 | 0 | Deposit payment method for room reservation | ||
36 | FREE_MILES | CAR_FREE_MILES | CHAR5 | CHAR | 5 | 0 | Distance Restriction (miles/kilometers) | ||
37 | EXTRA_CHARGE | CAR_EXTRA_CHARGE | FTPD_PRICE | CURR | 10 | 2 | Surcharge for Car Rental Excess Usage | ||
38 | DROPOFF_CHARGE | CAR_DROPOFF_CHARGE | FTPD_PRICE | CURR | 10 | 2 | Charges for Rental Car Dropoff | ||
39 | EXTRA_CHARGE_TYP | CAR_EXTRA_CHARGE_TYPE | FTPD_CAR_RATE_CODE | CHAR | 3 | 0 | Surcharge time unit for car rental usage exceeding | ||
40 | TOTAL_RATE_TYPE | CAR_TOTAL_RATE_TYPE | FTPD_CAR_RATE_CODE | CHAR | 3 | 0 | Car rental rate indicator (total amount) | ||
41 | TOT_RATE_AMOUNT | CAR_TOTAL_RATE_AMOUNT | FTPD_PRICE | CURR | 10 | 2 | Total Price for Car Rental | ||
42 | TOT_CURRENCY | CAR_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
43 | EXTRA_MILAGE | CAR_EXTRA_MILAGE | FTPD_PRICE | CURR | 10 | 2 | Surcharge for Exceeding Miles/Kms Limit for Rental Car | ||
44 | CURRENCY | CAR_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
45 | STATUS | CAR_STATUS | FTPD_SERVICE_STATUS | CHAR | 2 | 0 | Car Rental Status | ||
46 | TEMPLATE | VARIANT_TEMPLATE | FTPD_TEMPLATE | CHAR | 1 | 0 | Template indicator | ||
47 | CAR_AREA | CAR_AREA | FTPD_CAR_AREA | CHAR | 1 | 0 | City of car rental office (location) | ||
48 | MEMBSHIP_PROVCAT | MEMBSHIP_PROVIDER_CATEGORY | FTPD_PROVIDER_CATEGORY | CHAR | 1 | 0 | Customer Program: Provider Category | ||
49 | MEMBSHIP_PROV | MEMBSHIP_PROVIDER_CODE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Customer Program: Provider Code | * | |
50 | MEMBSHIP_KRZL | PROV_PROGRAM_SHORTHAND | FTPD_PROV_PROGRAM_SHORTHAND | CHAR | 3 | 0 | Customer Program Code | TA21PF | |
51 | MEMBSHIP_ID | PROV_PROGRAM_NR | CHAR20 | CHAR | 20 | 0 | Customer number | ||
52 | FLIGHT_MEM_PROV | FLIGHT_PROGRAM_PROVIDER_CODE | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Frequent flyer program: Provider code | * | |
53 | FLIGHT_MEM_KRZL | FLIGHT_PROGRAM_SHORTHAND | FTPD_PROV_PROGRAM_SHORTHAND | CHAR | 3 | 0 | Frequent Flyer Program ID | TA21PF | |
54 | FLIGHT_MEM_ID | FLIGHT_PROGRAM_NR | CHAR20 | CHAR | 20 | 0 | Frequent flyer number | ||
55 | PNR_NR | CAR_LINENUMBER | FTPD_LINENUMBER | INT2 | 5 | 0 | Zeilennummer der CAR in der Itinerary | ||
56 | PROFILE | PROF_ID | FTPD_PROF_ID | CHAR | 8 | 0 | Travel Profile | * | |
57 | PROFITEM | PROF_ITEM | FTPD_PROF_ITEM | CHAR | 8 | 0 | Trip rule | * | |
58 | KZTKT | PLAN_ACTIVITY | FTPD_PLAN_ACTIVITY | CHAR | 1 | 0 | Trip Activity Type | * | |
59 | SPECCID | SSPECID | FTPD_SSPEC_ID | CHAR | 8 | 0 | Class rule | * | |
60 | PRIORITY | PROFIL_PRIROITY | FTPD_PROF_PRIORITY | CHAR | 1 | 0 | Priority of trip rule | ||
61 | HIGHEST_PRIORITY | PROFIL_PRIROITY | FTPD_PROF_PRIORITY | CHAR | 1 | 0 | Priority of trip rule | ||
62 | CANCEL_TIME | CAR_CANCEL_TIME | FTPD_CANCEL_TIME | CHAR | 5 | 0 | Car rental reser.: Latest possible cancellation time | ||
63 | CANCEL_TYPE | CAR_CANCEL_TYPE | FTPD_HOTEL_CANCEL_TYPE | CHAR | 1 | 0 | Car rental res.: Time unit - latest poss. cancellation time | ||
64 | .INCLUDE | 0 | 0 | HR Master Record Infotype 0473 (Rental Car Preferences) | |||||
65 | SMOKE | CAR_PREF_SMOKER | CHAR1_X | CHAR | 1 | 0 | Nonsmoking Car Requested | ||
66 | KLIMA | CAR_PREF_KLIMA | CHAR1_X | CHAR | 1 | 0 | Air Conditioning Requested | ||
67 | GEAR | CAR_PREF_GEAR | CHAR1 | CHAR | 1 | 0 | Manual Gear Shift Requested | ||
68 | AUTOM | CAR_PREF_AUTOM | CHAR1 | CHAR | 1 | 0 | Automatic Transmission Requested | ||
69 | CBRAND | CAR_PREF_BRAND | TEXT12 | CHAR | 12 | 0 | Preferred Car Make | ||
70 | PREF1 | CAR_PREF_PROVIDER | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | First Preference for Car Rental Company | TA21P | |
71 | PREF2 | CAR_PREF_PROVIDER2 | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Second Preference for Car Rental Company | TA21P | |
72 | PREF3 | CAR_PREF_PROVIDER3 | FTPD_PROVIDER_CODE | CHAR | 3 | 0 | Third Preference for Car Rental Company | TA21P | |
73 | .INCLUDE | 0 | 0 | ||||||
74 | .INCLUDE | 0 | 0 | Reason Code | |||||
75 | REASON_CODE | REASON_CODE | FTPD_REASON_CODE | CHAR | 2 | 0 | Reason Code | * | |
76 | REASON_TEXT | REASON_TEXT | TEXT132 | CHAR | 132 | 0 | Reason Text | ||
77 | .INCLUDE | 0 | 0 | Encryption of Credit Card Data for Rental Cars | |||||
78 | GUARANTEE_GUID | CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card | ||
79 | DEPOSIT_GUID | CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card | ||
80 | .INCLU--AP | 0 | 0 | Append Structure for FTPT_CAR | |||||
81 | NON_GDS_PUP_LOC | CAR_PICKUP_LOC_NONGDS | CHAR11 | CHAR | 11 | 0 | Car Rental Branch Office for Pickup (Provider-Specific) | ||
82 | NON_GDS_DO_LOC | CAR_DROPOFF_LOC_NONGDS | CHAR11 | CHAR | 11 | 0 | Car Rental Branch Office for Dropoff (Provider-Specific) | ||
83 | ADDITIONAL_INFO | CAR_ADDITIONAL_INFO | CHAR128 | CHAR | 128 | 0 | Additional Information on Vehicle from Provider | ||
84 | EST_PRICE | CAR_TOTAL_RATE_AMOUNT | FTPD_PRICE | CURR | 10 | 2 | Total Price for Car Rental | ||
85 | EST_CURRENCY | CAR_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
86 | CHECK_POLICY | CAR_CHECK_POLICY | CHAR1_X | CHAR | 1 | 0 | Indicates Whether Policy Check Necessary | ||
87 | ADVANCE_PAYMENT | CAR_ADVANCE_PAYMENT | CHAR1_X | CHAR | 1 | 0 | Payment in Advance Required | ||
88 | DELIVERY_ADDR | CAR_DELIVERY_ADDRESS | CHAR60 | CHAR | 60 | 0 | Address to Which Car Is Delivered | ||
89 | COLLECTION_ADDR | CAR_COLLECTION_ADDRESS | CHAR60 | CHAR | 60 | 0 | Address at Which Car Is Collected | ||
90 | FARE_TYPE | CAR_FARE_TYPE | CHAR6 | CHAR | 6 | 0 | Rental Car: Rate Type |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FTPT_CAR | CURRENCY | TCURC | WAERS | REF | 1 | CN |
2 | FTPT_CAR | FLIGHT_MEM_KRZL | TA21PF | KRZL | REF | C | CN |
3 | FTPT_CAR | ITEM | FTPT_ITEM | VARIANTVRS | KEY | 1 | CN |
4 | FTPT_CAR | LOC_BEG | TA21L | LOCID | REF | 1 | CN |
5 | FTPT_CAR | LOC_END | TA21L | LOCID | KEY | 1 | CN |
6 | FTPT_CAR | MEMBSHIP_KRZL | TA21PF | KRZL | REF | C | CN |
7 | FTPT_CAR | PREF1 | TA21P | PROVIDER | REF | C | CN |
8 | FTPT_CAR | PREF2 | TA21P | PROVIDER | REF | C | CN |
9 | FTPT_CAR | PREF3 | TA21P | PROVIDER | REF | C | CN |
10 | FTPT_CAR | PROVIDER | TA21P | PROVIDER | REF | 1 | CN |
11 | FTPT_CAR | TOT_CURRENCY | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20071120 |
SAP Release Created in |