SAP SCOL_QUERY_FLIGHTS table - Query Structure for SFLIGHT details in SAP
SAP SCOL_QUERY_FLIGHTS table summary
Object Name: SCOL_QUERY_FLIGHTS
Dictionary Type: Structure
Description: Query Structure for SFLIGHT
Field list for SCOL_QUERY_FLIGHTS table on an S/4 SAP system
| Details |
SCOL_QUERY_FLIGHTS-CARRID table field - Airline Code
▼
Description: Airline Code
Field Name: CARRID
Data Element: S_CARR_ID
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: S_CARR_ID
MemoryID: CAR
AppClass:
SHLP: S_CARRIER_ID
SHLP Field: CARRID
ConvExit:
See all SAP tables containing field CARRID
|
SCOL_QUERY_FLIGHTS-COUNTRYFR table field - Country/Region Key
▼
Description: Country/Region Key
Field Name: COUNTRYFR
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field COUNTRYFR
|
SCOL_QUERY_FLIGHTS-CITYFROM table field - Departure city
▼
Description: Departure city
Field Name: CITYFROM
Data Element: S_FROM_CIT
Data Type: CHAR
length (Dec): 20(0)
Check table: *
Conversion Routine:
Domain Name: S_CITY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field CITYFROM
|
SCOL_QUERY_FLIGHTS-AIRPFROM table field - Departure airport
▼
Description: Departure airport
Field Name: AIRPFROM
Data Element: S_FROMAIRP
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: S_AIRPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field AIRPFROM
|
SCOL_QUERY_FLIGHTS-COUNTRYTO table field - Country/Region Key
▼
Description: Country/Region Key
Field Name: COUNTRYTO
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field COUNTRYTO
|
SCOL_QUERY_FLIGHTS-CITYTO table field - Arrival city
▼
Description: Arrival city
Field Name: CITYTO
Data Element: S_TO_CITY
Data Type: CHAR
length (Dec): 20(0)
Check table: *
Conversion Routine:
Domain Name: S_CITY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field CITYTO
|
SCOL_QUERY_FLIGHTS-AIRPTO table field - Destination airport
▼
Description: Destination airport
Field Name: AIRPTO
Data Element: S_TOAIRP
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: S_AIRPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field AIRPTO
|
SCOL_QUERY_FLIGHTS-DATEMIN table field - Flight date
▼
Description: Flight date
Field Name: DATEMIN
Data Element: S_DATE
Data Type: DATS
length (Dec): 8(0)
Check table: *
Conversion Routine:
Domain Name: S_DATE
MemoryID: DAY
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field DATEMIN
|
SCOL_QUERY_FLIGHTS-DATEMAX table field - Flight date
▼
Description: Flight date
Field Name: DATEMAX
Data Element: S_DATE
Data Type: DATS
length (Dec): 8(0)
Check table: *
Conversion Routine:
Domain Name: S_DATE
MemoryID: DAY
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field DATEMAX
|
SCOL_QUERY_FLIGHTS-CLASS table field - Flight Class
▼
Description: Flight Class
Field Name: CLASS
Data Element: S_CLASS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: S_CLASS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field CLASS
|
SCOL_QUERY_FLIGHTS-SEATS table field - 4 Byte Signed Integer
▼
Description: 4 Byte Signed Integer
Field Name: SEATS
Data Element: INT4
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:
See all SAP tables containing field SEATS
|
View list of all SAP tables(S4H/ECC)Select data from SAP table
