ADFSH_FLGTDET is a standard SAP table in SAP ECC (or) S/4HANA which stores Flight Scheduling: Flight Schedule Details data. There are total 86 fields in ADFSH_FLGTDET table.This blog post provides key technical details of SAP table ADFSH_FLGTDET, including its availability across SAP S/4HANA versions and the list of CDS views for ADFSH_FLGTDET table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Flight Scheduling (DDIC) (AD_FSH_DDIC) |
| Technical Component | Industry Solution Automotive (IS-A) |
SAP ADFSH_FLGTDET Table Fields
The following is the list of fields that are available in SAP ADFSH_FLGTDET table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| AIRLN | Flight Scheduling: Airline Code | ADFSH_AIRCODE | ADFSH_AIRCODE | ADFSH_AIRLNCD | CHAR (3) |
| FLTNR | Flight Scheduling: Flight Number | ADFSH_FLTNUM | ADFSH_FLTNUM | CHAR (5) | |
| SECNR | Flight Scheduling: Sector Number | ADFSH_SECNR | ADFSH_SECNR | ADFSH_SECTMAS | CHAR (5) |
| ACDATE | Flight Scheduling: Actual Date of Flight | ADFSH_ACDATE | ADFSH_ACDATE | DATS (8) | |
| DELFLG | Flight Scheduling: Flag for deletion | ADFSH_DELFLAG | XFELD | CHAR (1) | |
| FLTYP | Flight Scheduling: Flight Route | ADFSH_FLTYP | ADFSH_FLTYP | ADFSH_FLGTTYP | CHAR (1) |
| FLPAX | Flight Scheduling: Flight Type | ADFSH_FLTYPX | ADFSH_FLTYPX | ADFSH_FLGTPAX | CHAR (1) |
| ACFTYP | Flight Scheduling: Planned IATA Aircraft Type | ADFSH_PLACTYP | ADFSH_ACTYP | ADFSH_ACFTYP | CHAR (5) |
| STACD | Flight Scheduling: Flight Status Code | ADFSH_STACD | ADFSH_STACD | ADFSH_FLGTSTAT | CHAR (1) |
| TPLNR | Flight Scheduling: Actual Aircraft Registration | ADFSH_ACTPLNR | TPLNR | CHAR (30) | |
| PLDPAPT | Flight Scheduling: Planned Departure Airport | ADFSH_PLDPAPT | ADFSH_APTCD | ADFSH_APTMAS | CHAR (5) |
| PLARAPT | Flight Scheduling: Planned Arrival Airport | ADFSH_PLARAPT | ADFSH_APTCD | ADFSH_APTMAS | CHAR (5) |
| PLDPTML | Flight Scheduling: Planned Departure Terminal | ADFSH_PLDPTML | ADFSH_TMLNR | ADFSH_TERMAS | CHAR (5) |
| PLARTML | Flight Scheduling: Planned Arrival Terminal | ADFSH_PLARTML | ADFSH_TMLNR | ADFSH_TERMAS | CHAR (5) |
| PLDPBAY | Flight Scheduling: Planned Departure Bay | ADFSH_PLDPBAY | ADFSH_BAYNR | ADFSH_BAYMAS | CHAR (5) |
| PLARBAY | Flight Scheduling: Planned Arrival Bay | ADFSH_PLARBAY | ADFSH_BAYNR | ADFSH_BAYMAS | CHAR (5) |
| PLDPTM | Flight Scheduling: Planned Departure Time | ADFSH_DEPTM | ADFSH_DEPTM | TIMS (6) | |
| PLARTM | Flight Scheduling: Planned Arrival Time | ADFSH_ARRTM | ADFSH_ARRTM | TIMS (6) | |
| FLDUR | Flight Scheduling: Flight Duration | ADFSH_FLDUR | ADFSH_FLDUR | QUAN (4) | |
| DURUT | Flight Scheduling: Unit of Time | ADFSH_TMUNIT | MEINS | UNIT (3) | |
| FLDIS | Flight Scheduling: Flight Distance | ADFSH_FLDIS | ADFSH_FLDIS | QUAN (5) | |
| DISUT | Flight Scheduling: Unit of Distance | ADFSH_DISUT | MEINS | UNIT (3) | |
| ACDPAPT | Flight Scheduling: Actual Departure Airport | ADFSH_ACDPAPT | ADFSH_APTCD | ADFSH_APTMAS | CHAR (5) |
| ACDPTML | Flight Scheduling: Actual Departure Terminal | ADFSH_ACDPTML | ADFSH_TMLNR | ADFSH_TERMAS | CHAR (5) |
| ACDPBAY | Flight Scheduling: Actual Departure Bay | ADFSH_ACDPBAY | ADFSH_BAYNR | ADFSH_BAYMAS | CHAR (5) |
| ACBELT | Flight Scheduling: Actual Cargo Belt | ADFSH_ACBELT | ADFSH_ACBELT | CHAR (2) | |
| RVDPTM | Flight Scheduling: Revised Departure Time | ADFSH_RVDPTM | ADFSH_DEPTM | TIMS (6) | |
| ESDPTM | Flight Scheduling: Estimated Departure Time | ADFSH_ESDPTM | ADFSH_DEPTM | TIMS (6) | |
| LTDPTM | Flight Scheduling: Latest Departure Time | ADFSH_LTDPTM | ADFSH_DEPTM | TIMS (6) | |
| ACDPTM | Flight Scheduling: Actual Departure Time | ADFSH_ACDPTM | ADFSH_DEPTM | TIMS (6) | |
| ARBTM | Flight Scheduling: Airborne Time | ADFSH_ARBTM | ADFSH_ARBTM | TIMS (6) | |
| ACARAPT | Flight Scheduling: Actual Arrival Airport | ADFSH_ACARAPT | ADFSH_APTCD | CHAR (5) | |
| ACARTML | Flight Scheduling: Actual Arrival Terminal | ADFSH_ACARTML | ADFSH_TMLNR | CHAR (5) | |
| ACARBAY | Flight Scheduling: Actual Arrival Bay | ADFSH_ACARBAY | ADFSH_BAYNR | CHAR (5) | |
| OFPLARDT | Flight Scheduling: Offset For Planned Arrival Date | ADFSH_OFPLARDT | ADFSH_OFFDATE | CHAR (1) | |
| RVARTM | Flight Scheduling: Revised Arrival Time | ADFSH_RVARTM | ADFSH_ARRTM | TIMS (6) | |
| OFRVARDT | Flight Scheduling: Offset For Revised Arrival Date | ADFSH_OFRVARDT | ADFSH_OFFDATE | CHAR (1) | |
| ESARTM | Flight Scheduling: Estimated Arrival Time | ADFSH_ESARTM | ADFSH_ARRTM | TIMS (6) | |
| OFESARDT | Flight Scheduling: Offset For Estimated Arrival Date | ADFSH_OFESARDT | ADFSH_OFFDATE | CHAR (1) | |
| LTARTM | Flight Scheduling: Latest Arrival Time | ADFSH_LTARTM | ADFSH_ARRTM | TIMS (6) | |
| OFLTARDT | Flight Scheduling: Offset For Latest Arrival Date | ADFSH_OFLTARDT | ADFSH_OFFDATE | CHAR (1) | |
| ACARTM | Flight Scheduling: Actual Arrival Time | ADFSH_ACARTM | ADFSH_ARRTM | TIMS (6) | |
| OFACARDT | Flight Scheduling: Offset For Actual Arrival Date | ADFSH_OFACARDT | ADFSH_OFFDATE | CHAR (1) | |
| LANTM | Flight Scheduling: Landing Time | ADFSH_LANTM | ADFSH_LANTM | TIMS (6) | |
| FMODE | Flight Scheduling: Mode of Operation | ADFSH_MODEOP | ADFSH_MODEOP | CHAR (1) | |
| AFSHP | Flight Scheduling: Inflight Shop | ADFSH_AFSHP | ADFSH_AFSHP | CHAR (1) | |
| AAUVI | Flight Scheduling: Audio Visual Devices Available | ADFSH_AAUVI | ADFSH_AAUVI | CHAR (1) | |
| ASPML | Flight Scheduling: Special Meals Served | ADFSH_ASPML | ADFSH_ASPML | CHAR (1) | |
| AMNML | Flight Scheduling: Main Meals Served | ADFSH_AMNML | ADFSH_AMNML | CHAR (1) | |
| ACDML | Flight Scheduling: Cold Meal Served | ADFSH_ACDML | ADFSH_ACDML | CHAR (1) | |
| ABFST | Flight Scheduling: Breakfast Served | ADFSH_ABFST | ADFSH_ABFST | CHAR (1) | |
| ASNCK | Flight Scheduling: Snacks Served | ADFSH_ASNCK | ADFSH_ASNCK | CHAR (1) | |
| ARMNT | Flight Scheduling: Refreshments Served | ADFSH_ARMNT | ADFSH_ARMNT | CHAR (1) | |
| AISDP | Flight Scheduling: ISD Telephone Facility | ADFSH_AISDP | ADFSH_AISDP | CHAR (1) | |
| AHZRD | Flight Scheduling: Hazardous Goods Allowed | ADFSH_AHZRD | ADFSH_AHZRD | CHAR (1) | |
| ACDST | Flight Scheduling: Cold Storage | ADFSH_ACDST | ADFSH_ACDST | CHAR (1) | |
| ATOPS | Flight Scheduling: Total Number of Passengers | ADFSH_ATOPS | ADFSH_ATOPS | NUMC (3) | |
| APRTRN | Flight Scheduling: Total Number of Passengers in Transit | ADFSH_APRTRN | ADFSH_ATOPS | NUMC (3) | |
| AMNOR | Flight Scheduling: Number of Unaccompanied Minors | ADFSH_AMNOR | ADFSH_ATOPS | NUMC (3) | |
| ACRWT | Flight Scheduling: Weight of Cargo | ADFSH_ACRWT | ADFSH_ACRWT | QUAN (5) | |
| CARUT | Flight Scheduling: Unit of Cargo Weight | ADFSH_CARUT | ADFSH_CARUT | UNIT (3) | |
| AWLCH | Flight Scheduling: Number of Wheelchairs required | ADFSH_AWLCH | ADFSH_AWLCH | NUMC (3) | |
| OBJNR | Object number | J_OBJNR | J_OBJNR | CHAR (22) | |
| REVNR | Revision for Plant Maintenance and Customer Service | REVNI | REVNI | CHAR (8) | |
| CREATED_BY | Name of Person who Created the Object | ERNAM | USNAM | CHAR (12) | |
| CREATED_DT | Created on | ADFSH_CDATE | DATUM | DATS (8) | |
| LASTCHGDBY | Last Changed By | UPNAM | USNAM | CHAR (12) | |
| LASTCHGDDT | Date of Last Change | AEDAT | DATUM | DATS (8) | |
| FLGCON | Flight Schduling : Flight Connect | ADFSH_FLCON | ADFSH_FLCON | CHAR (10) | |
| PLDPDAT | Flight Schduling : Planned Departure Date | ADFSH_PLDDATE | ADFSH_ACDATE | DATS (8) | |
| ESDPDAT | Flight Schduling : Estimated Departure Date | ADFSH_ESDDATE | ADFSH_ACDATE | DATS (8) | |
| RVDPDAT | Flight Schduling : Revised Departure Date | ADFSH_RVDDATE | ADFSH_ACDATE | DATS (8) | |
| LTDPDAT | Flight Schduling : Latest Departure Date | ADFSH_LTDDATE | ADFSH_ACDATE | DATS (8) | |
| ACDPDAT | Flight Schduling : Actual Departure Date | ADFSH_ACDDATE | ADFSH_ACDATE | DATS (8) | |
| ARBDAT | Flight Schduling : Airborne Date | ADFSH_ARBDATE | ADFSH_ACDATE | DATS (8) | |
| PLARDAT | Flight Schduling : Planned Arrival Date | ADFSH_PLADATE | ADFSH_ACDATE | DATS (8) | |
| ESARDAT | Flight Schduling : Estimated Arrival Date | ADFSH_ESADATE | ADFSH_ACDATE | DATS (8) | |
| RVARDAT | Flight Schduling : Revised Arrival Date | ADFSH_RVADATE | ADFSH_ACDATE | DATS (8) | |
| LTARDAT | Flight Schduling : Latest Arrival Date | ADFSH_LTADATE | ADFSH_ACDATE | DATS (8) | |
| ACARDAT | Flight Schduling : Actual Arrival Date | ADFSH_ACADATE | ADFSH_ACDATE | DATS (8) | |
| LANDAT | Flight Schduling : Landing Date | ADFSH_LANDATE | ADFSH_ACDATE | DATS (8) | |
| ADBRKLDG | Flight Schduling : Number Of Additional Brake Landings | ADFSH_ADBRKLDG | ADFSH_LANDGS | NUMC (2) | |
| AUPLTLDG | Flight Schduling : Number Of Auto Pilot Landings | ADFSH_AUPLTLDG | ADFSH_LANDGS | NUMC (2) | |
| NRMLDG | Flight Schduling : Number Of Normal Landings | ADFSH_NRMLDG | ADFSH_LANDGS | NUMC (2) | |
| TOUCHNGO | Flight Schduling : Number Of Landings | ADFSH_TOUCHNGO | ADFSH_LANDGS | NUMC (2) |
Availability
The SAP table ADFSH_FLGTDET is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ADFSH_FLGTDET table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
