SAP ABAP Table SBOOK_T (Combining SCARR, SPFLI, SFLIGHT and SBOOK)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB (Application Component) ABAP Workbench, Java IDE and Infrastructure
     ⤷ SAPBC_GLOBAL (Package) SAP Training: Objects for Multiple Course Use

Basic Data

Table Category	INTTAB	Structure
Structure	SBOOK_T	Table Relationship Diagram
Short Description	Combining SCARR, SPFLI, SFLIGHT and SBOOK

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	MANDT	☑	S_MANDT	MANDT	CLNT	3	0	Client	*
2	CARRID	☑	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	*
3	CARRNAME	☐	S_CARRNAME	S_NAME20	CHAR	20	0	Airline name
4	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	*
5	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
6	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	*
7	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	*
8	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
9	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	*
10	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	*
11	FLTIME	☐	S_FLTIME	S_DURA	INT4	10	0	Flight time
12	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
13	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
14	DISTANCE	☐	S_DISTANCE	S_DISTANCE	QUAN	9	4	Distance
15	DISTID	☐	S_DISTID	MEINS	UNIT	3	0	Mass unit of distance (kms, miles)	*
16	FLTYPE	☐	S_FLTYPE	S_FLTYPE	CHAR	1	0	Flight type
17	CURRCODE	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	*
18	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date	*
19	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
20	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	*
21	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type	*
22	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
23	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
24	PAYMENTSUM	☐	S_SUM	S_SUM	CURR	17	2	Total of current bookings
25	BOOKID	☑	S_BOOK_ID	S_BOOK_ID	NUMC	8	0	Booking number
26	CUSTOMID	☑	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number	*
27	CUSTTYPE	☐	S_CUSTTYPE	S_CUSTTYPE	CHAR	1	0	Customer type
28	SMOKER	☐	S_SMOKER	S_SMOKER	CHAR	1	0	Smoker
29	LUGGWEIGHT	☐	S_LUGWEIGH	S_LUGWEIGH	QUAN	8	4	Weight of Luggage
30	WUNIT	☐	S_WEIUNIT	MEINS	UNIT	3	0	Weight Unit	*
31	INVOICE	☐	S_INVFLAG	S_FLAG	CHAR	1	0	Invoice flag
32	CLASS	☐	S_CLASS	S_CLASS	CHAR	1	0	Flight Class
33	FORCURAM	☐	S_F_CUR_PR	S_PRICE	CURR	15	2	Booking price in foreign currency (dependent on location)
34	FORCURKEY	☐	S_CURR	S_CURR	CUKY	5	0	Payment currency	*
35	LOCCURAM	☐	S_L_CUR_PR	S_PRICE	CURR	15	2	Price of booking in local currency of airline
36	LOCCURKEY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	*
37	ORDER_DATE	☐	S_BDATE	S_BDATE	DATS	8	0	Booking Date
38	COUNTER	☐	S_COUNTNUM	S_COUNTNUM	NUMC	8	0	Number of sales office	*
39	AGENCYNUM	☐	S_AGNCYNUM	S_BUSPANUM	NUMC	8	0	Travel Agency Number	*
40	CANCELLED	☐	S_CANCEL	S_CANCEL	CHAR	1	0	Cancelation flag

History

Last changed by/on	SAP	20130604
SAP Release Created in