SAP ABAP Table ADFSH_FLGTSTRUC (Flight Scheduling: Flight Structure)

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	INTTAB	Structure
Structure	ADFSH_FLGTSTRUC	Table Relationship Diagram
Short Description	Flight Scheduling: Flight Structure

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
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	ARCATDES	☐	ADFSH_ARCATDES	CHAR30	CHAR	30	0	Flight Scheduling: Aircraft Category Description
40	ACTYDES	☐	ADFSH_ACTYDES	CHAR30	CHAR	30	0	Flight Scheduling: IATA Aircraft Type Description
41	ACCDDES	☐	ADFSH_ACCDDES	CHAR30	CHAR	30	0	Flight Scheduling: ICAO Aircraft Code Description
42	AIRLNDESCP	☐	ADFSH_AIRCODEDES	CHAR30	CHAR	30	0	Flight Scheduling: Airline Description
43	DEPAPTDEC	☐	ADFSH_APTDES	CHAR60	CHAR	60	0	Flight Scheduling: Airport Description
44	ARRAPTDEC	☐	ADFSH_APTDES	CHAR60	CHAR	60	0	Flight Scheduling: Airport Description
45	DEPBAYDES	☐	ADFSH_BAYDES	CHAR30	CHAR	30	0	Flight Scheduling: Bay Description
46	ARRBAYDES	☐	ADFSH_BAYDES	CHAR30	CHAR	30	0	Flight Scheduling: Bay Description
47	FLCATDES	☐	ADFSH_FLCATDES	CHAR30	CHAR	30	0	Flight Scheduling: Flight Category Description
48	FLTFRQDESCP	☐	ADFSH_FRQDES	CHAR30	CHAR	30	0	Flight Scheduling: Flight Frequency
49	FLTYPDES	☐	ADFSH_TYPXDES	CHAR30	CHAR	30	0	Flight Scheduling: Description of Flight Type
50	STATDESCP	☐	ADFSH_STADES	CHAR30	CHAR	30	0	Flight Scheduling: Description of Flight Status
51	FLRTDES	☐	ADFSH_TYPDES	CHAR30	CHAR	30	0	Flight Scheduling: Description of Flight Type
52	MODEDES	☐	ADFSH_MODEDES	CHAR30	CHAR	30	0	Flight Scheduling: Mode of Operation Description
53	SECDESCP	☐	ADFSH_SECDES	CHAR30	CHAR	30	0	Flight Scheduling: Description of Sector
54	DEPTMLDES	☐	ADFSH_TMLDES	CHAR30	CHAR	30	0	Flight Scheduling: Terminal Description
55	ARRTMLDES	☐	ADFSH_TMLDES	CHAR30	CHAR	30	0	Flight Scheduling: Terminal Description
56	PLDPAPT	☐	ADFSH_PLDPAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Planned Departure Airport
57	PLDPTML	☐	ADFSH_PLDPTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Planned Departure Terminal
58	PLDPBAY	☐	ADFSH_PLDPBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Planned Departure Bay
59	PLARAPT	☐	ADFSH_PLARAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Planned Arrival Airport
60	PLARTML	☐	ADFSH_PLARTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Planned Arrival Terminal
61	PLARBAY	☐	ADFSH_PLARBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Planned Arrival Bay
62	PLDPAPTDES	☐	ADFSH_APTDES	CHAR60	CHAR	60	0	Flight Scheduling: Airport Description
63	PLARAPTDES	☐	ADFSH_APTDES	CHAR60	CHAR	60	0	Flight Scheduling: Airport Description
64	PLDPTMLDES	☐	ADFSH_TMLDES	CHAR30	CHAR	30	0	Flight Scheduling: Terminal Description
65	PLARTMLDES	☐	ADFSH_TMLDES	CHAR30	CHAR	30	0	Flight Scheduling: Terminal Description
66	PLDPBAYDES	☐	ADFSH_BAYDES	CHAR30	CHAR	30	0	Flight Scheduling: Bay Description
67	PLARBAYDES	☐	ADFSH_BAYDES	CHAR30	CHAR	30	0	Flight Scheduling: Bay Description
68	ACDPAPT	☐	ADFSH_ACDPAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Actual Departure Airport
69	ACDPTML	☐	ADFSH_ACDPTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Actual Departure Terminal
70	ACDPBAY	☐	ADFSH_ACDPBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Actual Departure Bay
71	ACARAPT	☐	ADFSH_ACARAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Actual Arrival Airport
72	ACARTML	☐	ADFSH_ACARTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Actual Arrival Terminal
73	ACARBAY	☐	ADFSH_ACARBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Actual Arrival Bay
74	ACDPAPTDES	☐	ADFSH_APTDES	CHAR60	CHAR	60	0	Flight Scheduling: Airport Description
75	ACARAPTDES	☐	ADFSH_APTDES	CHAR60	CHAR	60	0	Flight Scheduling: Airport Description
76	ACDPTMLDES	☐	ADFSH_TMLDES	CHAR30	CHAR	30	0	Flight Scheduling: Terminal Description
77	ACARTMLDES	☐	ADFSH_TMLDES	CHAR30	CHAR	30	0	Flight Scheduling: Terminal Description
78	ACDPBAYDES	☐	ADFSH_BAYDES	CHAR30	CHAR	30	0	Flight Scheduling: Bay Description
79	ACARBAYDES	☐	ADFSH_BAYDES	CHAR30	CHAR	30	0	Flight Scheduling: Bay Description
80	ACDATE	☐	ADFSH_ACDATE	ADFSH_ACDATE	DATS	8	0	Flight Scheduling: Actual Date of Flight
81	PLARTM	☐	ADFSH_ARRTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Planned Arrival Time
82	PLDPTM	☐	ADFSH_DEPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Planned Departure Time
83	ACBELT	☐	ADFSH_ACBELT	ADFSH_ACBELT	CHAR	2	0	Flight Scheduling: Actual Cargo Belt
84	RVDPTM	☐	ADFSH_RVDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Revised Departure Time
85	ESDPTM	☐	ADFSH_ESDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Estimated Departure Time
86	LTDPTM	☐	ADFSH_LTDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Latest Departure Time
87	ACDPTM	☐	ADFSH_ACDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Actual Departure Time
88	ARBTM	☐	ADFSH_ARBTM	ADFSH_ARBTM	TIMS	6	0	Flight Scheduling: Airborne Time
89	OFPLARDT	☐	ADFSH_OFPLARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Planned Arrival Date
90	RVARTM	☐	ADFSH_RVARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Revised Arrival Time
91	OFRVARDT	☐	ADFSH_OFRVARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Revised Arrival Date
92	ESARTM	☐	ADFSH_ESARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Estimated Arrival Time
93	OFESARDT	☐	ADFSH_OFESARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Estimated Arrival Date
94	LTARTM	☐	ADFSH_LTARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Latest Arrival Time
95	OFLTARDT	☐	ADFSH_OFLTARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Latest Arrival Date
96	ACARTM	☐	ADFSH_ACARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Actual Arrival Time
97	OFACARDT	☐	ADFSH_OFACARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Actual Arrival Date
98	LANTM	☐	ADFSH_LANTM	ADFSH_LANTM	TIMS	6	0	Flight Scheduling: Landing Time
99	FMODE	☐	ADFSH_MODEOP	ADFSH_MODEOP	CHAR	1	0	Flight Scheduling: Mode of Operation
100	AFSHP	☐	ADFSH_AFSHP	ADFSH_AFSHP	CHAR	1	0	Flight Scheduling: Inflight Shop
101	AAUVI	☐	ADFSH_AAUVI	ADFSH_AAUVI	CHAR	1	0	Flight Scheduling: Audio Visual Devices Available
102	ASPML	☐	ADFSH_ASPML	ADFSH_ASPML	CHAR	1	0	Flight Scheduling: Special Meals Served
103	AMNML	☐	ADFSH_AMNML	ADFSH_AMNML	CHAR	1	0	Flight Scheduling: Main Meals Served
104	ACDML	☐	ADFSH_ACDML	ADFSH_ACDML	CHAR	1	0	Flight Scheduling: Cold Meal Served
105	ABFST	☐	ADFSH_ABFST	ADFSH_ABFST	CHAR	1	0	Flight Scheduling: Breakfast Served
106	ASNCK	☐	ADFSH_ASNCK	ADFSH_ASNCK	CHAR	1	0	Flight Scheduling: Snacks Served
107	ARMNT	☐	ADFSH_ARMNT	ADFSH_ARMNT	CHAR	1	0	Flight Scheduling: Refreshments Served
108	AISDP	☐	ADFSH_AISDP	ADFSH_AISDP	CHAR	1	0	Flight Scheduling: ISD Telephone Facility
109	AHZRD	☐	ADFSH_AHZRD	ADFSH_AHZRD	CHAR	1	0	Flight Scheduling: Hazardous Goods Allowed
110	ACDST	☐	ADFSH_ACDST	ADFSH_ACDST	CHAR	1	0	Flight Scheduling: Cold Storage
111	ATOPS	☐	ADFSH_ATOPS	ADFSH_ATOPS	NUMC	3	0	Flight Scheduling: Total Number of Passengers
112	APRTRN	☐	ADFSH_APRTRN	ADFSH_ATOPS	NUMC	3	0	Flight Scheduling: Total Number of Passengers in Transit
113	AMNOR	☐	ADFSH_AMNOR	ADFSH_ATOPS	NUMC	3	0	Flight Scheduling: Number of Unaccompanied Minors
114	ACRWT	☐	ADFSH_ACRWT	ADFSH_ACRWT	QUAN	5	0	Flight Scheduling: Weight of Cargo
115	CARUT	☐	ADFSH_CARUT	ADFSH_CARUT	UNIT	3	0	Flight Scheduling: Unit of Cargo Weight
116	AWLCH	☐	ADFSH_AWLCH	ADFSH_AWLCH	NUMC	3	0	Flight Scheduling: Number of Wheelchairs required
117	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	*
118	.INCLUDE	☐				0	0	Departures and Arrival Dates
119	PLDPDAT	☐	ADFSH_PLDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Planned Departure Date
120	ESDPDAT	☐	ADFSH_ESDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Estimated Departure Date
121	RVDPDAT	☐	ADFSH_RVDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Revised Departure Date
122	LTDPDAT	☐	ADFSH_LTDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Latest Departure Date
123	ACDPDAT	☐	ADFSH_ACDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Actual Departure Date
124	ARBDAT	☐	ADFSH_ARBDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Airborne Date
125	PLARDAT	☐	ADFSH_PLADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Planned Arrival Date
126	ESARDAT	☐	ADFSH_ESADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Estimated Arrival Date
127	RVARDAT	☐	ADFSH_RVADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Revised Arrival Date
128	LTARDAT	☐	ADFSH_LTADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Latest Arrival Date
129	ACARDAT	☐	ADFSH_ACADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Actual Arrival Date
130	LANDAT	☐	ADFSH_LANDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Landing Date
131	.INCLUDE	☐				0	0	Flight Connector Number
132	FLGCON	☐	ADFSH_FLCON	ADFSH_FLCON	CHAR	10	0	Flight Schduling : Flight Connector Number
133	.INCLUDE	☐				0	0	Flight Schduling : Number Of Landings
134	ADBRKLDG	☐	ADFSH_ADBRKLDG	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Additional Brake Landings
135	AUPLTLDG	☐	ADFSH_AUPLTLDG	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Auto Pilot Landings
136	NRMLDG	☐	ADFSH_NRMLDG	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Normal Landings
137	TOUCHNGO	☐	ADFSH_TOUCHNGO	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Touch-And-Gos

Foreign Keys

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

History

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