SAP Table BAPI_BP_ADDR_DATA

BAPI Structure ADRC Attributes Without Name Fields

BAPI_BP_ADDR_DATA (BAPI Structure ADRC Attributes Without Name Fields) 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 BAPI_BP_ADDR_DATA to other SAP tables.

Source: BAPI_BP_ADDR_DATA (BAPI Structure ADRC Attributes Without Name Fields)

BAPI_BP_ADDR_DATA table fields

Field Data element Checktable Datatype Length Decimals
C_O_NAME c/o name AD_NAME_CO CHAR 40 0
CITY City AD_CITY1 CHAR 40 0
DISTRICT District AD_CITY2 CHAR 40 0
CITY_NO City code for city/street file AD_CITYNUM CHAR 12 0
DISTRICT_NO District code for City and Street file AD_CITYPNM CHAR 8 0
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
HOMECITYNO Different city for city/street file AD_CITYHNM CHAR 12 0
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 0
POSTL_COD1 City postal code AD_PSTCD1 CHAR 10 0
POSTL_COD2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
POSTL_COD3 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
PO_W_O_NO Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
PO_BOX_CIT PO Box city AD_POBXLOC CHAR 40 0
PBOXCIT_NO City PO box code (City file) AD_CIT2NUM CHAR 12 0
PO_BOX_REG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
POBOX_CTRY PO box country AD_POBXCTY CHAR 3 0
POBOX_CTRYISO Country ISO code INTCA CHAR 2 0
DELIV_DIS (Not Supported) Post Delivery District AD_PSTLAR CHAR 15 0
TRANSPZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
STREET Street AD_STREET CHAR 60 0
STREET_NO Street Number for City/Street File AD_STRNUM CHAR 12 0
STR_ABBR (Not Supported) Abbreviation of Street Name AD_STRABBR CHAR 2 0
HOUSE_NO House Number AD_HSNM1 CHAR 10 0
HOUSE_NO2 House number supplement AD_HSNM2 CHAR 10 0
HOUSE_NO3 (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
ROOM_NO Room or Appartment Number AD_ROOMNUM CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
COUNTRYISO Country ISO code INTCA CHAR 2 0
LANGU Language Key SPRAS T002 LANG 1 0
LANGU_ISO 2-Character SAP Language Code LAISO CHAR 2 0
REGION Region (State, Province, County) REGIO 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 CHAR 4 0
EXTENS_1 Extension (only for data conversion) (e.g. data line) AD_EXTENS1 CHAR 40 0
EXTENS_2 Extension (only for data conversion) (e.g. telebox) AD_EXTENS2 CHAR 40 0
TIME_ZONE Address time zone AD_TZONE CHAR 6 0
TAXJURCODE Tax Jurisdiction AD_TXJCD CHAR 15 0
ADDRESS_ID (Not supported) Physical address ID AD_ADDR_ID CHAR 10 0
ADR_NOTES Address notes AD_REMARK1 CHAR 50 0
LANGU_CR Address record creation original language AD_LANGUCR T002 LANG 1 0
LANGU_CR_ISO 2-Character SAP Language Code LAISO CHAR 2 0
TEL_CONSNR Seq. number (direct input) BU_CONSNUM CHAR 3 0
TEL_COUNTRY Country Key LAND1 CHAR 3 0
TEL_COUNTRY_ISO Country ISO code INTCA CHAR 2 0
TEL_NUMBER Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
TEL_EXTENSION Telephone no.: Extension AD_TLXTNS CHAR 10 0
TEL_STD_NO Standard Sender Address in this Communication Type AD_FLGDFNR CHAR 1 0
X Yes
NULL No
TEL_COMM_NOTES Communication link notes AD_REMARK2 CHAR 50 0
FAX_CONSNR Seq. number (direct input) BU_CONSNUM CHAR 3 0
FAX_CNTRY Country Key LAND1 CHAR 3 0
FAX_CNTRY_ISO Country ISO code INTCA CHAR 2 0
FAX_NUMBER Fax number: dialling code+number AD_FXNMBR CHAR 30 0
FAX_EXTENS Fax no.: Extension AD_FXXTNS CHAR 10 0
FAX_DEFLT Standard Sender Address in this Communication Type AD_FLGDFNR CHAR 1 0
X Yes
NULL No
FAX_REMARK Communication link notes AD_REMARK2 CHAR 50 0
SMTP_CONSNR Seq. number (direct input) BU_CONSNUM CHAR 3 0
SMTP_ADDR E-Mail Address AD_SMTPADR CHAR 241 0
SMTP_DEFLT Standard Sender Address in this Communication Type AD_FLGDFNR CHAR 1 0
X Yes
NULL No
SMTP_REMARK Communication link notes AD_REMARK2 CHAR 50 0

BAPI_BP_ADDR_DATA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPI_BP_ADDR_DATA LANGU BAPI_BP_ADDR_DATA LANGU T002 Language Keys (Component BC-I18) SPRAS
BAPI_BP_ADDR_DATA LANGU_CR BAPI_BP_ADDR_DATA LANGU_CR T002 Language Keys (Component BC-I18) SPRAS