SAP ABAP Table SFLIGHTS2 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SFLIGHTS2	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
2	CARRID	☑	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code
3	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number
4	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date
5	CARRNAME	☐	S_CARRNAME	S_NAME20	CHAR	20	0	Airline name
6	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
7	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
8	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
9	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
10	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
11	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
12	FLTIME	☐	S_FLTIME	S_DURA	INT4	10	0	Flight time
13	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
14	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
15	DISTANCE	☐	S_DISTANCE	S_DISTANCE	QUAN	9	4	Distance
16	DISTID	☐	S_DISTID	MEINS	UNIT	3	0	Mass unit of distance (kms, miles)
17	FLTYPE	☐	S_FLTYPE	S_FLTYPE	CHAR	1	0	Flight type
18	PERIOD	☐	S_PERIOD	INT1	INT1	3	0	Arrival n day(s) later
19	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
20	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	SCURX
21	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type	SAPLANE
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	SEATSMAX_B	☐	S_SMAX_B	S_SEATS	INT4	10	0	Maximum capacity in business class
26	SEATSOCC_B	☐	S_SOCC_B	S_SEATS	INT4	10	0	Occupied seats in business class
27	SEATSMAX_F	☐	S_SMAX_F	S_SEATS	INT4	10	0	Maximum capacity in first class
28	SEATSOCC_F	☐	S_SOCC_F	S_SEATS	INT4	10	0	Occupied seats in first class

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SFLIGHTS2	AIRPFROM	SAIRPORT	ID	REF	1	CN
2	SFLIGHTS2	AIRPTO	SAIRPORT	ID	REF	1	CN
3	SFLIGHTS2	CITYFROM	SGEOCITY	CITY	REF	1	CN
4	SFLIGHTS2	CITYTO	SGEOCITY	CITY	REF	1	CN
5	SFLIGHTS2	COUNTRYFR	SGEOCITY	COUNTRY	REF	1	CN
6	SFLIGHTS2	COUNTRYTO	SGEOCITY	COUNTRY	REF	1	CN
7	SFLIGHTS2	CURRENCY	SCURX	CURRKEY	REF	1	N
8	SFLIGHTS2	MANDT	T000	MANDT	KEY	1	CN
9	SFLIGHTS2	PLANETYPE	SAPLANE	PLANETYPE	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in