SAP ABAP Table SMT_TEST_S_SBOOK (Flight booking infomation (flat))

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-SOA-SMT (Application Component) Service Mapping Tool
     ⤷ GMT_TEST_CONFIGURATION (Package) self tests

Basic Data

Table Category	INTTAB	Structure
Structure	SMT_TEST_S_SBOOK	Table Relationship Diagram
Short Description	Flight booking infomation (flat)

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	AIRLINE	☐	SCARR		STRU	0	0
2	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client
3	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code
4	CARRNAME	☐	S_CARRNAME	S_NAME20	CHAR	20	0	Airline name
5	CURRCODE	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline
6	URL	☐	S_CARRURL	S_URL	CHAR	255	0	Airline URL
7	SCHEDULE	☐	SPFLI		STRU	0	0
8	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client
9	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code
10	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number
11	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key
12	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city
13	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport
14	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key
15	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city
16	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport
17	FLTIME	☐	S_FLTIME	S_DURA	INT4	10	0	Flight time
18	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
19	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
20	DISTANCE	☐	S_DISTANCE	S_DISTANCE	QUAN	9	4	Distance
21	DISTID	☐	S_DISTID	MEINS	UNIT	3	0	Mass unit of distance (kms, miles)
22	FLTYPE	☐	S_FLTYPE	S_FLTYPE	CHAR	1	0	Flight type
23	PERIOD	☐	S_PERIOD	INT1	INT1	3	0	Arrival n day(s) later
24	FLIGHT	☐	SFLIGHT		STRU	0	0
25	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client
26	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code
27	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number
28	FLDATE	☐	S_DATE	S_DATE	DATS	8	0	Flight date
29	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
30	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline
31	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type
32	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
33	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
34	PAYMENTSUM	☐	S_SUM	S_SUM	CURR	17	2	Total of current bookings
35	SEATSMAX_B	☐	S_SMAX_B	S_SEATS	INT4	10	0	Maximum capacity in business class
36	SEATSOCC_B	☐	S_SOCC_B	S_SEATS	INT4	10	0	Occupied seats in business class
37	SEATSMAX_F	☐	S_SMAX_F	S_SEATS	INT4	10	0	Maximum capacity in first class
38	SEATSOCC_F	☐	S_SOCC_F	S_SEATS	INT4	10	0	Occupied seats in first class
39	BOOKING	☐	SBOOK		STRU	0	0
40	MANDT	☐	S_MANDT	MANDT	CLNT	3	0	Client
41	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code
42	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number
43	FLDATE	☐	S_DATE	S_DATE	DATS	8	0	Flight date
44	BOOKID	☐	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number
45	CUSTOMID	☐	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number
46	CUSTTYPE	☐	S_CUSTTYPE	S_CUSTTYPE	CHAR	1	0	Customer type
47	SMOKER	☐	S_SMOKER	S_SMOKER	CHAR	1	0	Smoker
48	LUGGWEIGHT	☐	S_LUGWEIGH	S_LUGWEIGH	QUAN	8	4	Weight of Luggage
49	WUNIT	☐	S_WEIUNIT	MEINS	UNIT	3	0	Weight Unit
50	INVOICE	☐	S_INVFLAG	S_FLAG	CHAR	1	0	Invoice flag
51	CLASS	☐	S_CLASS	S_CLASS	CHAR	1	0	Flight Class
52	FORCURAM	☐	S_F_CUR_PR	S_PRICE	CURR	15	2	Booking price in foreign currency (dependent on location)
53	FORCURKEY	☐	S_CURR	S_CURR	CUKY	5	0	Payment currency
54	LOCCURAM	☐	S_L_CUR_PR	S_PRICE	CURR	15	2	Price of booking in local currency of airline
55	LOCCURKEY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline
56	ORDER_DATE	☐	S_BDATE	S_BDATE	DATS	8	0	Booking Date
57	COUNTER	☐	S_COUNTNUM	S_COUNTNUM	NUMC	8	0	Number of sales office
58	AGENCYNUM	☐	S_AGNCYNUM	S_BUSPANUM	NUMC	8	0	Travel Agency Number
59	CANCELLED	☐	S_CANCEL	S_CANCEL	CHAR	1	0	Cancelation flag
60	RESERVED	☐	S_RESERV	S_RESERV	CHAR	1	0	Reservation flag
61	PASSNAME	☐	S_PASSNAME	S_CUSTNAME	CHAR	25	0	Name of the Passenger
62	PASSFORM	☐	S_FORM	S_TEXT15	CHAR	15	0	Form of address
63	PASSBIRTH	☐	S_BIRTHDAT	S_DATE	DATS	8	0	Date of Birth of a Passenger

History

Last changed by/on	SAP	20130604
SAP Release Created in	701