Technical name: 0CRM_BPDEFADDR_ATTR
Type of DataSource |
Attributes (Master Data) |
Application component |
Master Data Customer Relationship Management (0CRM-IO) |
Available from OLTP Release: |
CRM 2.0B |
Available from Plug-In Release |
N/A |
RemoteCube Compatibility |
no |
For more information, see SAP BP: Extraction of the BP Standard Address .
Delta via extractor
Field in Extract Structure |
Description of Field in the Extract Structure |
Table of Origin |
Field in Table of Origin |
PARTNER |
Business partner number |
BUT020 |
PARTNER |
CITY1 |
City |
ADRC |
CITY1 |
CITY2 |
District |
ADRC |
CITY2 |
CITY_CODE |
City code for city/street file |
ADRC |
CITY_CODE |
CITYP_CODE |
District code for City and Street file |
ADRC |
CITYP_CODE |
REGIOGROUP |
Regional structure grouping |
ADRC |
REGIOGROUP |
POST_CODE1 |
City postal code |
ADRC |
POST_CODE1 |
POST_CODE2 |
P.O. box postal code |
ADRC |
POST_CODE2 |
POST_CODE3 |
Company postal code (for large customers) |
ADRC |
POST_CODE3 |
PO_BOX |
P.O. box |
ADRC |
PO_BOX |
PO_BOX_LOC |
PO Box city |
ADRC |
PO_BOX_LOC |
PO_BOX_REG |
Region for PO Box (Country, State, Province, ...) |
ADRC |
PO_BOX_REG |
PO_BOX_CTY |
PO box country |
ADRC |
PO_BOX_CTY |
TRANSPZONE |
Transportation zone to or from which the goods are delivered |
ADRC |
TRANSPZONE |
STREET |
Street |
ADRC |
STREET |
STREETCODE |
Street code for city/street file |
ADRC |
STREETCODE |
HOUSE_NUM1 |
House number |
ADRC |
HOUSE_NUM1 |
HOUSE_NUM2 |
House number supplement |
ADRC |
HOUSE_NUM2 |
STR_SUPPL1 |
Street 2 |
ADRC |
STR_SUPPL1 |
STR_SUPPL2 |
Street 3 |
ADRC |
STR_SUPPL2 |
STR_SUPPL3 |
Street 4 |
ADRC |
STR_SUPPL3 |
LOCATION |
Street 5 |
ADRC |
LOCATION |
BUILDING |
Building (number or code) |
ADRC |
BUILDING |
FLOOR |
Floor in building |
ADRC |
FLOOR |
ROOMNUMBER |
Room or apartment number |
ADRC |
ROOMNUMBER |
COUNTRY |
Country Key |
ADRC |
COUNTRY |
LANGU |
Language Key |
ADRC |
LANGU |
REGION |
Region (State, Province, County) |
ADRC |
REGION |
TEL_NUMBER |
First telephone no.: dialing code + number |
ADR2 |
TEL_NUMBER |
FAX_NUMBER |
First fax no.: dialing code + number |
ADR3 |
FAX_NUMBER |
TIME_ZONE |
Address time zone |
ADRC |
TIME_ZONE |
TAXJURCODE |
Tax jurisdiction code |
ADRC |
TAXJURCODE |
SMTP_ADDR |
Internet mail (SMTP) address |
ADR6 |
SMTP_ADDR |
ALTITUDE |
Geo location height |
GEOLOC |
ALTITUDE |
LONGITUDE |
Geo location longitude |
GEOLOC |
LONGITUDE |
LATITUDE |
Geo location latitude |
GEOLOC |
LATITUDE |
SCRID |
ID of Data Source Geo-Location/ ID of Geo-Code |
GEOLOC |
SCRID |
PRECISID |
Precision (street, postal code, ...) of a Geo location |
GEOLOC |
PRECISID |