SAP ADFSH_FLGTDET Flight Scheduling: Flight Schedule Details Table
Overview
ADFSH_FLGTDET is a standard SAP S/4HANA table that stores Flight Scheduling: Flight Schedule Details data. There are total 86 fields in the ADFSH_FLGTDET table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ADFSH_FLGTDET belongs to Industry Solution Automotive (IS-A) module and is located in the package Flight Scheduling (DDIC) (AD_FSH_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link ADFSH_FLGTDET to other SAP tables and standard CDS views available based on ADFSH_FLGTDET table in S/4HANA 2020.
Techincal Settings of ADFSH_FLGTDET
Below are technical details of the table ADFSH_FLGTDET
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ADFSH_FLGTDET Fields
The following table gives you an overview of the fields available in ADFSH_FLGTDET
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AIRLN | Flight Scheduling: Airline Code | ADFSH_AIRCODE | ADFSH_AIRLNCD | CHAR | 3 |
| FLTNR | Flight Scheduling: Flight Number | ADFSH_FLTNUM | CHAR | 5 | |
| SECNR | Flight Scheduling: Sector Number | ADFSH_SECNR | ADFSH_SECTMAS | CHAR | 5 |
| ACDATE | Flight Scheduling: Actual Date of Flight | ADFSH_ACDATE | DATS | 8 | |
| DELFLG | Flight Scheduling: Flag for deletion | ADFSH_DELFLAG | CHAR | 1 | |
| FLTYP | Flight Scheduling: Flight Route | ADFSH_FLTYP | ADFSH_FLGTTYP | CHAR | 1 |
| FLPAX | Flight Scheduling: Flight Type | ADFSH_FLTYPX | ADFSH_FLGTPAX | CHAR | 1 |
| ACFTYP | Flight Scheduling: Planned IATA Aircraft Type | ADFSH_PLACTYP | ADFSH_ACFTYP | CHAR | 5 |
| STACD | Flight Scheduling: Flight Status Code | ADFSH_STACD | ADFSH_FLGTSTAT | CHAR | 1 |
| TPLNR | Flight Scheduling: Actual Aircraft Registration | ADFSH_ACTPLNR | CHAR | 30 | |
| PLDPAPT | Flight Scheduling: Planned Departure Airport | ADFSH_PLDPAPT | ADFSH_APTMAS | CHAR | 5 |
| PLARAPT | Flight Scheduling: Planned Arrival Airport | ADFSH_PLARAPT | ADFSH_APTMAS | CHAR | 5 |
| PLDPTML | Flight Scheduling: Planned Departure Terminal | ADFSH_PLDPTML | ADFSH_TERMAS | CHAR | 5 |
| PLARTML | Flight Scheduling: Planned Arrival Terminal | ADFSH_PLARTML | ADFSH_TERMAS | CHAR | 5 |
| PLDPBAY | Flight Scheduling: Planned Departure Bay | ADFSH_PLDPBAY | ADFSH_BAYMAS | CHAR | 5 |
| PLARBAY | Flight Scheduling: Planned Arrival Bay | ADFSH_PLARBAY | ADFSH_BAYMAS | CHAR | 5 |
| PLDPTM | Flight Scheduling: Planned Departure Time | ADFSH_DEPTM | TIMS | 6 | |
| PLARTM | Flight Scheduling: Planned Arrival Time | ADFSH_ARRTM | TIMS | 6 | |
| FLDUR | Flight Scheduling: Flight Duration | ADFSH_FLDUR | QUAN | 4 | |
| DURUT | Flight Scheduling: Unit of Time | ADFSH_TMUNIT | UNIT | 3 | |
| FLDIS | Flight Scheduling: Flight Distance | ADFSH_FLDIS | QUAN | 5 | |
| DISUT | Flight Scheduling: Unit of Distance | ADFSH_DISUT | UNIT | 3 | |
| ACDPAPT | Flight Scheduling: Actual Departure Airport | ADFSH_ACDPAPT | ADFSH_APTMAS | CHAR | 5 |
| ACDPTML | Flight Scheduling: Actual Departure Terminal | ADFSH_ACDPTML | ADFSH_TERMAS | CHAR | 5 |
| ACDPBAY | Flight Scheduling: Actual Departure Bay | ADFSH_ACDPBAY | ADFSH_BAYMAS | CHAR | 5 |
| ACBELT | Flight Scheduling: Actual Cargo Belt | ADFSH_ACBELT | CHAR | 2 | |
| RVDPTM | Flight Scheduling: Revised Departure Time | ADFSH_RVDPTM | TIMS | 6 | |
| ESDPTM | Flight Scheduling: Estimated Departure Time | ADFSH_ESDPTM | TIMS | 6 | |
| LTDPTM | Flight Scheduling: Latest Departure Time | ADFSH_LTDPTM | TIMS | 6 | |
| ACDPTM | Flight Scheduling: Actual Departure Time | ADFSH_ACDPTM | TIMS | 6 | |
| ARBTM | Flight Scheduling: Airborne Time | ADFSH_ARBTM | TIMS | 6 | |
| ACARAPT | Flight Scheduling: Actual Arrival Airport | ADFSH_ACARAPT | CHAR | 5 | |
| ACARTML | Flight Scheduling: Actual Arrival Terminal | ADFSH_ACARTML | CHAR | 5 | |
| ACARBAY | Flight Scheduling: Actual Arrival Bay | ADFSH_ACARBAY | CHAR | 5 | |
| OFPLARDT | Flight Scheduling: Offset For Planned Arrival Date | ADFSH_OFPLARDT | CHAR | 1 | |
| RVARTM | Flight Scheduling: Revised Arrival Time | ADFSH_RVARTM | TIMS | 6 | |
| OFRVARDT | Flight Scheduling: Offset For Revised Arrival Date | ADFSH_OFRVARDT | CHAR | 1 | |
| ESARTM | Flight Scheduling: Estimated Arrival Time | ADFSH_ESARTM | TIMS | 6 | |
| OFESARDT | Flight Scheduling: Offset For Estimated Arrival Date | ADFSH_OFESARDT | CHAR | 1 | |
| LTARTM | Flight Scheduling: Latest Arrival Time | ADFSH_LTARTM | TIMS | 6 | |
| OFLTARDT | Flight Scheduling: Offset For Latest Arrival Date | ADFSH_OFLTARDT | CHAR | 1 | |
| ACARTM | Flight Scheduling: Actual Arrival Time | ADFSH_ACARTM | TIMS | 6 | |
| OFACARDT | Flight Scheduling: Offset For Actual Arrival Date | ADFSH_OFACARDT | CHAR | 1 | |
| LANTM | Flight Scheduling: Landing Time | ADFSH_LANTM | TIMS | 6 | |
| FMODE | Flight Scheduling: Mode of Operation | ADFSH_MODEOP | CHAR | 1 | |
| AFSHP | Flight Scheduling: Inflight Shop | ADFSH_AFSHP | CHAR | 1 | |
| AAUVI | Flight Scheduling: Audio Visual Devices Available | ADFSH_AAUVI | CHAR | 1 | |
| ASPML | Flight Scheduling: Special Meals Served | ADFSH_ASPML | CHAR | 1 | |
| AMNML | Flight Scheduling: Main Meals Served | ADFSH_AMNML | CHAR | 1 | |
| ACDML | Flight Scheduling: Cold Meal Served | ADFSH_ACDML | CHAR | 1 | |
| ABFST | Flight Scheduling: Breakfast Served | ADFSH_ABFST | CHAR | 1 | |
| ASNCK | Flight Scheduling: Snacks Served | ADFSH_ASNCK | CHAR | 1 | |
| ARMNT | Flight Scheduling: Refreshments Served | ADFSH_ARMNT | CHAR | 1 | |
| AISDP | Flight Scheduling: ISD Telephone Facility | ADFSH_AISDP | CHAR | 1 | |
| AHZRD | Flight Scheduling: Hazardous Goods Allowed | ADFSH_AHZRD | CHAR | 1 | |
| ACDST | Flight Scheduling: Cold Storage | ADFSH_ACDST | CHAR | 1 | |
| ATOPS | Flight Scheduling: Total Number of Passengers | ADFSH_ATOPS | NUMC | 3 | |
| APRTRN | Flight Scheduling: Total Number of Passengers in Transit | ADFSH_APRTRN | NUMC | 3 | |
| AMNOR | Flight Scheduling: Number of Unaccompanied Minors | ADFSH_AMNOR | NUMC | 3 | |
| ACRWT | Flight Scheduling: Weight of Cargo | ADFSH_ACRWT | QUAN | 5 | |
| CARUT | Flight Scheduling: Unit of Cargo Weight | ADFSH_CARUT | UNIT | 3 | |
| AWLCH | Flight Scheduling: Number of Wheelchairs required | ADFSH_AWLCH | NUMC | 3 | |
| OBJNR | Object number | J_OBJNR | CHAR | 22 | |
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | CHAR | 8 | |
| CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| CREATED_DT | Created on | ADFSH_CDATE | DATS | 8 | |
| LASTCHGDBY | Last Changed By | UPNAM | CHAR | 12 | |
| LASTCHGDDT | Date of Last Change | AEDAT | DATS | 8 | |
| FLGCON | Flight Schduling : Flight Connect | ADFSH_FLCON | CHAR | 10 | |
| PLDPDAT | Flight Schduling : Planned Departure Date | ADFSH_PLDDATE | DATS | 8 | |
| ESDPDAT | Flight Schduling : Estimated Departure Date | ADFSH_ESDDATE | DATS | 8 | |
| RVDPDAT | Flight Schduling : Revised Departure Date | ADFSH_RVDDATE | DATS | 8 | |
| LTDPDAT | Flight Schduling : Latest Departure Date | ADFSH_LTDDATE | DATS | 8 | |
| ACDPDAT | Flight Schduling : Actual Departure Date | ADFSH_ACDDATE | DATS | 8 | |
| ARBDAT | Flight Schduling : Airborne Date | ADFSH_ARBDATE | DATS | 8 | |
| PLARDAT | Flight Schduling : Planned Arrival Date | ADFSH_PLADATE | DATS | 8 | |
| ESARDAT | Flight Schduling : Estimated Arrival Date | ADFSH_ESADATE | DATS | 8 | |
| RVARDAT | Flight Schduling : Revised Arrival Date | ADFSH_RVADATE | DATS | 8 | |
| LTARDAT | Flight Schduling : Latest Arrival Date | ADFSH_LTADATE | DATS | 8 | |
| ACARDAT | Flight Schduling : Actual Arrival Date | ADFSH_ACADATE | DATS | 8 | |
| LANDAT | Flight Schduling : Landing Date | ADFSH_LANDATE | DATS | 8 | |
| ADBRKLDG | Flight Schduling : Number Of Additional Brake Landings | ADFSH_ADBRKLDG | NUMC | 2 | |
| AUPLTLDG | Flight Schduling : Number Of Auto Pilot Landings | ADFSH_AUPLTLDG | NUMC | 2 | |
| NRMLDG | Flight Schduling : Number Of Normal Landings | ADFSH_NRMLDG | NUMC | 2 | |
| TOUCHNGO | Flight Schduling : Number Of Landings | ADFSH_TOUCHNGO | NUMC | 2 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ADFSH_FLGTDET
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ADFSH_FLGTDET | ACDPAPT | 1: CN | ADFSH_APTMAS |
| ADFSH_FLGTDET | ACDPBAY | 1: CN | ADFSH_BAYMAS |
| ADFSH_FLGTDET | ACDPTML | 1: CN | ADFSH_TERMAS |
| ADFSH_FLGTDET | ACFTYP | 1: CN | ADFSH_ACFTYP |
| ADFSH_FLGTDET | AIRLN | 1: CN | ADFSH_AIRLNCD |
| ADFSH_FLGTDET | FLPAX | 1: CN | ADFSH_FLGTPAX |
| ADFSH_FLGTDET | FLTYP | 1: CN | ADFSH_FLGTTYP |
| ADFSH_FLGTDET | MANDT | 1: CN | T000 |
| ADFSH_FLGTDET | PLARAPT | 1: CN | ADFSH_APTMAS |
| ADFSH_FLGTDET | PLARBAY | 1: CN | ADFSH_BAYMAS |
| ADFSH_FLGTDET | PLARTML | 1: CN | ADFSH_TERMAS |
| ADFSH_FLGTDET | PLDPAPT | 1: CN | ADFSH_APTMAS |
| ADFSH_FLGTDET | PLDPBAY | 1: CN | ADFSH_BAYMAS |
| ADFSH_FLGTDET | PLDPTML | 1: CN | ADFSH_TERMAS |
| ADFSH_FLGTDET | SECNR | 1: CN | ADFSH_SECTMAS |
| ADFSH_FLGTDET | STACD | 1: CN | ADFSH_FLGTSTAT |