0BP_DEF_ADDRESS_ATTR

SAP BP: BP Standard Address Extraction | #ATTR | Extraction method: F1 | Delta: AIM | Component: Business Partner Master Data
Column Name Description
PARTNER Business Partner Number
VALID_TO Validity End BUT000 BP Data
PERSNUMBER Person Number
ADDRNUMBER Address Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION Version ID for International Addresses
DATE_TO Valid-to date in current Release only 99991231 possible
LANGU Language Key
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
Column Name Description
TYPE Business Partner Category Show values
PO_BOX_NUM Flag: PO Box Without Number Show values
PERS_ADDR Flag: This is a personal address Show values
PRECISID Precision (street, postal code, ...) of a Geo location Show values
DQ_ONLINE_UPDATE SAP BP: Delta Queue Update Online Show values
DQ_OFFLINE_UPDATE SAP BP: Delta Queue Update Offline Show values
Column Name Description Domain name
PARTNER_GUID Business Partner GUID SYSUUID
VALID_FROM Validity Start BUT000 BP Data TZNTSTMPS
TD_SWITCH Planned Change Documents for Partner Were Converted CHAR1
NAME_ORG1 Name 1 of organization BU_NAME
NAME_LAST Last name of business partner (person) BU_NAME
NAME_FIRST First name of business partner (person) BU_NAME
TITLE_ACA1 Academic Title: Key AD_TITLE1
TITLE_ACA2 Second academic title (key) AD_TITLE1
TITLE_ROYL Name supplement, e.g. noble title (key) AD_TITLES
PREFIX1 Name Prefix (Key) AD_PREFIX
NAME_GRP1 Name 1 (group) BU_NAME
NAME_GRP2 Name 2 (group) BU_NAME
TITLE Form-of-Address Key AD_TITLE
NAME1 Name 1 TEXT40
NAME2 Name 2 TEXT40
NAME3 Name 3 TEXT40
NAME4 Name 4 TEXT40
NAME_CO c/o name TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
CITY_CODE City code for city/street file CITY_CODE
CITYP_CODE District code for City and Street file CITYP_CODE
HOME_CITY City (Different from Postal City) TEXT40
CITYH_CODE Different City Coding for City/Street File CITY_CODE
REGIOGROUP Regional structure grouping REGIOGROUP
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
CITY_CODE2 City PO box code (City file) CITY_CODE
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) REGIO
PO_BOX_CTY PO Box of Country/Region LAND1
TRANSPZONE Transportation zone to or from which the goods are delivered ZONE
STREET Street TEXT60
STREETCODE Street Number for City/Street File STRT_CODE
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
LOCATION Street 5 TEXT40
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
COUNTRY Country/Region Key LAND1
REGION Region (State, Province, County) REGIO
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
EXTENSION1 Extension (only for data conversion) (e.g. data line) TEXT40
EXTENSION2 Extension (only for data conversion) (e.g. telebox) TEXT40
TIME_ZONE Address time zone TZNZONE
TAXJURCODE Tax Jurisdiction AD_TXJCD
SMTP_ADDR E-Mail Address AD_SMTPADR
URI_ADDR URI Field Passed to BW PI_AD_URI
TELDISPLAY Display Format for Telephone Number PI_AD_DISP
FAXDISPLAY Display Format for Fax Number PI_AD_DISP
LONGITUDE Geo location longitude GEOLONLAT
LATITUDE Geo location latitude GEOLONLAT
ALTITUDE Geo location height GEOALT
SRCID Geo location data source ID/Geocoder ID CHAR4
ADDRCOMM Address Number AD_ADDRNUM
ADDR_SHORT One-line short form of formatted address CHAR80
ADDR_SHORT_S One-line short form of formatted address CHAR80
LINE0 BP Address: Line 0 LINES
LINE1 BP Address: Line 1 LINES
LINE2 BP Address: Line 2 LINES
LINE3 BP Address: Line 3 LINES
LINE4 BP Address: Line 4 LINES
LINE5 BP Address: Line 5 LINES
LINE6 BP Address: Line 6 LINES
LINE7 BP Address: Line 7 LINES
LINE8 BP Address: Line 8 LINES
LINE9 BP Address: Line 9 LINES
DQ_TIMESTAMP Delta Queue Update Time Stamp TZNTSTMPS