SAP ABAP Table BRF_FLIGHT_INFO (Flight information)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ BC-SRV-BRF (Application Component) Business Rule Framework
     ⤷ BRF_EXAMPLES (Package) Examples for Application of BRF

Basic Data

Table Category	INTTAB	Structure
Structure	BRF_FLIGHT_INFO	Table Relationship Diagram
Short Description	Flight information

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	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	SCARR
2	CARRNAME	☐	S_CARRNAME	S_NAME20	CHAR	20	0	Airline name
3	CONNID	☐	S_CONN_ID	S_CONN_ID	NUMC	4	0	Flight Connection Number	SPFLI
4	FLDATE	☐	S_DATE	S_DATE	DATS	8	0	Flight date	*
5	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
6	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
7	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
8	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	SCURX
9	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	SGEOCITY
11	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	SAIRPORT
12	AIRPFROM_NAME	☐	S_AIRPNAME	S_AIRPNAME	CHAR	25	0	Airport name
13	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
15	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	SAIRPORT
16	AIRPTO_NAME	☐	S_AIRPNAME	S_AIRPNAME	CHAR	25	0	Airport name
17	SEATSMAX	☐	S_SEATSMAX	S_SEATS	INT4	10	0	Maximum capacity in economy class
18	SEATSOCC	☐	S_SEATSOCC	S_SEATS	INT4	10	0	Occupied seats in economy class
19	SEATSMAX_B	☐	S_SMAX_B	S_SEATS	INT4	10	0	Maximum capacity in business class
20	SEATSOCC_B	☐	S_SOCC_B	S_SEATS	INT4	10	0	Occupied seats in business class
21	SEATSMAX_F	☐	S_SMAX_F	S_SEATS	INT4	10	0	Maximum capacity in first class
22	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	BRF_FLIGHT_INFO	AIRPFROM	SAIRPORT	ID	KEY	1	CN
2	BRF_FLIGHT_INFO	AIRPTO	SAIRPORT	ID	KEY	1	CN
3	BRF_FLIGHT_INFO	CARRID	SCARR	CARRID	KEY	1	CN
4	BRF_FLIGHT_INFO	CITYFROM	SGEOCITY	CITY	KEY	1	CN
5	BRF_FLIGHT_INFO	CITYTO	SGEOCITY	CITY	KEY	1	CN
6	BRF_FLIGHT_INFO	CONNID	SPFLI	CONNID	KEY	1	CN
7	BRF_FLIGHT_INFO	COUNTRYFR	T005	LAND1	KEY	1	CN
8	BRF_FLIGHT_INFO	COUNTRYTO	T005	LAND1	KEY	1	CN
9	BRF_FLIGHT_INFO	CURRENCY	SCURX	CURRKEY	KEY		CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	471