SAP ABAP Table SFLVIEW (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SFLVIEW	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	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date
3	DEPTIME	☑	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
4	ARRTIME	☑	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
5	AIRPFROM	☑	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
6	AIRPTO	☑	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
7	CARRID	☑	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code
8	CARRNAME	☑	S_CARRNAME	S_NAME20	CHAR	20	0	Airline name
9	CONNID	☑	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number
10	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
11	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
12	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
13	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	SCURX
14	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type	SAPLANE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SFLVIEW	AIRPFROM	SAIRPORT	ID	REF	1	CN
2	SFLVIEW	AIRPTO	SAIRPORT	ID	REF	1	CN
3	SFLVIEW	CURRENCY	SCURX	CURRKEY	REF	1	N
4	SFLVIEW	MANDT	T000	MANDT	KEY	1	CN
5	SFLVIEW	PLANETYPE	SAPLANE	PLANETYPE	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in