SAP ABAP Table ADFSH_FLGTDET (Flight Scheduling: Flight Schedule Details)

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_FLGTDET	Table Relationship Diagram
Short Description	Flight Scheduling: Flight Schedule Details

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	ACDATE	☑	ADFSH_ACDATE	ADFSH_ACDATE	DATS	8	0	Flight Scheduling: Actual Date of Flight
6	DELFLG	☐	ADFSH_DELFLAG	XFELD	CHAR	1	0	Flight Scheduling: Flag for deletion
7	FLTYP	☐	ADFSH_FLTYP	ADFSH_FLTYP	CHAR	1	0	Flight Scheduling: Flight Route	ADFSH_FLGTTYP
8	FLPAX	☐	ADFSH_FLTYPX	ADFSH_FLTYPX	CHAR	1	0	Flight Scheduling: Flight Type	ADFSH_FLGTPAX
9	ACFTYP	☐	ADFSH_PLACTYP	ADFSH_ACTYP	CHAR	5	0	Flight Scheduling: Planned IATA Aircraft Type	ADFSH_ACFTYP
10	STACD	☐	ADFSH_STACD	ADFSH_STACD	CHAR	1	0	Flight Scheduling: Flight Status Code	ADFSH_FLGTSTAT
11	TPLNR	☐	ADFSH_ACTPLNR	TPLNR	CHAR	30	0	Flight Scheduling: Actual Aircraft Registration	*
12	PLDPAPT	☐	ADFSH_PLDPAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Planned Departure Airport	ADFSH_APTMAS
13	PLARAPT	☐	ADFSH_PLARAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Planned Arrival Airport	ADFSH_APTMAS
14	PLDPTML	☐	ADFSH_PLDPTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Planned Departure Terminal	ADFSH_TERMAS
15	PLARTML	☐	ADFSH_PLARTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Planned Arrival Terminal	ADFSH_TERMAS
16	PLDPBAY	☐	ADFSH_PLDPBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Planned Departure Bay	ADFSH_BAYMAS
17	PLARBAY	☐	ADFSH_PLARBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Planned Arrival Bay	ADFSH_BAYMAS
18	PLDPTM	☐	ADFSH_DEPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Planned Departure Time
19	PLARTM	☐	ADFSH_ARRTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Planned Arrival Time
20	FLDUR	☐	ADFSH_FLDUR	ADFSH_FLDUR	QUAN	4	2	Flight Scheduling: Flight Duration
21	DURUT	☐	ADFSH_TMUNIT	MEINS	UNIT	3	0	Flight Scheduling: Unit of Time	*
22	FLDIS	☐	ADFSH_FLDIS	ADFSH_FLDIS	QUAN	5	0	Flight Scheduling: Flight Distance
23	DISUT	☐	ADFSH_DISUT	MEINS	UNIT	3	0	Flight Scheduling: Unit of Distance	*
24	ACDPAPT	☐	ADFSH_ACDPAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Actual Departure Airport	ADFSH_APTMAS
25	ACDPTML	☐	ADFSH_ACDPTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Actual Departure Terminal	ADFSH_TERMAS
26	ACDPBAY	☐	ADFSH_ACDPBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Actual Departure Bay	ADFSH_BAYMAS
27	ACBELT	☐	ADFSH_ACBELT	ADFSH_ACBELT	CHAR	2	0	Flight Scheduling: Actual Cargo Belt
28	RVDPTM	☐	ADFSH_RVDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Revised Departure Time
29	ESDPTM	☐	ADFSH_ESDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Estimated Departure Time
30	LTDPTM	☐	ADFSH_LTDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Latest Departure Time
31	ACDPTM	☐	ADFSH_ACDPTM	ADFSH_DEPTM	TIMS	6	0	Flight Scheduling: Actual Departure Time
32	ARBTM	☐	ADFSH_ARBTM	ADFSH_ARBTM	TIMS	6	0	Flight Scheduling: Airborne Time
33	ACARAPT	☐	ADFSH_ACARAPT	ADFSH_APTCD	CHAR	5	0	Flight Scheduling: Actual Arrival Airport	ADFSH_APTMAS
34	ACARTML	☐	ADFSH_ACARTML	ADFSH_TMLNR	CHAR	5	0	Flight Scheduling: Actual Arrival Terminal	ADFSH_TERMAS
35	ACARBAY	☐	ADFSH_ACARBAY	ADFSH_BAYNR	CHAR	5	0	Flight Scheduling: Actual Arrival Bay	ADFSH_BAYMAS
36	OFPLARDT	☐	ADFSH_OFPLARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Planned Arrival Date
37	RVARTM	☐	ADFSH_RVARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Revised Arrival Time
38	OFRVARDT	☐	ADFSH_OFRVARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Revised Arrival Date
39	ESARTM	☐	ADFSH_ESARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Estimated Arrival Time
40	OFESARDT	☐	ADFSH_OFESARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Estimated Arrival Date
41	LTARTM	☐	ADFSH_LTARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Latest Arrival Time
42	OFLTARDT	☐	ADFSH_OFLTARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Latest Arrival Date
43	ACARTM	☐	ADFSH_ACARTM	ADFSH_ARRTM	TIMS	6	0	Flight Scheduling: Actual Arrival Time
44	OFACARDT	☐	ADFSH_OFACARDT	ADFSH_OFFDATE	CHAR	1	0	Flight Scheduling: Offset For Actual Arrival Date
45	LANTM	☐	ADFSH_LANTM	ADFSH_LANTM	TIMS	6	0	Flight Scheduling: Landing Time
46	FMODE	☐	ADFSH_MODEOP	ADFSH_MODEOP	CHAR	1	0	Flight Scheduling: Mode of Operation
47	AFSHP	☐	ADFSH_AFSHP	ADFSH_AFSHP	CHAR	1	0	Flight Scheduling: Inflight Shop
48	AAUVI	☐	ADFSH_AAUVI	ADFSH_AAUVI	CHAR	1	0	Flight Scheduling: Audio Visual Devices Available
49	ASPML	☐	ADFSH_ASPML	ADFSH_ASPML	CHAR	1	0	Flight Scheduling: Special Meals Served
50	AMNML	☐	ADFSH_AMNML	ADFSH_AMNML	CHAR	1	0	Flight Scheduling: Main Meals Served
51	ACDML	☐	ADFSH_ACDML	ADFSH_ACDML	CHAR	1	0	Flight Scheduling: Cold Meal Served
52	ABFST	☐	ADFSH_ABFST	ADFSH_ABFST	CHAR	1	0	Flight Scheduling: Breakfast Served
53	ASNCK	☐	ADFSH_ASNCK	ADFSH_ASNCK	CHAR	1	0	Flight Scheduling: Snacks Served
54	ARMNT	☐	ADFSH_ARMNT	ADFSH_ARMNT	CHAR	1	0	Flight Scheduling: Refreshments Served
55	AISDP	☐	ADFSH_AISDP	ADFSH_AISDP	CHAR	1	0	Flight Scheduling: ISD Telephone Facility
56	AHZRD	☐	ADFSH_AHZRD	ADFSH_AHZRD	CHAR	1	0	Flight Scheduling: Hazardous Goods Allowed
57	ACDST	☐	ADFSH_ACDST	ADFSH_ACDST	CHAR	1	0	Flight Scheduling: Cold Storage
58	ATOPS	☐	ADFSH_ATOPS	ADFSH_ATOPS	NUMC	3	0	Flight Scheduling: Total Number of Passengers
59	APRTRN	☐	ADFSH_APRTRN	ADFSH_ATOPS	NUMC	3	0	Flight Scheduling: Total Number of Passengers in Transit
60	AMNOR	☐	ADFSH_AMNOR	ADFSH_ATOPS	NUMC	3	0	Flight Scheduling: Number of Unaccompanied Minors
61	ACRWT	☐	ADFSH_ACRWT	ADFSH_ACRWT	QUAN	5	0	Flight Scheduling: Weight of Cargo
62	CARUT	☐	ADFSH_CARUT	ADFSH_CARUT	UNIT	3	0	Flight Scheduling: Unit of Cargo Weight
63	AWLCH	☐	ADFSH_AWLCH	ADFSH_AWLCH	NUMC	3	0	Flight Scheduling: Number of Wheelchairs required
64	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
65	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	*
66	.INCLUDE	☐				0	0	Flight Scheduling: Structure for tracking Created By/Changed
67	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
68	CREATED_DT	☐	ADFSH_CDATE	DATUM	DATS	8	0	Created on
69	LASTCHGDBY	☐	UPNAM	USNAM	CHAR	12	0	Last Changed By
70	LASTCHGDDT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
71	.INCLUDE	☐				0	0	Flight Connector Number
72	FLGCON	☐	ADFSH_FLCON	ADFSH_FLCON	CHAR	10	0	Flight Schduling : Flight Connector Number
73	.INCLUDE	☐				0	0	Departures and Arrival Dates
74	PLDPDAT	☐	ADFSH_PLDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Planned Departure Date
75	ESDPDAT	☐	ADFSH_ESDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Estimated Departure Date
76	RVDPDAT	☐	ADFSH_RVDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Revised Departure Date
77	LTDPDAT	☐	ADFSH_LTDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Latest Departure Date
78	ACDPDAT	☐	ADFSH_ACDDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Actual Departure Date
79	ARBDAT	☐	ADFSH_ARBDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Airborne Date
80	PLARDAT	☐	ADFSH_PLADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Planned Arrival Date
81	ESARDAT	☐	ADFSH_ESADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Estimated Arrival Date
82	RVARDAT	☐	ADFSH_RVADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Revised Arrival Date
83	LTARDAT	☐	ADFSH_LTADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Latest Arrival Date
84	ACARDAT	☐	ADFSH_ACADATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Actual Arrival Date
85	LANDAT	☐	ADFSH_LANDATE	ADFSH_ACDATE	DATS	8	0	Flight Schduling : Landing Date
86	.INCLUDE	☐				0	0	Flight Schduling : Number Of Landings
87	ADBRKLDG	☐	ADFSH_ADBRKLDG	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Additional Brake Landings
88	AUPLTLDG	☐	ADFSH_AUPLTLDG	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Auto Pilot Landings
89	NRMLDG	☐	ADFSH_NRMLDG	ADFSH_LANDGS	NUMC	2	0	Flight Schduling : Number Of Normal Landings
90	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_FLGTDET	ACARAPT	ADFSH_APTMAS	APTCD	KEY	1	CN
2	ADFSH_FLGTDET	ACARBAY	ADFSH_BAYMAS	BAYNR	KEY	1	CN
3	ADFSH_FLGTDET	ACARTML	ADFSH_TERMAS	TMLNR	KEY	1	CN
4	ADFSH_FLGTDET	ACDPAPT	ADFSH_APTMAS	APTCD	KEY	1	CN
5	ADFSH_FLGTDET	ACDPBAY	ADFSH_BAYMAS	BAYNR	KEY	1	CN
6	ADFSH_FLGTDET	ACDPTML	ADFSH_TERMAS	TMLNR	KEY	1	CN
7	ADFSH_FLGTDET	ACFTYP	ADFSH_ACFTYP	ACFTYP	KEY	1	CN
8	ADFSH_FLGTDET	AIRLN	ADFSH_AIRLNCD	AIRLN	KEY	1	CN
9	ADFSH_FLGTDET	FLPAX	ADFSH_FLGTPAX	FLTYP	KEY	1	CN
10	ADFSH_FLGTDET	FLTYP	ADFSH_FLGTTYP	FLTYP	KEY	1	CN
11	ADFSH_FLGTDET	MANDT	T000	MANDT	KEY	1	CN
12	ADFSH_FLGTDET	PLARAPT	ADFSH_APTMAS	APTCD	KEY	1	CN
13	ADFSH_FLGTDET	PLARBAY	ADFSH_BAYMAS	BAYNR	KEY	1	CN
14	ADFSH_FLGTDET	PLARTML	ADFSH_TERMAS	TMLNR	KEY	1	CN
15	ADFSH_FLGTDET	PLDPAPT	ADFSH_APTMAS	APTCD	KEY	1	CN
16	ADFSH_FLGTDET	PLDPBAY	ADFSH_BAYMAS	BAYNR	KEY	1	CN
17	ADFSH_FLGTDET	PLDPTML	ADFSH_TERMAS	TMLNR	KEY	1	CN
18	ADFSH_FLGTDET	SECNR	ADFSH_SECTMAS	SECNR	KEY	1	CN
19	ADFSH_FLGTDET	STACD	ADFSH_FLGTSTAT	STACD	KEY	1	CN

History

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