1. Home
  2. Resources
  3. SAP Tables
  4. BUS_PARTNER_ADDRESS_BW - SAP BP: Extract Structure Standard Address Business Partner

SAP Table BUS_PARTNER_ADDRESS_BW

SAP BP: Extract Structure Standard Address Business Partner

BUS_PARTNER_ADDRESS_BW (SAP BP: Extract Structure Standard Address Business Partner) 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 BUS_PARTNER_ADDRESS_BW to other SAP tables.

BUS_PARTNER_ADDRESS_BW table fields

Field Data element Checktable Datatype Length Decimals
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
PARTNER_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
VALID_FROM Validity Start BUT000 BP Data BU_BP_VALID_FROM DEC 15 0
VALID_TO Validity End BUT000 BP Data BU_BP_VALID_TO DEC 15 0
TD_SWITCH Planned Change Documents for Partner Were Converted BU_TD_SWITCH CHAR 1 0
TYPE Business partner category BU_TYPE CHAR 1 0
1 Person
2 Organization
3 Group
PERSNUMBER Person number AD_PERSNUM CHAR 10 0
NAME_ORG1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
NAME_ORG2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
NAME_ORG3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
NAME_ORG4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
NAME_LAST Last name of business partner (person) BU_NAMEP_L CHAR 40 0
NAME_FIRST First name of business partner (person) BU_NAMEP_F CHAR 40 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 CHAR 4 0
TITLE_ACA2 Second academic title (key) AD_TITLE2 CHAR 4 0
TITLE_ROYL Name supplement, e.g. noble title (key) AD_TITLES CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX CHAR 4 0
NAME_GRP1 Name 1 (group) BU_NAMEGR1 CHAR 40 0
NAME_GRP2 Name 2 (group) BU_NAMEGR2 CHAR 40 0
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) PI_AD_CITY3 CHAR 40 0
CITYH_CODE Different City Coding for City/Street File PI_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 for Transfer to BW PI_AD_URI CHAR 60 0
TELDISPLAY Display Format for Telephone Number PI_AD_TELD CHAR 30 0
FAXDISPLAY Display Format for Fax Number PI_AD_FAXD CHAR 30 0
LONGITUDE Geo location longitude GEOLON DEC 15 12
LATITUDE Geo location latitude GEOLAT DEC 15 12
ALTITUDE Geo location height GEOALT DEC 9 3
SRCID Geo location data source ID/Geocoder ID GEOSRCID CHAR 4 0
PRECISID Precision (street, postal code, ...) of a Geo location GEOPRECIS NUMC 4 0
0000 Not specified
0100 World
0200 Continent
0300 Country
0400 Region
0500 Town limits
0600 Postal Code
0700 City
0800 District
0900 Street mid-point
1000 House number range (street section) mid-point
1100 House number (interpolated)
1200 House number (exact)
1300 House number with supplement (e.g. Neurottstr. 7b)
ADDRCOMM Address Number BU_ADDRCOMM CHAR 10 0
ADDR_SHORT One-line short form of formatted address AD_LINE_S CHAR 80 0
ADDR_SHORT_S One-line short form of formatted address AD_LINE_S CHAR 80 0
LINE0 BP Address: Line 0 ADDR_LINE0_BW CHAR 80 0
LINE1 BP Address: Line 1 ADDR_LINE1_BW CHAR 80 0
LINE2 BP Address: Line 2 ADDR_LINE2_BW CHAR 80 0
LINE3 BP Address: Line 3 ADDR_LINE3_BW CHAR 80 0
LINE4 BP Address: Line 4 ADDR_LINE4_BW CHAR 80 0
LINE5 BP Address: Line 5 ADDR_LINE5_BW CHAR 80 0
LINE6 BP Address: Line 6 ADDR_LINE6_BW CHAR 80 0
LINE7 BP Address: Line 7 ADDR_LINE7_BW CHAR 80 0
LINE8 BP Address: Line 8 ADDR_LINE8_BW CHAR 80 0
LINE9 BP Address: Line 9 ADDR_LINE9_BW CHAR 80 0
DQ_ONLINE_UPDATE SAP BP: Delta Queue Update Online BU_DQ_ONLINE_UPD CHAR 1 0
X Yes
NULL No
DQ_OFFLINE_UPDATE SAP BP: Delta Queue Update Offline BU_DQ_OFFLINE_UPD CHAR 1 0
X Yes
NULL No
DQ_TIMESTAMP Delta Queue Update Time Stamp BU_DQ_TIMESTAMP DEC 15 0