SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | FTPT_CAR
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Travel Management :: Travel Planning
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FTPT_CAR882Travel Request Item - Car Rental ServiceTravel Planning
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PERNR, REINR, PLANNR, VARIANT, VARIANTVRS, ITEM, SERVICE, PROVIDER, DATE_BEG, TIME_BEG, LOC_BEG, DATE_END, TIME_END, LOC_END, PICKUP_LOC, ADDRESS, DROPOFF_LOC, ADDRESS_DROPOFF, CLASS, TYPE, TRANSMISSION, AIR_CONDITION, QUANTITY, SEGMENT_INDEX, CONF_NUM, PRICE, RATE_PLAN, RATE_CODE, CORPORATE_ID, GUARANTEE_NEEDED, GUARANTEE, DEPOSIT_NEEDED, DEPOSIT, FREE_MILES, EXTRA_CHARGE, DROPOFF_CHARGE, EXTRA_CHARGE_TYP, TOTAL_RATE_TYPE, TOT_RATE_AMOUNT, TOT_CURRENCY, EXTRA_MILAGE, CURRENCY, STATUS, TEMPLATE, CAR_AREA, MEMBSHIP_PROVCAT, MEMBSHIP_PROV, MEMBSHIP_KRZL, MEMBSHIP_ID, FLIGHT_MEM_PROV, FLIGHT_MEM_KRZL, FLIGHT_MEM_ID, PNR_NR, PROFILE, PROFITEM, KZTKT, SPECCID, PRIORITY, HIGHEST_PRIORITY, CANCEL_TIME, CANCEL_TYPE, SMOKE, KLIMA, GEAR, AUTOM, CBRAND, PREF1, PREF2, PREF3, REASON_CODE, REASON_TEXT, GUARANTEE_GUID, DEPOSIT_GUID, NON_GDS_PUP_LOC, NON_GDS_DO_LOC, ADDITIONAL_INFO, EST_PRICE, EST_CURRENCY, CHECK_POLICY, ADVANCE_PAYMENT, DELIVERY_ADDR, COLLECTION_ADDR, FARE_TYPE, EXCEEDING_FARE, EXCEEDING_FARE_C, LOC_BEG_NAME, LOC_END_NAME FROM FTPT_CAR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoPERNR_D Allow NULL? 
3REINRTrip Numbernvarchar100NUMC(N'0000000000')NoREINR Allow NULL? 
4PLANNRTravel Plan Number (Sequential Number)nvarchar20NUMC(N'00')No*PLAN_NR Allow NULL? 
5VARIANTPlan variant number (sequential number)nvarchar20NUMC(N'00')NoVARIANT_NR Allow NULL? 
6VARIANTVRSVersion of travel plannvarchar20NUMC(N'00')No*VARIANT_VERSION Allow NULL? 
7ITEMTravel Request Item Number (Sequential Number)nvarchar30NUMC(N'000')NoFTPT_ITEMITEMPOS_NR Allow NULL? 
8SERVICERental car numbernvarchar30NUMC(N'000')NoCAR_SERVICE_NR Allow NULL? 
9PROVIDERCar Rental Providernvarchar30CHAR(N' ')YesTA21PCAR_PROVIDER Allow NULL? 
10DATE_BEGStart Date for Rental Carnvarchar80DATS(N'00000000')YesCAR_DATE_BEG Allow NULL? 
11TIME_BEGRental Car Starting Timenvarchar60TIMS(N'000000')YesCAR_TIME_BEG Allow NULL? 
12LOC_BEGRental Car Starting Locationnvarchar30CHAR(N' ')YesTA21LCAR_LOC_BEG Allow NULL? 
13DATE_ENDEnd date for car rentalnvarchar80DATS(N'00000000')YesCAR_DATE_END Allow NULL? 
14TIME_ENDEnd time for car rentalnvarchar60TIMS(N'000000')YesCAR_TIME_END Allow NULL? 
15LOC_ENDDropoff Locationnvarchar30CHAR(N' ')YesTA21LCAR_LOC_END Allow NULL? 
16PICKUP_LOCCar rental branch office for vehicle pickupnvarchar60CHAR(N' ')YesCAR_PICKUP_LOC Allow NULL? 
17ADDRESSAddress of car rental branch office for pickupnvarchar400CHAR(N' ')YesCAR_ADDRESS Allow NULL? 
18DROPOFF_LOCCar rental office for dropoffnvarchar60CHAR(N' ')YesCAR_DROPOFF_LOC Allow NULL? 
19ADDRESS_DROPOFFAddress of car rental office for dropoffnvarchar400CHAR(N' ')YesCAR_ADDRESS_DROPOFF Allow NULL? 
20CLASSRental Car Vehicle Classchar10CHAR(N' ')YesCAR_CLASS Allow NULL? 
21TYPERental Car Vehicle Typechar10CHAR(N' ')YesCAR_TYPE Allow NULL? 
22TRANSMISSIONCar Transmissionchar10CHAR(N' ')YesCAR_TRANSMISSION Allow NULL? 
23AIR_CONDITIONVehicle Air-Conditioningchar10CHAR(N' ')YesCAR_AIR_CONDITION Allow NULL? 
24QUANTITYNumber of carstinyint30INT1((0))YesCAR_QUANTITY
25SEGMENT_INDEXCurrent line number of PNRtinyint30INT1((0))YesCAR_SEGMENT_INDEX
26CONF_NUMCar Rental Reservation Numbernvarchar170CHAR(N' ')YesCAR_CONFIRMATION_NUMBER Allow NULL? 
27PRICECar Rental Price Per Day/Week/Etc.decimal102CURR((0))YesCAR_PRICE
28RATE_PLANRental Car Rate Rule (by day/weekend/week/month)nvarchar80CHAR(N' ')YesCAR_RATE_PLAN Allow NULL? 
29RATE_CODERental Car Rate Key (Provider-Dependent)nvarchar120CHAR(N' ')YesCAR_RATECODE Allow NULL? 
30CORPORATE_IDCompany ID for Negotiated Ratesnvarchar300CHAR(N' ')YesCAR_CORPORATE_ID Allow NULL? 
31GUARANTEE_NEEDEDReservation guarantee requiredchar10CHAR(N' ')YesCAR_GUARANTEE_NEEDED Allow NULL? 
32GUARANTEEGuarantee for rental care reservation at bookingnvarchar400CHAR(N' ')YesCAR_GUARANTEE Allow NULL? 
33DEPOSIT_NEEDEDRental car: Down payment requiredchar10CHAR(N' ')YesCAR_DEPOSIT_NEEDED Allow NULL? 
34DEPOSITDeposit payment method for room reservationnvarchar400CHAR(N' ')YesCAR_DEPOSIT Allow NULL? 
35FREE_MILESDistance Restriction (miles/kilometers)nvarchar50CHAR(N' ')YesCAR_FREE_MILES Allow NULL? 
36EXTRA_CHARGESurcharge for Car Rental Excess Usagedecimal102CURR((0))YesCAR_EXTRA_CHARGE
37DROPOFF_CHARGECharges for Rental Car Dropoffdecimal102CURR((0))YesCAR_DROPOFF_CHARGE
38EXTRA_CHARGE_TYPSurcharge time unit for car rental usage exceedingnvarchar30CHAR(N' ')YesCAR_EXTRA_CHARGE_TYPE Allow NULL? 
39TOTAL_RATE_TYPECar rental rate indicator (total amount)nvarchar30CHAR(N' ')YesCAR_TOTAL_RATE_TYPE Allow NULL? 
40TOT_RATE_AMOUNTTotal Price for Car Rentaldecimal102CURR((0))YesCAR_TOTAL_RATE_AMOUNT
41TOT_CURRENCYCurrencynvarchar50CUKY(N' ')YesTCURCCAR_CURRENCY Allow NULL? 
42EXTRA_MILAGESurcharge for Exceeding Miles/Kms Limit for Rental Cardecimal102CURR((0))YesCAR_EXTRA_MILAGE
43CURRENCYCurrencynvarchar50CUKY(N' ')YesTCURCCAR_CURRENCY Allow NULL? 
44STATUSCar Rental Statusnvarchar20CHAR(N' ')YesCAR_STATUS Allow NULL? 
45TEMPLATETemplate indicatorchar10CHAR(N' ')YesVARIANT_TEMPLATE Allow NULL? 
46CAR_AREACity of car rental office (location)char10CHAR(N' ')YesCAR_AREA Allow NULL? 
47MEMBSHIP_PROVCATCustomer Program: Provider Categorychar10CHAR(N' ')YesMEMBSHIP_PROVIDER_CATEGORY Allow NULL? 
48MEMBSHIP_PROVCustomer Program: Provider Codenvarchar30CHAR(N' ')Yes*MEMBSHIP_PROVIDER_CODE Allow NULL? 
49MEMBSHIP_KRZLCustomer Program Codenvarchar30CHAR(N' ')YesTA21PFPROV_PROGRAM_SHORTHAND Allow NULL? 
50MEMBSHIP_IDCustomer numbernvarchar200CHAR(N' ')YesPROV_PROGRAM_NR Allow NULL? 
51FLIGHT_MEM_PROVFrequent flyer program: Provider codenvarchar30CHAR(N' ')Yes*FLIGHT_PROGRAM_PROVIDER_CODE Allow NULL? 
52FLIGHT_MEM_KRZLFrequent Flyer Program IDnvarchar30CHAR(N' ')YesTA21PFFLIGHT_PROGRAM_SHORTHAND Allow NULL? 
53FLIGHT_MEM_IDFrequent flyer numbernvarchar200CHAR(N' ')YesFLIGHT_PROGRAM_NR Allow NULL? 
54PNR_NRZeilennummer der CAR in der Itinerarysmallint50INT2((0))YesCAR_LINENUMBER
55PROFILETravel Profilenvarchar80CHAR(N' ')Yes*PROF_ID Allow NULL? 
56PROFITEMTrip rulenvarchar80CHAR(N' ')Yes*PROF_ITEM Allow NULL? 
57KZTKTTrip Activity Typechar10CHAR(N' ')Yes*PLAN_ACTIVITY Allow NULL? 
58SPECCIDClass rulenvarchar80CHAR(N' ')Yes*SSPECID Allow NULL? 
59PRIORITYPriority of trip rulechar10CHAR(N' ')YesPROFIL_PRIROITY Allow NULL? 
60HIGHEST_PRIORITYPriority of trip rulechar10CHAR(N' ')YesPROFIL_PRIROITY Allow NULL? 
61CANCEL_TIMECar rental reser.: Latest possible cancellation timenvarchar50CHAR(N' ')YesCAR_CANCEL_TIME Allow NULL? 
62CANCEL_TYPECar rental res.: Time unit - latest poss. cancellation timechar10CHAR(N' ')YesCAR_CANCEL_TYPE Allow NULL? 
63SMOKENonsmoking Car Requestedchar10CHAR(N' ')YesCAR_PREF_SMOKER Allow NULL? 
64KLIMAAir Conditioning Requestedchar10CHAR(N' ')YesCAR_PREF_KLIMA Allow NULL? 
65GEARManual Gear Shift Requestedchar10CHAR(N' ')YesCAR_PREF_GEAR Allow NULL? 
66AUTOMAutomatic Transmission Requestedchar10CHAR(N' ')YesCAR_PREF_AUTOM Allow NULL? 
67CBRANDPreferred Car Makenvarchar120CHAR(N' ')YesCAR_PREF_BRAND Allow NULL? 
68PREF1First Preference for Car Rental Companynvarchar30CHAR(N' ')YesTA21PCAR_PREF_PROVIDER Allow NULL? 
69PREF2Second Preference for Car Rental Companynvarchar30CHAR(N' ')YesTA21PCAR_PREF_PROVIDER2 Allow NULL? 
70PREF3Third Preference for Car Rental Companynvarchar30CHAR(N' ')YesTA21PCAR_PREF_PROVIDER3 Allow NULL? 
71REASON_CODEReason Codenvarchar20CHAR(N' ')Yes*REASON_CODE Allow NULL? 
72REASON_TEXTReason Textnvarchar1320CHAR(N' ')YesREASON_TEXT Allow NULL? 
73GUARANTEE_GUIDGUID of a Payment Cardvarbinary160RAWYesCARD_GUID
74DEPOSIT_GUIDGUID of a Payment Cardvarbinary160RAWYesCARD_GUID
75NON_GDS_PUP_LOCCar Rental Branch Office for Pickup (Provider-Specific)nvarchar110CHAR(N' ')YesCAR_PICKUP_LOC_NONGDS Allow NULL? 
76NON_GDS_DO_LOCCar Rental Branch Office for Dropoff (Provider-Specific)nvarchar110CHAR(N' ')YesCAR_DROPOFF_LOC_NONGDS Allow NULL? 
77ADDITIONAL_INFOAdditional Information on Vehicle from Providernvarchar1280CHAR(N' ')YesCAR_ADDITIONAL_INFO Allow NULL? 
78EST_PRICETotal Price for Car Rentaldecimal102CURR((0))YesCAR_TOTAL_RATE_AMOUNT
79EST_CURRENCYCurrencynvarchar50CUKY(N' ')Yes*CAR_CURRENCY Allow NULL? 
80CHECK_POLICYIndicates Whether Policy Check Necessarychar10CHAR(N' ')YesCAR_CHECK_POLICY Allow NULL? 
81ADVANCE_PAYMENTPayment in Advance Requiredchar10CHAR(N' ')YesCAR_ADVANCE_PAYMENT Allow NULL? 
82DELIVERY_ADDRAddress to Which Car Is Deliverednvarchar600CHAR(N' ')YesCAR_DELIVERY_ADDRESS Allow NULL? 
83COLLECTION_ADDRAddress at Which Car Is Collectednvarchar600CHAR(N' ')YesCAR_COLLECTION_ADDRESS Allow NULL? 
84FARE_TYPERental Car: Rate Typenvarchar60CHAR(N' ')YesCAR_FARE_TYPE Allow NULL? 
85EXCEEDING_FAREExcess Amount over Lowest Offerdecimal102CURR((0))YesEXCEEDING_FARE
86EXCEEDING_FARE_CCurrency of Excess Amount over Lowest Offernvarchar50CUKY(N' ')Yes*EXCEEDING_FARE_CURR Allow NULL? 
87LOC_BEG_NAMEName of Locationnvarchar1000CHAR(N' ')YesSTATION_LOCATION_NAME Allow NULL? 
88LOC_END_NAMEName of Locationnvarchar1000CHAR(N' ')YesSTATION_LOCATION_NAME Allow NULL? 
NamePrimaryUniqueTypeColumns
FTPT_CAR~0YesYesCLUSTEREDSERVICE, ITEM, VARIANTVRS, VARIANT, PLANNR, REINR, PERNR, MANDT
FTPT_CAR~TMPNoNoNONCLUSTEREDTEMPLATE

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy