SAP ABAP Table SFLIGHTS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SFLIGHTS	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	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	SGEOCITY
6	CITYFROM	☑	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
7	AIRPFROM	☑	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
8	COUNTRYTO	☑	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
9	CITYTO	☑	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
10	AIRPTO	☑	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
11	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date
12	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
13	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SFLIGHTS	AIRPFROM	SAIRPORT	ID	REF	1	CN
2	SFLIGHTS	AIRPTO	SAIRPORT	ID	REF	1	CN
3	SFLIGHTS	CITYFROM	SGEOCITY	CITY	REF	1	CN
4	SFLIGHTS	CITYTO	SGEOCITY	CITY	REF	1	CN
5	SFLIGHTS	COUNTRYFR	SGEOCITY	COUNTRY	REF	1	CN
6	SFLIGHTS	COUNTRYTO	SGEOCITY	COUNTRY	REF	1	CN
7	SFLIGHTS	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in