SAP table BUS_PARTNER_ADDRESS_BW (SAP BP: Extract Structure Standard Address Business Partner)

Field Description Data Type Length Decimals Checktable Data Element
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
PARTNER_GUID Business Partner GUID RAW 16 0 BU_PARTNER_GUID
VALID_FROM Validity Start BUT000 BP Data DEC 15 0 BU_BP_VALID_FROM
VALID_TO Validity End BUT000 BP Data DEC 15 0 BU_BP_VALID_TO
TD_SWITCH Planned Change Documents for Partner Were Converted CHAR 1 0 BU_TD_SWITCH
TYPE Business Partner Category CHAR 1 0 BU_TYPE
1 Person
2 Organization
3 Group
PERSNUMBER Person Number CHAR 10 0 AD_PERSNUM
NAME_ORG1 Name 1 of organization CHAR 40 0 BU_NAMEOR1
NAME_ORG2 Name 2 of organization CHAR 40 0 BU_NAMEOR2
NAME_ORG3 Name 3 of organization CHAR 40 0 BU_NAMEOR3
NAME_ORG4 Name 4 of organization CHAR 40 0 BU_NAMEOR4
NAME_LAST Last name of business partner (person) CHAR 40 0 BU_NAMEP_L
NAME_FIRST First name of business partner (person) CHAR 40 0 BU_NAMEP_F
TITLE_ACA1 Academic Title: Key CHAR 4 0 AD_TITLE1
TITLE_ACA2 Second academic title (key) CHAR 4 0 * AD_TITLE2
TITLE_ROYL Name supplement, e.g. noble title (key) CHAR 4 0 * AD_TITLES
PREFIX1 Name Prefix (Key) CHAR 4 0 * AD_PREFIX
NAME_GRP1 Name 1 (group) CHAR 40 0 BU_NAMEGR1
NAME_GRP2 Name 2 (group) CHAR 40 0 BU_NAMEGR2
ADDRNUMBER Address Number CHAR 10 0 * AD_ADDRNUM
DATE_FROM Valid-from date - in current Release only 00010101 possible DATS 8 0 AD_DATE_FR
NATION Version ID for International Addresses CHAR 1 0 * AD_NATION
DATE_TO Valid-to date in current Release only 99991231 possible DATS 8 0 AD_DATE_TO
TITLE Form-of-Address Key CHAR 4 0 * AD_TITLE
NAME1 Name 1 CHAR 40 0 AD_NAME1
NAME2 Name 2 CHAR 40 0 AD_NAME2
NAME3 Name 3 CHAR 40 0 AD_NAME3
NAME4 Name 4 CHAR 40 0 AD_NAME4
NAME_CO c/o name CHAR 40 0 AD_NAME_CO
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
CITY_CODE City code for city/street file CHAR 12 0 * AD_CITYNUM
CITYP_CODE District code for City and Street file CHAR 8 0 * AD_CITYPNM
HOME_CITY City (Different from Postal City) CHAR 40 0 PI_AD_CITY3
CITYH_CODE Different City Coding for City/Street File CHAR 12 0 * PI_AD_CITYHNM
REGIOGROUP Regional structure grouping CHAR 8 0 * REGIOGROUP
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
POST_CODE2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
POST_CODE3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
PO_BOX PO Box CHAR 10 0 AD_POBX
PO_BOX_NUM Flag: PO Box Without Number CHAR 1 0 AD_POBXNUM
PO_BOX_LOC PO Box city CHAR 40 0 AD_POBXLOC
CITY_CODE2 City PO box code (City file) CHAR 12 0 * AD_CIT2NUM
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) CHAR 3 0 * AD_POBXREG
PO_BOX_CTY PO Box of Country/Region CHAR 3 0 * AD_POBXCTY
TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 0 * LZONE
STREET Street CHAR 60 0 AD_STREET
STREETCODE Street Number for City/Street File CHAR 12 0 * AD_STRNUM
HOUSE_NUM1 House Number CHAR 10 0 AD_HSNM1
HOUSE_NUM2 House number supplement CHAR 10 0 AD_HSNM2
STR_SUPPL1 Street 2 CHAR 40 0 AD_STRSPP1
STR_SUPPL2 Street 3 CHAR 40 0 AD_STRSPP2
STR_SUPPL3 Street 4 CHAR 40 0 AD_STRSPP3
LOCATION Street 5 CHAR 40 0 AD_LCTN
BUILDING Building (Number or Code) CHAR 20 0 AD_BLDNG
FLOOR Floor in building CHAR 10 0 AD_FLOOR
ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
COUNTRY Country/Region Key CHAR 3 0 * LAND1
LANGU Language Key LANG 1 0 SPRAS
REGION Region (State, Province, County) CHAR 3 0 * REGIO
PERS_ADDR Flag: This is a personal address CHAR 1 0 AD_PRSADDR
SORT1 Search Term 1 CHAR 20 0 AD_SORT1
SORT2 Search Term 2 CHAR 20 0 AD_SORT2
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
TEL_EXTENS First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
FAX_NUMBER First Fax No.: Area Code + Number CHAR 30 0 AD_FXNMBR1
FAX_EXTENS First fax no.: extension CHAR 10 0 AD_FXXTNS1
EXTENSION1 Extension (only for data conversion) (e.g. data line) CHAR 40 0 AD_EXTENS1
EXTENSION2 Extension (only for data conversion) (e.g. telebox) CHAR 40 0 AD_EXTENS2
TIME_ZONE Address time zone CHAR 6 0 * AD_TZONE
TAXJURCODE Tax Jurisdiction CHAR 15 0 AD_TXJCD
SMTP_ADDR E-Mail Address CHAR 241 0 AD_SMTPADR
URI_ADDR URI Field Passed to BW CHAR 60 0 PI_AD_URI
TELDISPLAY Display Format for Telephone Number CHAR 30 0 PI_AD_TELD
FAXDISPLAY Display Format for Fax Number CHAR 30 0 PI_AD_FAXD
LONGITUDE Geo location longitude DEC 15 12 GEOLON
LATITUDE Geo location latitude DEC 15 12 GEOLAT
ALTITUDE Geo location height DEC 9 3 GEOALT
SRCID Geo location data source ID/Geocoder ID CHAR 4 0 GEOSRCID
PRECISID Precision (street, postal code, ...) of a Geo location NUMC 4 0 GEOPRECIS
ADDRCOMM Address Number CHAR 10 0 BU_ADDRCOMM
ADDR_SHORT One-line short form of formatted address CHAR 80 0 AD_LINE_S
ADDR_SHORT_S One-line short form of formatted address CHAR 80 0 AD_LINE_S
LINE0 BP Address: Line 0 CHAR 80 0 ADDR_LINE0_BW
LINE1 BP Address: Line 1 CHAR 80 0 ADDR_LINE1_BW
LINE2 BP Address: Line 2 CHAR 80 0 ADDR_LINE2_BW
LINE3 BP Address: Line 3 CHAR 80 0 ADDR_LINE3_BW
LINE4 BP Address: Line 4 CHAR 80 0 ADDR_LINE4_BW
LINE5 BP Address: Line 5 CHAR 80 0 ADDR_LINE5_BW
LINE6 BP Address: Line 6 CHAR 80 0 ADDR_LINE6_BW
LINE7 BP Address: Line 7 CHAR 80 0 ADDR_LINE7_BW
LINE8 BP Address: Line 8 CHAR 80 0 ADDR_LINE8_BW
LINE9 BP Address: Line 9 CHAR 80 0 ADDR_LINE9_BW
DQ_ONLINE_UPDATE SAP BP: Delta Queue Update Online CHAR 1 0 BU_DQ_ONLINE_UPD
DQ_OFFLINE_UPDATE SAP BP: Delta Queue Update Offline CHAR 1 0 BU_DQ_OFFLINE_UPD
DQ_TIMESTAMP Delta Queue Update Time Stamp DEC 15 0 BU_DQ_TIMESTAMP