SAP ABAP Table LOYC_ADM_FLT_SGT (Table to store Flight Segment details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-MA (Application Component) Member Activity
     ⤷ LOY_ADMIN_DATA_DB (Package) Loyalty Admin Data DB

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	LOYC_ADM_FLT_SGT	Table Relationship Diagram
Short Description	Table to store Flight Segment details

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	AIRLINE_ID	☑	LOY_ADM_AIRLINE_CODE	LOY_ADM_AIRLINE_ID	CHAR	3	0	ICAO Code of the Airline	LOYC_ADM_AL_CD
3	ORIG_AIRPORT	☑	LOY_ADM_ORIG_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Origin Airport	LOYC_ADM_ARPT_CD
4	DEST_AIRPORT	☑	LOY_ADM_DEST_AIRPORT	LOY_ADM_AIRPORT_ID	CHAR	4	0	ICAO Code of the Destination Airport	LOYC_ADM_ARPT_CD
5	BASE_MILES	☐	LOY_ADM_BASE_MILES	LOY_ADM_BASE_MILES	DEC	11	2	Base Miles for the flight segment
6	CATEGORY	☐	LOY_ADM_FLIGHT_CAT	CHAR4	CHAR	4	0	Flight Category ID	LOYC_ADM_FLT_CAT

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LOYC_ADM_FLT_SGT	AIRLINE_ID	LOYC_ADM_AL_CD	AIRLINE_ID	KEY	1	CN
2	LOYC_ADM_FLT_SGT	CATEGORY	LOYC_ADM_FLT_CAT	FLIGHT_CAT	KEY	1	CN
3	LOYC_ADM_FLT_SGT	DEST_AIRPORT	LOYC_ADM_ARPT_CD	AIRPORT_ID	KEY	1	CN
4	LOYC_ADM_FLT_SGT	ORIG_AIRPORT	LOYC_ADM_ARPT_CD	AIRPORT_ID	KEY	1	CN

History

Last changed by/on	SAP	20100420
SAP Release Created in	700