SAP ABAP Table SXIDEMO_SFLIGHT2 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SXIDEMO_SFLIGHT2	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	CLIENT	☑	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	SPFLI
5	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date
6	SEATSMAX_E	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
7	SEATSOCC_E	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
8	SEATSMAX_B	☐	S_SMAX_B	S_SEATS	INT4	10	0	Maximum capacity in business class
9	SEATSOCC_B	☐	S_SOCC_B	S_SEATS	INT4	10	0	Occupied seats in business class
10	SEATSMAX_F	☐	S_SMAX_F	S_SEATS	INT4	10	0	Maximum capacity in first class
11	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	SXIDEMO_SFLIGHT2	CLIENT	T000	MANDT	KEY	1	CN
2	SXIDEMO_SFLIGHT2	CONNID	SPFLI	CONNID	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in