SAP ADFSH_CODESHR Flight Scheduling: Code share master Table data and field list

ADFSH_CODESHR is a standard SAP Table which is used to store Flight Scheduling: Code share master data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ADFSH_CODESHR table consists of various fields, each holding specific information or linking keys about Flight Scheduling: Code share master data available in SAP. These include SHRNR (Flight Scheduling: Code Share Number), AIRLN (Flight Scheduling: Airline Code), FLTNR (Flight Scheduling: Flight Number), SECNR (Flight Scheduling: Sector Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ADFSH_CODESHR table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP ADFSH_CODESHR table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ADFSH_CODESHR table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
SHRNRFlight Scheduling: Code Share Number ADFSH_SHRNRNUMC3ADFSH_SHRNR
AIRLNFlight Scheduling: Airline Code ADFSH_AIRCODECHAR3ADFSH_AIRCODE
FLTNRFlight Scheduling: Flight Number ADFSH_FLTNUMCHAR5ADFSH_FLTNUM
SECNRFlight Scheduling: Sector Number ADFSH_SECNRCHAR5ADFSH_SECNR
SEQNRFlight Scheduling: Flight Sequence Number ADFSH_SEQNRNUMC10ADFSH_SEQNR
PVLFRFlight Scheduling: Schedule Valid From Date ADFSH_PVLFRDATS8ADFSH_PVLFR
PVLTOFlight Scheduling: Schedule Valid To Date ADFSH_PVLTODATS8ADFSH_PVLTO
CSAIRLNFlight Scheduling: Airline Code ADFSH_AIRCODECHAR3ADFSH_AIRCODE
CSFLTNRFlight Scheduling: Flight Number ADFSH_FLTNUMCHAR5ADFSH_FLTNUM
CSSECNRFlight Scheduling: Sector Number ADFSH_SECNRCHAR5ADFSH_SECNR

Key field Non-key field



How do I retrieve data from SAP table ADFSH_CODESHR using ABAP code

The following ABAP code Example will allow you to do a basic selection on ADFSH_CODESHR to SELECT all data from the table
DATA: WA_ADFSH_CODESHR TYPE ADFSH_CODESHR.

SELECT SINGLE *
FROM ADFSH_CODESHR
INTO CORRESPONDING FIELDS OF WA_ADFSH_CODESHR
WHERE...

How to access SAP table ADFSH_CODESHR

Within an ECC or HANA version of SAP you can also view further information about ADFSH_CODESHR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).