SAP ABAP Table SCOL_REF_FLIGHT_CACHE (<cool> Reference Flight Example: Cache)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-ESI-ESF (Application Component) Enterprise Service Framework Layer
     ⤷ SCOOL (Package) Enterprise Services Framework

Basic Data

Table Category	INTTAB	Structure
Structure	SCOL_REF_FLIGHT_CACHE	Table Relationship Diagram
Short Description	<cool> Reference Flight Example: Cache

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	.INCLUDE	☐				0	0	Detail Structure for BO SFLIGHT
2	.INCLUDE	☐				0	0	Flight Key
3	CARRID	☐	S_CARR_ID	S_CARR_ID	CHAR	3	0	Airline Code	*
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	CARRNAME	☐	S_CARRNAME	S_NAME20	CHAR	20	0	Airline name
7	CITYFROM	☐	S_FROM_CIT	S_CITY	CHAR	20	0	Departure city	*
8	AIRPFROM	☐	S_FROMAIRP	S_AIRPID	CHAR	3	0	Departure airport	*
9	COUNTRYFR	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
10	CITYTO	☐	S_TO_CITY	S_CITY	CHAR	20	0	Arrival city	SGEOCITY
11	AIRPTO	☐	S_TOAIRP	S_AIRPID	CHAR	3	0	Destination airport	*
12	COUNTRYTO	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
13	DEPTIME	☐	S_DEP_TIME	S_TIME	TIMS	6	0	Departure time
14	FLTIME	☐	S_FLTIME	S_DURA	INT4	10	0	Flight time
15	ARRTIME	☐	S_ARR_TIME	S_TIME	TIMS	6	0	Arrival time
16	PERIOD	☐	S_PERIOD	INT1	INT1	3	0	Arrival n day(s) later
17	DISTANCE	☐	S_DISTANCE	S_DISTANCE	QUAN	9	4	Distance
18	DISTID	☐	S_DISTID	MEINS	UNIT	3	0	Mass unit of distance (kms, miles)	*
19	FLTYPE	☐	S_FLTYPE	S_FLTYPE	CHAR	1	0	Flight type
20	PRICE	☐	S_PRICE	S_PRICE	CURR	15	2	Airfare
21	CURRENCY	☐	S_CURRCODE	S_CURR	CUKY	5	0	Local currency of airline	*
22	PLANETYPE	☐	S_PLANETYE	S_PLANE	CHAR	10	0	Aircraft Type	*
23	UPDATE_FLAG	☐	CHAR01	CHAR1	CHAR	1	0	Character Field Length 1
24	ENQUEUE_STATE	☐	SCOL_LOCKMODE	SCOL_LOCKMODE	CHAR	2	0	ESF Lock Mode

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SCOL_REF_FLIGHT_CACHE	CITYTO	SGEOCITY	CITY

History

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