1. Home
  2. Resources
  3. SAP Tables
  4. BAPIADDRESS - BAPI Transfer Structure for Addresses

SAP Table BAPIADDRESS

BAPI Transfer Structure for Addresses

BAPIADDRESS (BAPI Transfer Structure for Addresses) 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 BAPIADDRESS to other SAP tables.

BAPIADDRESS table fields

Field Data element Checktable Datatype Length Decimals
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
ADDRHANDLE Handle for Creating Addresses/Persons (Bus. Addr. Services) AD_HANDLE CHAR 140 0
NATION Version ID for International Addresses AD_NATION CHAR 1 0
DATE Date referred to AD_DATE DATS 8 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 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 TSAD3 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_TXT Converted name field (with form of address) AD_NAMETXT CHAR 50 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 ADRCITY CHAR 12 0
CITYP_CODE District code for City and Street file AD_CITYPNM ADRCITYPRT CHAR 8 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
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 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
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
LOCATION Street 5 AD_LCTN CHAR 40 0
BUILDING old: building (no. or abbreviation) AD_BLD_OLD CHAR 10 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_SORT1 CHAR 20 0
SORT2 Search Term 2 AD_SORT2 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) (data line/telebox) AD_EXTENS CHAR 40 0
EXTENSION2 Extension (only for data conversion) (data line/telebox) AD_EXTENS 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
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM TSAC CHAR 3 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
BUILD_LONG Building (Number or Code) AD_BLDNG CHAR 20 0

BAPIADDRESS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIADDRESS ADDRORIGIN * TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
BAPIADDRESS ADDRORIGIN BAPIADDRESS ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
BAPIADDRESS CITYP_CODE BAPIADDRESS CITY_CODE ADRCITYPRT Postal districts CITY_CODE
BAPIADDRESS CITYP_CODE BAPIADDRESS CITYP_CODE ADRCITYPRT Postal districts CITYP_CODE
BAPIADDRESS CITYP_CODE * ADRCITYPRT Postal districts CLIENT
BAPIADDRESS CITYP_CODE BAPIADDRESS COUNTRY ADRCITYPRT Postal districts COUNTRY
BAPIADDRESS CITY_CODE * ADRCITY Postal cities CLIENT
BAPIADDRESS CITY_CODE BAPIADDRESS COUNTRY ADRCITY Postal cities COUNTRY
BAPIADDRESS CITY_CODE BAPIADDRESS CITY_CODE ADRCITY Postal cities CITY_CODE
BAPIADDRESS CITY_CODE2 * ADRCITY Postal cities CLIENT
BAPIADDRESS CITY_CODE2 BAPIADDRESS COUNTRY ADRCITY Postal cities COUNTRY
BAPIADDRESS CITY_CODE2 BAPIADDRESS CITY_CODE2 ADRCITY Postal cities CITY_CODE
BAPIADDRESS COUNTRY * T005 Countries MANDT
BAPIADDRESS COUNTRY BAPIADDRESS COUNTRY T005 Countries LAND1
BAPIADDRESS DEFLT_COMM BAPIADDRESS DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
BAPIADDRESS LANGU BAPIADDRESS LANGU T002 Language Keys (Component BC-I18) SPRAS
BAPIADDRESS PO_BOX_CTY * T005 Countries MANDT
BAPIADDRESS PO_BOX_CTY BAPIADDRESS PO_BOX_CTY T005 Countries LAND1
BAPIADDRESS PO_BOX_REG * T005S Taxes: Region (Province) Key MANDT
BAPIADDRESS PO_BOX_REG BAPIADDRESS PO_BOX_CTY T005S Taxes: Region (Province) Key LAND1
BAPIADDRESS PO_BOX_REG BAPIADDRESS PO_BOX_REG T005S Taxes: Region (Province) Key BLAND
BAPIADDRESS REGION * T005S Taxes: Region (Province) Key MANDT
BAPIADDRESS REGION BAPIADDRESS COUNTRY T005S Taxes: Region (Province) Key LAND1
BAPIADDRESS REGION BAPIADDRESS REGION T005S Taxes: Region (Province) Key BLAND
BAPIADDRESS STREETABBR BAPIADDRESS COUNTRY ADRSTRTYPE Street type COUNTRY
BAPIADDRESS STREETABBR BAPIADDRESS STREETABBR ADRSTRTYPE Street type STRTYPEAB
BAPIADDRESS STREETABBR * ADRSTRTYPE Street type CLIENT
BAPIADDRESS STREETCODE * ADRSTREET Streets CLIENT
BAPIADDRESS STREETCODE BAPIADDRESS COUNTRY ADRSTREET Streets COUNTRY
BAPIADDRESS STREETCODE BAPIADDRESS STREETCODE ADRSTREET Streets STRT_CODE
BAPIADDRESS TIME_ZONE * TTZZ Time zones CLIENT
BAPIADDRESS TIME_ZONE BAPIADDRESS TIME_ZONE TTZZ Time zones TZONE
BAPIADDRESS TITLE * TSAD3 Forms of Address (Key) (Business Address Services) CLIENT
BAPIADDRESS TITLE BAPIADDRESS TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
BAPIADDRESS TRANSPZONE * TZONE Customers: Regional zones LAND1
BAPIADDRESS TRANSPZONE BAPIADDRESS TRANSPZONE TZONE Customers: Regional zones ZONE1
BAPIADDRESS TRANSPZONE * TZONE Customers: Regional zones MANDT