SAP ABAP Table ADFSH_FLGTMAS (Flight Scheduling: Flight Schedule Master)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PLM-LBK (Application Component) Logbook
     ⤷ AD_FSH_DDIC (Package) Flight Scheduling (DDIC)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ADFSH_FLGTMAS	Table Relationship Diagram
Short Description	Flight Scheduling: Flight Schedule Master

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AIRLN	☑	ADFSH_AIRCODE	ADFSH_AIRCODE	CHAR	3	0	Flight Scheduling: Airline Code	ADFSH_AIRLNCD
3	FLTNR	☑	ADFSH_FLTNUM	ADFSH_FLTNUM	CHAR	5	0	Flight Scheduling: Flight Number
4	SECNR	☑	ADFSH_SECNR	ADFSH_SECNR	CHAR	5	0	Flight Scheduling: Sector Number	ADFSH_SECTMAS
5	SEQNR	☑	ADFSH_SEQNR	ADFSH_SEQNR	NUMC	10	0	Flight Scheduling: Flight Sequence Number
6	PVLFR	☐	ADFSH_PVLFR	ADFSH_PVLFR	DATS	8	0	Flight Scheduling: Schedule Valid From Date
7	PVLTO	☐	ADFSH_PVLTO	ADFSH_PVLTO	DATS	8	0	Flight Scheduling: Schedule Valid To Date
8	DELFLG	☐	ADFSH_DELFLAG	XFELD	CHAR	1	0	Flight Scheduling: Flag for deletion
9	FLTOP	☐	ADFSH_OPDAY	ADFSH_OPDAY	CHAR	7	0	Flight Scheduling: Days of Operation
10	FLTFRQ	☐	ADFSH_FLTFRQ	ADFSH_FLTFRQ	CHAR	1	0	Flight Scheduling: Flight Frequency
11	FLTYP	☐	ADFSH_FLTYP	ADFSH_FLTYP	CHAR	1	0	Flight Scheduling: Flight Route	ADFSH_FLGTTYP
12	FLPAX	☐	ADFSH_FLTYPX	ADFSH_FLTYPX	CHAR	1	0	Flight Scheduling: Flight Type	ADFSH_FLGTPAX
13	FLCAT	☐	ADFSH_FLCAT	ADFSH_FLCAT	CHAR	1	0	Flight Scheduling: Flight Category	ADFSH_FLGTCAT
14	STACD	☐	ADFSH_STACD	ADFSH_STACD	CHAR	1	0	Flight Scheduling: Flight Status Code	ADFSH_FLGTSTAT
15	ETOPS	☐	ADFSH_ETOPS	ADFSH_ETOPS	CHAR	1	0	Flight Scheduling: ETOPS Indicator
16	FLDUR	☐	ADFSH_FLDUR	ADFSH_FLDUR	QUAN	4	2	Flight Scheduling: Flight Duration
17	DURUT	☐	ADFSH_TMUNIT	MEINS	UNIT	3	0	Flight Scheduling: Unit of Time	T006
18	FLDIS	☐	ADFSH_FLDIS	ADFSH_FLDIS	QUAN	5	0	Flight Scheduling: Flight Distance
19	DISUT	☐	ADFSH_DISUT	MEINS	UNIT	3	0	Flight Scheduling: Unit of Distance	T006
20	ACFTYP	☐	ADFSH_PLACTYP	ADFSH_ACTYP	CHAR	5	0	Flight Scheduling: Planned IATA Aircraft Type	ADFSH_ACFTYP
21	MATNR	☐	ADFSH_ARCONF	MATNR	CHAR	18	0	Flight Scheduling: Required Aircraft Configuration Data	*
22	TPLNR	☐	ADFSH_PLTPLNR	TPLNR	CHAR	30	0	Flight Scheduling: Planned Aircraft Registration	*
23	CLASS1	☐	ADFSH_CLASS	ADFSH_CLASS	CHAR	1	0	Flight Scheduling: Class in a flight
24	CLSPX1	☐	ADFSH_CLASPX	ADFSH_CLASPX	NUMC	4	0	Flight Scheduling: Passengers in a class
25	CLASS2	☐	ADFSH_CLASS	ADFSH_CLASS	CHAR	1	0	Flight Scheduling: Class in a flight
26	CLSPX2	☐	ADFSH_CLASPX	ADFSH_CLASPX	NUMC	4	0	Flight Scheduling: Passengers in a class
27	CLASS3	☐	ADFSH_CLASS	ADFSH_CLASS	CHAR	1	0	Flight Scheduling: Class in a flight
28	CLSPX3	☐	ADFSH_CLASPX	ADFSH_CLASPX	NUMC	4	0	Flight Scheduling: Passengers in a class
29	CABCW	☐	ADFSH_CABCW	ADFSH_CABCW	NUMC	2	0	Flight Scheduling: Planned Number of Cabin Crew
30	TECCW	☐	ADFSH_TECCW	ADFSH_TECCW	NUMC	2	0	Flight Scheduling: Planned Number of Technical Crew
31	DEPAPT	☐	ADFSH_PLDPAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Planned Departure Airport	ADFSH_APTMAS
32	DEPTML	☐	ADFSH_PLDPTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Planned Departure Terminal	ADFSH_TERMAS
33	DEPBAY	☐	ADFSH_PLDPBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Planned Departure Bay	ADFSH_BAYMAS
34	DEPTM	☐	ADFSH_DEPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Planned Departure Time
35	ARRAPT	☐	ADFSH_PLARAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Planned Arrival Airport	ADFSH_APTMAS
36	ARRTML	☐	ADFSH_PLARTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Planned Arrival Terminal	ADFSH_TERMAS
37	ARRBAY	☐	ADFSH_PLARBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Planned Arrival Bay	ADFSH_BAYMAS
38	ARRTM	☐	ADFSH_ARRTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Planned Arrival Time
39	OFPLARDT	☐	ADFSH_OFPLARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Planned Arrival Date
40	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
41	.INCLUDE	☐				0	0	Flight Scheduling: Structure for tracking Created By/Changed
42	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
43	CREATED_DT	☐	ADFSH_CDATE	DATUM	DATS	8	0	Created on
44	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
45	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ADFSH_FLGTMAS	ACFTYP	ADFSH_ACFTYP	ACFTYP	KEY	1	CN
2	ADFSH_FLGTMAS	AIRLN	ADFSH_AIRLNCD	AIRLN	KEY	1	CN
3	ADFSH_FLGTMAS	ARRAPT	ADFSH_APTMAS	APTCD	KEY	1	CN
4	ADFSH_FLGTMAS	ARRBAY	ADFSH_BAYMAS	BAYNR	KEY	1	CN
5	ADFSH_FLGTMAS	ARRTML	ADFSH_TERMAS	TMLNR
6	ADFSH_FLGTMAS	DEPAPT	ADFSH_APTMAS	APTCD
7	ADFSH_FLGTMAS	DEPBAY	ADFSH_BAYMAS	BAYNR	KEY	1	CN
8	ADFSH_FLGTMAS	DEPTML	ADFSH_TERMAS	TMLNR	KEY	1	CN
9	ADFSH_FLGTMAS	DISUT	T006	MSEHI	KEY	1	CN
10	ADFSH_FLGTMAS	DURUT	T006	MSEHI	KEY	1	CN
11	ADFSH_FLGTMAS	FLCAT	ADFSH_FLGTCAT	FLCAT	KEY	1	CN
12	ADFSH_FLGTMAS	FLPAX	ADFSH_FLGTPAX	FLTYP	KEY	1	CN
13	ADFSH_FLGTMAS	FLTYP	ADFSH_FLGTTYP	FLTYP	KEY	1	CN
14	ADFSH_FLGTMAS	MANDT	T000	MANDT	KEY	1	CN
15	ADFSH_FLGTMAS	SECNR	ADFSH_SECTMAS	SECNR	KEY	1	CN
16	ADFSH_FLGTMAS	STACD	ADFSH_FLGTSTAT	STACD	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in	46C2