SAP ABAP Table SXIDEMO_SFLIGHT1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SXIDEMO_SFLIGHT1	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
5	FLDATE	☑	S_DATE	S_DATE	DATS	8	0	Flight date
6	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
7	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
8	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
9	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
10	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
11	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	SGEOCITY
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	PERIOD	☐	S_PERIOD	INT1	INT1	3	0	Arrival n day(s) later
15	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	SXIDEMO_SFLIGHT1	AIRPFROM	SAIRPORT	ID	REF	1	CN
2	SXIDEMO_SFLIGHT1	AIRPTO	SAIRPORT	ID	REF	1	CN
3	SXIDEMO_SFLIGHT1	CITYFROM	SGEOCITY	CITY	REF	1	CN
4	SXIDEMO_SFLIGHT1	CITYTO	SGEOCITY	CITY	REF	1	CN
5	SXIDEMO_SFLIGHT1	CLIENT	T000	MANDT	KEY	1	CN
6	SXIDEMO_SFLIGHT1	COUNTRYFR	SGEOCITY	COUNTRY	REF	1	CN
7	SXIDEMO_SFLIGHT1	COUNTRYTO	SGEOCITY	COUNTRY	REF	1	CN
8	SXIDEMO_SFLIGHT1	PLANETYPE	SAPLANE	PLANETYPE	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in