SAP ADDR_DELIV table - Address fields for delivery addresses details in SAP

SAP ADDR_DELIV table summary

Object Name: ADDR_DELIV
Dictionary Type: Structure
Description: Address fields for delivery addresses

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

Details

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

ADDR_DELIV-CITYP_CODE table field - District code for City and Street file ▼

Description: District code for City and Street file
Field Name: CITYP_CODE
Data Element: AD_CITYPNM
Data Type: CHAR
length (Dec): 8(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: CITYP_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITYP_CODE

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

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

ADDR_DELIV-POSTALAREA table field - (Not Supported) Post Delivery District ▼

Description: (Not Supported) Post Delivery District
Field Name: POSTALAREA
Data Element: AD_PSTLAR
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: TEXT15
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTALAREA

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

ADDR_DELIV-STREETCODE table field - Street Number for City/Street File ▼

Description: Street Number for City/Street File
Field Name: STREETCODE
Data Element: AD_STRNUM
Data Type: CHAR
length (Dec): 12(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: STRT_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field STREETCODE

ADDR_DELIV-STREETABBR table field - (Not Supported) Abbreviation of Street Name ▼

Description: (Not Supported) Abbreviation of Street Name
Field Name: STREETABBR
Data Element: AD_STRABBR
Data Type: CHAR
length (Dec): 2(0)
Check table: *
Conversion Routine:
Domain Name: STRTYPEAB
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREETABBR

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

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

ADDR_DELIV-HOUSE_NUM3 table field - (Not supported) House Number Range ▼

Description: (Not supported) House Number Range
Field Name: HOUSE_NUM3
Data Element: AD_HSNM3
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_NUM3

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

ADDR_DELIV-CITY_CODE table field - City code for city/street file ▼

Description: City code for city/street file
Field Name: CITY_CODE
Data Element: AD_CITYNUM
Data Type: CHAR
length (Dec): 12(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: CITY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field CITY_CODE

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

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

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

ADDR_DELIV-COUNTY_CODE table field - County code for county ▼

Description: County code for county
Field Name: COUNTY_CODE
Data Element: AD_CNTYNUM
Data Type: CHAR
length (Dec): 8(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: CNTY_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field COUNTY_CODE

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

ADDR_DELIV-TOWNSHIP_CODE table field - Township code for Township ▼

Description: Township code for Township
Field Name: TOWNSHIP_CODE
Data Element: AD_TWSHPNUM
Data Type: CHAR
length (Dec): 8(0)
Check table: *
Conversion Routine: ALPHA
Domain Name: TWSHP_CODE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field TOWNSHIP_CODE

View list of all SAP tables(S4H/ECC)

Select data from SAP table