SAP ADDRS_LOCATION table - Street address and POBox address fields details in SAP

SAP ADDRS_LOCATION table summary

Object Name: ADDRS_LOCATION
Dictionary Type: Structure
Description: Street address and POBox address fields

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

Details

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

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

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

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

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

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

ADDRS_LOCATION-CITYH_CODE table field - Different city for city/street file ▼

Description: Different city for city/street file
Field Name: CITYH_CODE
Data Element: AD_CITYHNM
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 CITYH_CODE

ADDRS_LOCATION-CHCKSTATUS table field - City file test status ▼

Description: City file test status
Field Name: CHCKSTATUS
Data Element: AD_CHECKST
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_CHECKST
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHCKSTATUS

ADDRS_LOCATION-REGIOGROUP table field - Regional structure grouping ▼

Description: Regional structure grouping
Field Name: REGIOGROUP
Data Element: REGIOGROUP
Data Type: CHAR
length (Dec): 8(0)
Check table: *
Conversion Routine:
Domain Name: REGIOGROUP
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REGIOGROUP

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

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

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

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

ADDRS_LOCATION-DONT_USE_P table field - PO Box Address Undeliverable Flag ▼

Description: PO Box Address Undeliverable Flag
Field Name: DONT_USE_P
Data Element: AD_NO_USEP
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AD_NO_USE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DONT_USE_P

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

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

ADDRS_LOCATION-CITY_CODE2 table field - City PO box code (City file) ▼

Description: City PO box code (City file)
Field Name: CITY_CODE2
Data Element: AD_CIT2NUM
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_CODE2

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

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

ADDRS_LOCATION-TRANSPZONE table field - Transportation zone to or from which the goods are delivered ▼

Description: Transportation zone to or from which the goods are delivered
Field Name: TRANSPZONE
Data Element: LZONE
Data Type:
length (Dec): 0(0)
Check table: *
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRANSPZONE

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

ADDRS_LOCATION-DONT_USE_S table field - Street Address Undeliverable Flag ▼

Description: Street Address Undeliverable Flag
Field Name: DONT_USE_S
Data Element: AD_NO_USES
Data Type: CHAR
length (Dec): 4(0)
Check table: *
Conversion Routine:
Domain Name: AD_NO_USE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DONT_USE_S

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

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

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

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

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

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

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

ADDRS_LOCATION-BUILDING table field - Building (Number or Code) ▼

Description: Building (Number or Code)
Field Name: BUILDING
Data Element: AD_BLDNG
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUILDING

ADDRS_LOCATION-FLOOR table field - Floor in building ▼

Description: Floor in building
Field Name: FLOOR
Data Element: AD_FLOOR
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 FLOOR

ADDRS_LOCATION-ROOMNUMBER table field - Room or Apartment Number ▼

Description: Room or Apartment Number
Field Name: ROOMNUMBER
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 ROOMNUMBER

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

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

ADDRS_LOCATION-TIME_ZONE table field - Address time zone ▼

Description: Address time zone
Field Name: TIME_ZONE
Data Element: AD_TZONE
Data Type: CHAR
length (Dec): 6(0)
Check table: *
Conversion Routine:
Domain Name: TZNZONE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TIME_ZONE

ADDRS_LOCATION-TAXJURCODE table field - Tax Jurisdiction ▼

Description: Tax Jurisdiction
Field Name: TAXJURCODE
Data Element: AD_TXJCD
Data Type: CHAR
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: AD_TXJCD
MemoryID: TXJ
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TAXJURCODE

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

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

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

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

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