1. Home
  2. Resources
  3. SAP Tables
  4. ADRS1 - Address format transfer structure (normal address)

SAP Table ADRS1

Address format transfer structure (normal address)

ADRS1 (Address format transfer structure (normal address)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADRS1 to other SAP tables.

ADRS1 table fields

Field Data element Checktable Datatype Length Decimals
TITLE_TEXT Title text AD_TITLETX CHAR 30 0
NAME1 Name 1 of an address NAME1_ADRS CHAR 40 0
NAME2 Name 2 of an address NAME2_ADRS CHAR 40 0
NAME3 Name 3 of an address NAME3_ADRS CHAR 40 0
NAME4 Name 4 of an address NAME4_ADRS CHAR 40 0
NAME_CO c/o name AD_NAME_CO CHAR 40 0
STREET Street AD_STREET CHAR 60 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
STR_SUPPL1 Street 2 AD_STRSPP1 CHAR 40 0
STR_SUPPL2 Street 3 AD_STRSPP2 CHAR 40 0
STR_SUPPL3 Street 4 AD_STRSPP3 CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
PCODE2_EXT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_LOC PO Box city AD_POBXLOC CHAR 40 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
PO_BOX_CTY PO box country AD_POBXCTY CHAR 3 0
LOCATION Street 5 AD_LCTN CHAR 40 0
REGION Region (State, Province, County) REGIO CHAR 3 0
COUNTRY Country Key LAND1 CHAR 3 0
PO_BOX_LOBBY PO Box Lobby AD_PO_BOX_LBY CHAR 40 0
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0