SAP ADDR3_FIND table - Search parameter for the address of a person in a company details in SAP

SAP ADDR3_FIND table summary

Object Name: ADDR3_FIND
Dictionary Type: Structure
Description: Search parameter for the address of a person in a company

Field list for ADDR3_FIND table on an S/4 SAP system

Details

ADDR3_FIND-NAME_FIRST table field - First Name in Uppercase for Search Help ▼

Description: First Name in Uppercase for Search Help
Field Name: NAME_FIRST
Data Element: AD_MC_NMFI
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_FIRST

ADDR3_FIND-NAME_LAST table field - Last Name in Uppercase for Search Help ▼

Description: Last Name in Uppercase for Search Help
Field Name: NAME_LAST
Data Element: AD_MC_NMLA
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_LAST

ADDR3_FIND-DEPARTMENT table field - Department ▼

Description: Department
Field Name: DEPARTMENT
Data Element: AD_DPRTMNT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEPARTMENT

ADDR3_FIND-ROOMNUM_C table field - Room or Apartment Number ▼

Description: Room or Apartment Number
Field Name: ROOMNUM_C
Data Element: AD_ROOMNUM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ROOMNUM_C

ADDR3_FIND-SORT1_P table field - Search Term 1 ▼

Description: Search Term 1
Field Name: SORT1_P
Data Element: AD_SORT1
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT1_P

ADDR3_FIND-SORT2_P table field - Search Term 2 ▼

Description: Search Term 2
Field Name: SORT2_P
Data Element: AD_SORT2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT2_P

ADDR3_FIND-NAME1 table field - Name (Field NAME1) in Uppercase for Search Help ▼

Description: Name (Field NAME1) in Uppercase for Search Help
Field Name: NAME1
Data Element: AD_MC_NAME
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME1

ADDR3_FIND-NAME2 table field - Name 2 ▼

Description: Name 2
Field Name: NAME2
Data Element: AD_NAME2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME2

ADDR3_FIND-CITY1 table field - City name in Uppercase for Search Help ▼

Description: City name in Uppercase for Search Help
Field Name: CITY1
Data Element: AD_MC_CITY
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY1

ADDR3_FIND-CITY2 table field - District ▼

Description: District
Field Name: CITY2
Data Element: AD_CITY2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_PART
SHLP Field: CITY_PART
ConvExit:

See all SAP tables containing field CITY2

ADDR3_FIND-POST_CODE1 table field - City postal code ▼

Description: City postal code
Field Name: POST_CODE1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE1

ADDR3_FIND-POST_CODE2 table field - PO Box Postal Code ▼

Description: PO Box Postal Code
Field Name: POST_CODE2
Data Element: AD_PSTCD2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE2

ADDR3_FIND-POST_CODE3 table field - Company Postal Code (for Large Customers) ▼

Description: Company Postal Code (for Large Customers)
Field Name: POST_CODE3
Data Element: AD_PSTCD3
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE3

ADDR3_FIND-PO_BOX_LOC table field - PO Box city ▼

Description: PO Box city
Field Name: PO_BOX_LOC
Data Element: AD_POBXLOC
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CITY_NAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field PO_BOX_LOC

ADDR3_FIND-STREET table field - Street Name in Uppercase for Search Help ▼

Description: Street Name in Uppercase for Search Help
Field Name: STREET
Data Element: AD_MC_STRT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET

ADDR3_FIND-HOUSE_NUM1 table field - House Number ▼

Description: House Number
Field Name: HOUSE_NUM1
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NUM1

ADDR3_FIND-HOUSE_NUM2 table field - House number supplement ▼

Description: House number supplement
Field Name: HOUSE_NUM2
Data Element: AD_HSNM2
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NUM2

ADDR3_FIND-COUNTRY table field - Country/Region Key ▼

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

ADDR3_FIND-REGION table field - Region (State, Province, County) ▼

Description: Region (State, Province, County)
Field Name: REGION
Data Element: REGIO
Data Type: CHAR
length (Dec): 3(0)
Check table: T005S
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

ADDR3_FIND-SORT1 table field - Search Term 1 ▼

Description: Search Term 1
Field Name: SORT1
Data Element: AD_SORT1
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT1

ADDR3_FIND-SORT2 table field - Search Term 2 ▼

Description: Search Term 2
Field Name: SORT2
Data Element: AD_SORT2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SORT2

ADDR3_FIND-PERSNUMBER table field - Person Number ▼

Description: Person Number
Field Name: PERSNUMBER
Data Element: AD_PERSNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: AD_PERSNUM
MemoryID: CDT
AppClass:
SHLP: ADDRESS
SHLP Field: PERSNUMBER
ConvExit: ALPHA

See all SAP tables containing field PERSNUMBER

ADDR3_FIND-ADDRNUMBER table field - Address Number ▼

Description: Address Number
Field Name: ADDRNUMBER
Data Element: AD_ADDRNUM
Data Type: CHAR
length (Dec): 10(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: AD_ADDRNUM
MemoryID: ADR
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ADDRNUMBER

ADDR3_FIND-PO_BOX_LOBBY table field - PO Box Lobby ▼

Description: PO Box Lobby
Field Name: PO_BOX_LOBBY
Data Element: AD_PO_BOX_LBY
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_LOBBY

ADDR3_FIND-DELI_SERV_TYPE table field - Type of Delivery Service ▼

Description: Type of Delivery Service
Field Name: DELI_SERV_TYPE
Data Element: AD_DELIVERY_SERVICE_TYPE
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AD_DELIVERY_SERVICE_TYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELI_SERV_TYPE

ADDR3_FIND-DELI_SERV_NUMBER table field - Number of Delivery Service ▼

Description: Number of Delivery Service
Field Name: DELI_SERV_NUMBER
Data Element: AD_DELIVERY_SERVICE_NUMBER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DELI_SERV_NUMBER

ADDR3_FIND-COUNTY table field - County name in upper case for search help ▼

Description: County name in upper case for search help
Field Name: COUNTY
Data Element: AD_MC_COUNTY
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTY

ADDR3_FIND-TOWNSHIP table field - Township name in upper case for search help ▼

Description: Township name in upper case for search help
Field Name: TOWNSHIP
Data Element: AD_MC_TWSHP
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOWNSHIP

View list of all SAP tables(S4H/ECC)

Select data from SAP table