SAP ABAP Table FLIGHTB (Flight booking)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-UTL (Application Component) Workbench Utilities
     ⤷ SDW4 (Package) ABAP Workbench Demos

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FLIGHTB	Table Relationship Diagram
Short Description	Flight booking

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	ID	☑	FL_ID	FL_ID	CHAR	5	0	Flight ID	FLIGHTP
2	DAT	☑	FL_DATE	FL_DATE	DATS	8	0	Departure date	FLIGHTP
3	SEATNO	☑	FL_SEATNO	FL_SEATNO	NUMC	3	0	Seat number on airplane
4	FIRSTNAME	☐	FL_FNAME	FL_FNAME	CHAR	15	0	First name
5	LASTNAME	☐	FL_LNAME	FL_LNAME	CHAR	15	0	Last name
6	FL_SMOKER	☐	FL_SMOKER	FL_SMOKER	CHAR	1	0	Smokers
7	CLASSF	☐	FL_CLASSF	FL_CLASS	CHAR	1	0	First class booking
8	CLASSB	☐	FL_CLASSB	FL_CLASS	CHAR	1	0	Business class booking
9	CLASSE	☐	FL_CLASSE	FL_CLASS	CHAR	1	0	Economy class booking
10	MEAL	☐	FL_MEAL	FL_MEAL	CHAR	15	0	Meals on plane
11	SERVICE	☐	FL_SERVICE	FL_SERVICE	CHAR	20	0	Flight services
12	DISCOUT	☐	FL_DISCNT	FL_DISCNT	CHAR	4	0	Discount in price of flight

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FLIGHTB	DAT	FLIGHTP	DAT	KEY	1	CN
2	FLIGHTB	ID	FLIGHTP	ID	KEY	1	CN

History

Last changed by/on	SAP	20020827
SAP Release Created in