SAP /SAPQUERY/T000 table - Flight schedule details in SAP


SAP /SAPQUERY/T000 table summary

Object Name: /SAPQUERY/T000
Dictionary Type: Transparent table
Description: Flight schedule


Field list for /SAPQUERY/T000 table on an S/4 SAP system

Details
/SAPQUERY/T000-MANDT table field - Client

Description: Client
Field Name: MANDT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: T000
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MANDT

/SAPQUERY/T000-CARRID table field - Airline Code

Description: Airline Code
Field Name: CARRID
Data Element: /SAPQUERY/S_CARR_ID
Data Type: CHAR
length (Dec): 3(0)
Check table: /SAPQUERY/TA00
Conversion Routine:
Domain Name: /SAPQUERY/S_CARR_ID
MemoryID: CAR
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CARRID

/SAPQUERY/T000-CONNID table field - Flight Connection Number

Description: Flight Connection Number
Field Name: CONNID
Data Element: /SAPQUERY/S_CONN_ID
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_CONN_ID
MemoryID: CON
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNID

/SAPQUERY/T000-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: /SAPQUERY/TA03
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRYFR

/SAPQUERY/T000-CITYFROM table field - City

Description: City
Field Name: CITYFROM
Data Element: /SAPQUERY/S_CITY
Data Type: CHAR
length (Dec): 20(0)
Check table: /SAPQUERY/TA03
Conversion Routine:
Domain Name: /SAPQUERY/S_CITY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITYFROM

/SAPQUERY/T000-AIRPFROM table field - Departure airport

Description: Departure airport
Field Name: AIRPFROM
Data Element: /SAPQUERY/S_FROMAIRP
Data Type: CHAR
length (Dec): 3(0)
Check table: /SAPQUERY/TA01
Conversion Routine:
Domain Name: /SAPQUERY/S_AIRPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AIRPFROM

/SAPQUERY/T000-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: /SAPQUERY/TA03
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRYTO

/SAPQUERY/T000-CITYTO table field - Arrival city

Description: Arrival city
Field Name: CITYTO
Data Element: /SAPQUERY/S_TO_CITY
Data Type: CHAR
length (Dec): 20(0)
Check table: /SAPQUERY/TA03
Conversion Routine:
Domain Name: /SAPQUERY/S_CITY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITYTO

/SAPQUERY/T000-AIRPTO table field - Destination airport

Description: Destination airport
Field Name: AIRPTO
Data Element: /SAPQUERY/S_TOAIRP
Data Type: CHAR
length (Dec): 3(0)
Check table: /SAPQUERY/TA01
Conversion Routine:
Domain Name: /SAPQUERY/S_AIRPID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AIRPTO

/SAPQUERY/T000-FLTIME table field - Flight time

Description: Flight time
Field Name: FLTIME
Data Element: /SAPQUERY/S_FLTIME
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine: QUERT
Domain Name: /SAPQUERY/S_DURA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: QUERT

See all SAP tables containing field FLTIME

/SAPQUERY/T000-DEPTIME table field - Departure time

Description: Departure time
Field Name: DEPTIME
Data Element: /SAPQUERY/S_DEP_TIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEPTIME

/SAPQUERY/T000-ARRTIME table field - Arrival time

Description: Arrival time
Field Name: ARRTIME
Data Element: /SAPQUERY/S_ARR_TIME
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_TIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARRTIME

/SAPQUERY/T000-DISTANCE table field - Distance

Description: Distance
Field Name: DISTANCE
Data Element: /SAPQUERY/S_DISTANCE
Data Type: QUAN
length (Dec): 9(4)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_DISTANCE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISTANCE

/SAPQUERY/T000-DISTID table field - Mass unit of distance (kms, miles)

Description: Mass unit of distance (kms, miles)
Field Name: DISTID
Data Element: /SAPQUERY/S_DISTID
Data Type: UNIT
length (Dec): 3(0)
Check table: *
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field DISTID

/SAPQUERY/T000-FLTYPE table field - Flight type

Description: Flight type
Field Name: FLTYPE
Data Element: /SAPQUERY/S_FLTYPE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_FLTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLTYPE

/SAPQUERY/T000-PERIOD table field - Arrival n day(s) later

Description: Arrival n day(s) later
Field Name: PERIOD
Data Element: /SAPQUERY/S_PERIOD
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INT1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERIOD


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table