SAP Table BUS000_ADR
BP: Address Data (Read)
BUS000_ADR (BP: Address Data (Read)) 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 BUS000_ADR to other SAP tables.
BUS000_ADR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ADRCITY |
CHAR
|
12 | 0 | |||||||||
|
CITYP_CODE
District code for City and Street file
|
AD_CITYPNM | ADRCITYPRT |
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 | ADRCITY |
CHAR
|
12 | 0 | |||||||||
|
CHCKSTATUS
City file test status
|
AD_CHECKST |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
REGIOGROUP
Regional structure grouping
|
REGIOGROUP | ADRREGGRP |
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 | ||||||||||
|
PCODE1_EXT
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
|
AD_PST1XT |
CHAR
|
10 | 0 | ||||||||||
|
PCODE2_EXT
(Not Supported) PO Box Postal Code Extension
|
AD_PST2XT |
CHAR
|
10 | 0 | ||||||||||
|
PCODE3_EXT
(Not Supported) Major Customer Postal Code Extension
|
AD_PST3XT |
CHAR
|
10 | 0 | ||||||||||
|
PO_BOX
PO Box
|
AD_POBX |
CHAR
|
10 | 0 | ||||||||||
|
DONT_USE_P
PO Box Address Undeliverable Flag
|
AD_NO_USEP | TSAD12 |
CHAR
|
4 | 0 | |||||||||
|
PO_BOX_NUM
Flag: PO Box Without Number
|
AD_POBXNUM |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PO_BOX_LOC
PO Box city
|
AD_POBXLOC |
CHAR
|
40 | 0 | ||||||||||
|
CITY_CODE2
City PO box code (City file)
|
AD_CIT2NUM | ADRCITY |
CHAR
|
12 | 0 | |||||||||
|
PO_BOX_REG
Region for PO Box (Country, State, Province, ...)
|
AD_POBXREG | T005S |
CHAR
|
3 | 0 | |||||||||
|
PO_BOX_CTY
PO box country
|
AD_POBXCTY | T005 |
CHAR
|
3 | 0 | |||||||||
|
POSTALAREA
(Not Supported) Post Delivery District
|
AD_PSTLAR |
CHAR
|
15 | 0 | ||||||||||
|
TRANSPZONE
Transportation zone to or from which the goods are delivered
|
LZONE | TZONE |
CHAR
|
10 | 0 | |||||||||
|
STREET
Street
|
AD_STREET |
CHAR
|
60 | 0 | ||||||||||
|
DONT_USE_S
Street Address Undeliverable Flag
|
AD_NO_USES | TSAD12 |
CHAR
|
4 | 0 | |||||||||
|
STREETCODE
Street Number for City/Street File
|
AD_STRNUM | ADRSTREET |
CHAR
|
12 | 0 | |||||||||
|
STREETABBR
(Not Supported) Abbreviation of Street Name
|
AD_STRABBR | ADRSTRTYPE |
CHAR
|
2 | 0 | |||||||||
|
HOUSE_NUM1
House Number
|
AD_HSNM1 |
CHAR
|
10 | 0 | ||||||||||
|
HOUSE_NUM2
House number supplement
|
AD_HSNM2 |
CHAR
|
10 | 0 | ||||||||||
|
HOUSE_NUM3
(Not supported) House Number Range
|
AD_HSNM3 |
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 | T005 |
CHAR
|
3 | 0 | |||||||||
|
LANGU
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||
|
REGION
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||
|
SORT1
Search Term 1
|
AD_SORT1UL |
CHAR
|
20 | 0 | ||||||||||
|
SORT2
Search Term 2
|
AD_SORT2UL |
CHAR
|
20 | 0 | ||||||||||
|
SORT_PHN
(Not Supported) Phonetic Search Sort Field
|
AD_SRTPHN |
CHAR
|
20 | 0 | ||||||||||
|
ADDRORIGIN
(Not Supported) Address Data Source (Key)
|
AD_ORIGINA | TSAD6 |
CHAR
|
4 | 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 | TTZZ |
CHAR
|
6 | 0 | |||||||||
|
TAXJURCODE
Tax Jurisdiction
|
AD_TXJCD |
CHAR
|
15 | 0 | ||||||||||
|
ADDRESS_ID
(Not supported) Physical address ID
|
AD_ADDR_ID |
CHAR
|
10 | 0 | ||||||||||
|
REMARK
Address notes
|
AD_REMARK1 |
CHAR
|
50 | 0 | ||||||||||
|
LANGU_CREA
Address record creation original language
|
AD_LANGUCR | T002 |
LANG
|
1 | 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 | ADDRC_DELI_SERV |
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 | ADRCOUNTY |
CHAR
|
8 | 0 | |||||||||
|
COUNTY
County
|
AD_COUNTY |
CHAR
|
40 | 0 | ||||||||||
|
TOWNSHIP_CODE
Township code for Township
|
AD_TWSHPNUM | ADRTOWNSHIP |
CHAR
|
8 | 0 | |||||||||
|
TOWNSHIP
Township
|
AD_TOWNSHIP |
CHAR
|
40 | 0 | ||||||||||
|
DEFLT_COMM
Standard communication type
|
AD_DFLTCMM | TSADC |
CHAR
|
3 | 0 | |||||||||
|
TEL_NUMBER
Telephone no.: dialling code+number
|
AD_TLNMBR |
CHAR
|
30 | 0 | ||||||||||
|
TEL_EXTENS
Telephone no.: Extension
|
AD_TLXTNS |
CHAR
|
10 | 0 | ||||||||||
|
FAX_NUMBER
Fax number: dialling code+number
|
AD_FXNMBR |
CHAR
|
30 | 0 | ||||||||||
|
FAX_EXTENS
Fax no.: Extension
|
AD_FXXTNS |
CHAR
|
10 | 0 | ||||||||||
|
VALID_FROM
Valid From
|
BU_VALID_FROM_DATS |
DATS
|
8 | 0 | ||||||||||
|
VALID_TO
Valid To
|
BU_VALID_TO_DATS |
DATS
|
8 | 0 | ||||||||||
BUS000_ADR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| BUS000_ADR | ADDRORIGIN | * |
TSAD6
Source Address or Personal Data (Business Address Services)
|
CLIENT | |
| BUS000_ADR | ADDRORIGIN | BUS000_ADR | ADDRORIGIN |
TSAD6
Source Address or Personal Data (Business Address Services)
|
ORIGIN |
| BUS000_ADR | CITYH_CODE | * |
ADRCITY
Postal cities
|
CLIENT | |
| BUS000_ADR | CITYH_CODE | BUS000_ADR | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| BUS000_ADR | CITYH_CODE | BUS000_ADR | CITYH_CODE |
ADRCITY
Postal cities
|
CITY_CODE |
| BUS000_ADR | CITYP_CODE | * |
ADRCITYPRT
Postal districts
|
CLIENT | |
| BUS000_ADR | CITYP_CODE | BUS000_ADR | COUNTRY |
ADRCITYPRT
Postal districts
|
COUNTRY |
| BUS000_ADR | CITYP_CODE | BUS000_ADR | CITY_CODE |
ADRCITYPRT
Postal districts
|
CITY_CODE |
| BUS000_ADR | CITYP_CODE | BUS000_ADR | CITYP_CODE |
ADRCITYPRT
Postal districts
|
CITYP_CODE |
| BUS000_ADR | CITY_CODE | BUS000_ADR | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| BUS000_ADR | CITY_CODE | BUS000_ADR | CITY_CODE |
ADRCITY
Postal cities
|
CITY_CODE |
| BUS000_ADR | CITY_CODE | * |
ADRCITY
Postal cities
|
CLIENT | |
| BUS000_ADR | CITY_CODE2 | * |
ADRCITY
Postal cities
|
CLIENT | |
| BUS000_ADR | CITY_CODE2 | BUS000_ADR | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| BUS000_ADR | CITY_CODE2 | BUS000_ADR | CITY_CODE2 |
ADRCITY
Postal cities
|
CITY_CODE |
| BUS000_ADR | COUNTRY | * |
T005
Countries
|
MANDT | |
| BUS000_ADR | COUNTRY | BUS000_ADR | COUNTRY |
T005
Countries
|
LAND1 |
| BUS000_ADR | COUNTY_CODE | BUS000_ADR | PO_BOX_CTY |
ADRCOUNTY
County codes
|
COUNTRY |
| BUS000_ADR | COUNTY_CODE | BUS000_ADR | PO_BOX_REG |
ADRCOUNTY
County codes
|
REGION |
| BUS000_ADR | COUNTY_CODE | BUS000_ADR | COUNTY_CODE |
ADRCOUNTY
County codes
|
COUNTY_CODE |
| BUS000_ADR | COUNTY_CODE | SYST | MANDT |
ADRCOUNTY
County codes
|
CLIENT |
| BUS000_ADR | DEFLT_COMM | BUS000_ADR | DEFLT_COMM |
TSADC
Address administration: Communications types administration
|
COMINT |
| BUS000_ADR | DELI_SERV_TYPE | SYST | MANDT |
ADDRC_DELI_SERV
Address Service Types
|
CLIENT |
| BUS000_ADR | DELI_SERV_TYPE | BUS000_ADR | DELI_SERV_TYPE |
ADDRC_DELI_SERV
Address Service Types
|
DELI_SERV_TYPE |
| BUS000_ADR | DONT_USE_P | SYST | MANDT |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
CLIENT |
| BUS000_ADR | DONT_USE_P | BUS000_ADR | DONT_USE_P |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
UNDELIVER |
| BUS000_ADR | DONT_USE_S | SYST | MANDT |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
CLIENT |
| BUS000_ADR | DONT_USE_S | BUS000_ADR | DONT_USE_S |
TSAD12
Reasons for Non-Delivery (Business Address Services)
|
UNDELIVER |
| BUS000_ADR | LANGU | BUS000_ADR | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| BUS000_ADR | LANGU_CREA | BUS000_ADR | LANGU_CREA |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| BUS000_ADR | PO_BOX_CTY | * |
T005
Countries
|
MANDT | |
| BUS000_ADR | PO_BOX_CTY | BUS000_ADR | PO_BOX_CTY |
T005
Countries
|
LAND1 |
| BUS000_ADR | PO_BOX_REG | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| BUS000_ADR | PO_BOX_REG | BUS000_ADR | PO_BOX_CTY |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| BUS000_ADR | PO_BOX_REG | BUS000_ADR | PO_BOX_REG |
T005S
Taxes: Region (Province) Key
|
BLAND |
| BUS000_ADR | REGIOGROUP | * |
ADRREGGRP
Regional structure grouping
|
CLIENT | |
| BUS000_ADR | REGIOGROUP | BUS000_ADR | REGIOGROUP |
ADRREGGRP
Regional structure grouping
|
REGIOGROUP |
| BUS000_ADR | REGION | BUS000_ADR | REGION |
T005S
Taxes: Region (Province) Key
|
BLAND |
| BUS000_ADR | REGION | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| BUS000_ADR | REGION | BUS000_ADR | COUNTRY |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| BUS000_ADR | STREETABBR | * |
ADRSTRTYPE
Street type
|
CLIENT | |
| BUS000_ADR | STREETABBR | BUS000_ADR | COUNTRY |
ADRSTRTYPE
Street type
|
COUNTRY |
| BUS000_ADR | STREETABBR | BUS000_ADR | STREETABBR |
ADRSTRTYPE
Street type
|
STRTYPEAB |
| BUS000_ADR | STREETCODE | BUS000_ADR | COUNTRY |
ADRSTREET
Streets
|
COUNTRY |
| BUS000_ADR | STREETCODE | BUS000_ADR | STREETCODE |
ADRSTREET
Streets
|
STRT_CODE |
| BUS000_ADR | STREETCODE | * |
ADRSTREET
Streets
|
CLIENT | |
| BUS000_ADR | TIME_ZONE | * |
TTZZ
Time zones
|
CLIENT | |
| BUS000_ADR | TIME_ZONE | BUS000_ADR | TIME_ZONE |
TTZZ
Time zones
|
TZONE |
| BUS000_ADR | TOWNSHIP_CODE | SYST | MANDT |
ADRTOWNSHIP
Township codes
|
CLIENT |
| BUS000_ADR | TOWNSHIP_CODE | BUS000_ADR | PO_BOX_CTY |
ADRTOWNSHIP
Township codes
|
COUNTRY |
| BUS000_ADR | TOWNSHIP_CODE | BUS000_ADR | PO_BOX_REG |
ADRTOWNSHIP
Township codes
|
REGION |
| BUS000_ADR | TOWNSHIP_CODE | BUS000_ADR | COUNTY_CODE |
ADRTOWNSHIP
Township codes
|
COUNTY_CODE |
| BUS000_ADR | TOWNSHIP_CODE | BUS000_ADR | TOWNSHIP_CODE |
ADRTOWNSHIP
Township codes
|
TOWNSHIP_CODE |
| BUS000_ADR | TRANSPZONE | BUS000_ADR | COUNTRY |
TZONE
Customers: Regional zones
|
LAND1 |
| BUS000_ADR | TRANSPZONE | BUS000_ADR | TRANSPZONE |
TZONE
Customers: Regional zones
|
ZONE1 |
| BUS000_ADR | TRANSPZONE | * |
TZONE
Customers: Regional zones
|
MANDT |