1. Home
  2. Resources
  3. SAP Tables
  4. ADDR2_BW - Extractor structure for BW (ADDR_BW_K2 + ADRC_BW + ADRP_BW)

SAP Table ADDR2_BW

Extractor structure for BW (ADDR_BW_K2 + ADRC_BW + ADRP_BW)

ADDR2_BW (Extractor structure for BW (ADDR_BW_K2 + ADRC_BW + ADRP_BW)) 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 ADDR2_BW to other SAP tables.

ADDR2_BW table fields

Field Data element Checktable Datatype Length Decimals
OBJKEY Address owner object ID AD_OBJKEY CHAR 70 0
EXTENSION Object key SWO_TYPEID CHAR 70 0
CONTEXT Semantic description of an object address AD_CONTEXT NUMC 4 0
0001 Main address of a Company/Organization
0002 Different business address
0003 Private address (with company address structure)
0004 Private address (with person address structure)
0005 Compiled business address
0006 Delivery address per order item
0007 Communication Data Without Postal Address
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
NATION Version ID for International Addresses AD_NATION CHAR 1 0
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
NAME_CO c/o name AD_NAME_CO CHAR 40 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
CITY_CODE City code for city/street file AD_CITYNUM CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
CITYH_CODE Different city for city/street file AD_CITYHNM CHAR 12 0
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 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
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
CITY_CODE2 City PO box code (City file) AD_CIT2NUM CHAR 12 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
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
STREETCODE Street Number for City/Street File AD_STRNUM CHAR 12 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
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING Building (Number or Code) AD_BLDNG CHAR 20 0
FLOOR Floor in building AD_FLOOR CHAR 10 0
ROOMNUMBER Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
LANGU Language Key SPRAS LANG 1 0
REGION Region (State, Province, County) REGIO CHAR 3 0
PERS_ADDR Flag: This is a personal address AD_PRSADDR CHAR 1 0
X Yes
NULL No
SORT1 Search Term 1 AD_SORT1 CHAR 20 0
SORT2 Search Term 2 AD_SORT2 CHAR 20 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
TEL_EXTENS First Telephone No.: Extension AD_TLXTNS1 CHAR 10 0
FAX_NUMBER First fax no.: dialling code+number AD_FXNMBR1 CHAR 30 0
FAX_EXTENS First fax no.: extension AD_FXXTNS1 CHAR 10 0
EXTENSION1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENSION2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
SMTP_ADDR E-Mail Address AD_SMTPADR CHAR 241 0
URI_ADDR URI field to pass to BW AD_URI_BW CHAR 60 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_CODE County code for county AD_CNTYNUM CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
ADDRNUM_P Address number AD_ADDRNUM CHAR 10 0
PERSNUMBER Person number AD_PERSNUM CHAR 10 0
DATE_FROMP Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
NATION_P Version ID for International Addresses AD_NATION CHAR 1 0
DATE_TO_P Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE_P Form-of-Address Key AD_TITLE CHAR 4 0
NAME_FIRST First name AD_NAMEFIR CHAR 40 0
NAME_LAST Last name AD_NAMELAS CHAR 40 0
NAME_TEXT Full Name of Person AD_NAMTEXT CHAR 80 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX CHAR 4 0
TITLE_SPPL Name supplement, e.g. noble title (key) AD_TITLES CHAR 4 0
LANGU_P Language Key SPRAS LANG 1 0
SORT1_P Search Term 1 AD_SORT1 CHAR 20 0
SORT2_P Search Term 2 AD_SORT2 CHAR 20 0
SMTP_ADDRP E-Mail Address AD_SMTPADR CHAR 241 0
URI_ADDR_P URI field to pass to BW AD_URI_BW CHAR 60 0