SAP /SAPQUERY/TA02 table - Flight customers details in SAP


SAP /SAPQUERY/TA02 table summary

Object Name: /SAPQUERY/TA02
Dictionary Type: Transparent table
Description: Flight customers


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

Details
/SAPQUERY/TA02-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/TA02-ID table field - Customer Number

Description: Customer Number
Field Name: ID
Data Element: /SAPQUERY/S_CUSTOMER
Data Type: NUMC
length (Dec): 8(0)
Check table: *
Conversion Routine:
Domain Name: /SAPQUERY/S_BUSPANUM
MemoryID: CSM
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ID

/SAPQUERY/TA02-NAME table field - Customer name

Description: Customer name
Field Name: NAME
Data Element: /SAPQUERY/S_CUSTNAME
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_CUSTNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

/SAPQUERY/TA02-FORM table field - Form of address

Description: Form of address
Field Name: FORM
Data Element: /SAPQUERY/S_FORM
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_TEXT15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FORM

/SAPQUERY/TA02-STREET table field - Street

Description: Street
Field Name: STREET
Data Element: /SAPQUERY/S_STREET
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_STREET
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET

/SAPQUERY/TA02-POSTBOX table field - PO Box

Description: PO Box
Field Name: POSTBOX
Data Element: /SAPQUERY/S_POSTBOX
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_POSTBOX
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTBOX

/SAPQUERY/TA02-POSTCODE table field - Postal Code

Description: Postal Code
Field Name: POSTCODE
Data Element: /SAPQUERY/POSTCODE
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/POSTCODE
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTCODE

/SAPQUERY/TA02-CITY table field - City

Description: City
Field Name: CITY
Data Element: /SAPQUERY/CITY
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/CITY
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY

/SAPQUERY/TA02-COUNTRY table field - Country code

Description: Country code
Field Name: COUNTRY
Data Element: /SAPQUERY/S_COUNTRY
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_COUNTRY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

/SAPQUERY/TA02-REGION table field - Region

Description: Region
Field Name: REGION
Data Element: /SAPQUERY/S_REGION
Data Type: CHAR
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_REGION
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

/SAPQUERY/TA02-TELEPHONE table field - Telephone number of flight customer

Description: Telephone number of flight customer
Field Name: TELEPHONE
Data Element: /SAPQUERY/S_PHONENO
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_PHONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TELEPHONE

/SAPQUERY/TA02-CUSTTYPE table field - Customer type

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

See all SAP tables containing field CUSTTYPE

/SAPQUERY/TA02-DISCOUNT table field - Discount rate

Description: Discount rate
Field Name: DISCOUNT
Data Element: /SAPQUERY/S_DISCOUNT
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_DISCOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DISCOUNT

/SAPQUERY/TA02-LANGU table field - Language Key

Description: Language Key
Field Name: LANGU
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: T002
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field LANGU

/SAPQUERY/TA02-EMAIL table field - Customer e-mail address

Description: Customer e-mail address
Field Name: EMAIL
Data Element: /SAPQUERY/S_EMAIL
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_EMAIL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMAIL

/SAPQUERY/TA02-WEBUSER table field - Web user name for customer

Description: Web user name for customer
Field Name: WEBUSER
Data Element: /SAPQUERY/S_WEBNAME
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: /SAPQUERY/S_WEBNAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WEBUSER


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table