SAP ADRS3 table - Address formatting structure: Contact person-business addr. details in SAP

SAP ADRS3 table summary

Object Name: ADRS3
Dictionary Type: Structure
Description: Address formatting structure: Contact person-business addr.

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

Details

ADRS3-TITLE_COMP table field - Title text ▼

Description: Title text
Field Name: TITLE_COMP
Data Element: AD_TITLETX
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TITLE_COMP

ADRS3-NAME1 table field - Company name ▼

Description: Company name
Field Name: NAME1
Data Element: AD_NAME1_C
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 NAME1

ADRS3-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

ADRS3-NAME3 table field - Name 3 ▼

Description: Name 3
Field Name: NAME3
Data Element: AD_NAME3
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 NAME3

ADRS3-NAME4 table field - Name 4 ▼

Description: Name 4
Field Name: NAME4
Data Element: AD_NAME4
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 NAME4

ADRS3-TITLE_PERS table field - Title text ▼

Description: Title text
Field Name: TITLE_PERS
Data Element: AD_TITLETX
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TITLE_PERS

ADRS3-NAME_PERS table field - Formatted Name of Person (with Title; and form of address) ▼

Description: Formatted Name of Person (with Title; and form of address)
Field Name: NAME_PERS
Data Element: AD_NAME_P
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_PERS

ADRS3-FUNCTION table field - Function ▼

Description: Function
Field Name: FUNCTION
Data Element: AD_FNCTN
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 FUNCTION

ADRS3-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

ADRS3-NAME_CO table field - c/o name ▼

Description: c/o name
Field Name: NAME_CO
Data Element: AD_NAME_CO
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 NAME_CO

ADRS3-STREET table field - Street ▼

Description: Street
Field Name: STREET
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET

ADRS3-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

ADRS3-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

ADRS3-STR_SUPPL1 table field - Street 2 ▼

Description: Street 2
Field Name: STR_SUPPL1
Data Element: AD_STRSPP1
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 STR_SUPPL1

ADRS3-STR_SUPPL2 table field - Street 3 ▼

Description: Street 3
Field Name: STR_SUPPL2
Data Element: AD_STRSPP2
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 STR_SUPPL2

ADRS3-STR_SUPPL3 table field - Street 4 ▼

Description: Street 4
Field Name: STR_SUPPL3
Data Element: AD_STRSPP3
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 STR_SUPPL3

ADRS3-CITY1 table field - City ▼

Description: City
Field Name: CITY1
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY1

ADRS3-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

ADRS3-HOME_CITY table field - City (different from postal city) ▼

Description: City (different from postal city)
Field Name: HOME_CITY
Data Element: AD_CITY3
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 HOME_CITY

ADRS3-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

ADRS3-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

ADRS3-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

ADRS3-PCODE1_EXT table field - (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code ▼

Description: (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
Field Name: PCODE1_EXT
Data Element: AD_PST1XT
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 PCODE1_EXT

ADRS3-PCODE2_EXT table field - (Not Supported) PO Box Postal Code Extension ▼

Description: (Not Supported) PO Box Postal Code Extension
Field Name: PCODE2_EXT
Data Element: AD_PST2XT
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 PCODE2_EXT

ADRS3-PCODE3_EXT table field - (Not Supported) Major Customer Postal Code Extension ▼

Description: (Not Supported) Major Customer Postal Code Extension
Field Name: PCODE3_EXT
Data Element: AD_PST3XT
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 PCODE3_EXT

ADRS3-PO_BOX table field - PO Box ▼

Description: PO Box
Field Name: PO_BOX
Data Element: AD_POBX
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 PO_BOX

ADRS3-PO_BOX_NUM table field - Flag: PO Box Without Number ▼

Description: Flag: PO Box Without Number
Field Name: PO_BOX_NUM
Data Element: AD_POBXNUM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: XFELD
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_NUM

ADRS3-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

ADRS3-PO_BOX_REG table field - Region for PO Box (Country/Region, State, Province, ...) ▼

Description: Region for PO Box (Country/Region, State, Province, ...)
Field Name: PO_BOX_REG
Data Element: AD_POBXREG
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_REG

ADRS3-PO_BOX_CTY table field - PO Box of Country/Region ▼

Description: PO Box of Country/Region
Field Name: PO_BOX_CTY
Data Element: AD_POBXCTY
Data Type: CHAR
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: LAND1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PO_BOX_CTY

ADRS3-LOCATION table field - Street 5 ▼

Description: Street 5
Field Name: LOCATION
Data Element: AD_LCTN
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 LOCATION

ADRS3-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: *
Conversion Routine:
Domain Name: REGIO
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGION

ADRS3-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: *
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

ADRS3-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

ADRS3-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

ADRS3-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

ADRS3-COUNTY table field - County ▼

Description: County
Field Name: COUNTY
Data Element: AD_COUNTY
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTCNTYNAME
SHLP Field: COUNTY
ConvExit:

See all SAP tables containing field COUNTY

ADRS3-TOWNSHIP table field - Township ▼

Description: Township
Field Name: TOWNSHIP
Data Element: AD_TOWNSHIP
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTWSHPNAME
SHLP Field: TOWNSHIP
ConvExit:

See all SAP tables containing field TOWNSHIP

View list of all SAP tables(S4H/ECC)

Select data from SAP table