SAP /SAPQUERY/T100 table - Flight details in SAP


SAP /SAPQUERY/T100 table summary

Object Name: /SAPQUERY/T100
Dictionary Type: Transparent table
Description: Flight


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

Details
/SAPQUERY/T100-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/T100-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/T100-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: /SAPQUERY/T000
Conversion Routine:
Domain Name: /SAPQUERY/S_CONN_ID
MemoryID: CON
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNID

/SAPQUERY/T100-FLDATE table field - Flight date

Description: Flight date
Field Name: FLDATE
Data Element: /SAPQUERY/S_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_DATE
MemoryID: DAY
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FLDATE

/SAPQUERY/T100-PRICE table field - Airfare

Description: Airfare
Field Name: PRICE
Data Element: /SAPQUERY/S_PRICE
Data Type: CURR
length (Dec): 15(2)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_PRICE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRICE

/SAPQUERY/T100-CURRENCY table field - Local currency of airline

Description: Local currency of airline
Field Name: CURRENCY
Data Element: /SAPQUERY/S_CURRCODE
Data Type: CUKY
length (Dec): 5(0)
Check table: *
Conversion Routine:
Domain Name: /SAPQUERY/S_CURR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURRENCY

/SAPQUERY/T100-PLANETYPE table field - Aircraft Type

Description: Aircraft Type
Field Name: PLANETYPE
Data Element: /SAPQUERY/S_PLANETYE
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine:
Domain Name: /SAPQUERY/S_PLANE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLANETYPE

/SAPQUERY/T100-SEATSMAX table field - Maximum capacity in economy class

Description: Maximum capacity in economy class
Field Name: SEATSMAX
Data Element: /SAPQUERY/S_SEATSMAX
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SEATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEATSMAX

/SAPQUERY/T100-SEATSOCC table field - Occupied seats in economy class

Description: Occupied seats in economy class
Field Name: SEATSOCC
Data Element: /SAPQUERY/S_SEATSOCC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SEATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEATSOCC

/SAPQUERY/T100-PAYMENTSUM table field - Total of current bookings

Description: Total of current bookings
Field Name: PAYMENTSUM
Data Element: /SAPQUERY/S_SUM
Data Type: CURR
length (Dec): 17(2)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SUM
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PAYMENTSUM

/SAPQUERY/T100-SEATSMAX_B table field - Maximum capacity in business class

Description: Maximum capacity in business class
Field Name: SEATSMAX_B
Data Element: /SAPQUERY/S_SMAX_B
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SEATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEATSMAX_B

/SAPQUERY/T100-SEATSOCC_B table field - Occupied seats in business class

Description: Occupied seats in business class
Field Name: SEATSOCC_B
Data Element: /SAPQUERY/S_SOCC_B
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SEATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEATSOCC_B

/SAPQUERY/T100-SEATSMAX_F table field - Maximum capacity in first class

Description: Maximum capacity in first class
Field Name: SEATSMAX_F
Data Element: /SAPQUERY/S_SMAX_F
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SEATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEATSMAX_F

/SAPQUERY/T100-SEATSOCC_F table field - Occupied seats in first class

Description: Occupied seats in first class
Field Name: SEATSOCC_F
Data Element: /SAPQUERY/S_SOCC_F
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_SEATS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEATSOCC_F


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table