SAP Table BAPIMEPOADDRVENDOR
PO Header: Address Structure BAPIADDR1 for Vendor
BAPIMEPOADDRVENDOR (PO Header: Address Structure BAPIADDR1 for Vendor) 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 BAPIMEPOADDRVENDOR to other SAP tables.
BAPIMEPOADDRVENDOR table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PO_NUMBER | Purchasing Document Number | EBELN | CHAR | 10 | 0 | |||||||||
ADDR_NO | Address number | AD_ADDRNUM | ADRC | CHAR | 10 | 0 | ||||||||
FORMOFADDR | Form of address text | AD_TITLE_T | CHAR | 20 | 0 | |||||||||
NAME | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||||||||
NAME_2 | Name 2 | AD_NAME2 | CHAR | 40 | 0 | |||||||||
NAME_3 | Name 3 | AD_NAME3 | CHAR | 40 | 0 | |||||||||
NAME_4 | Name 4 | AD_NAME4 | CHAR | 40 | 0 | |||||||||
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 | ADRCITY | CHAR | 12 | 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 | |||||||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | 0 | |||||||||
PO_BOX_CIT | PO Box city | AD_POBXLOC | CHAR | 40 | 0 | |||||||||
DELIV_DIS | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | 0 | |||||||||
STREET | Street | AD_STR_OLD | CHAR | 40 | 0 | |||||||||
STREET_NO | Street Number for City/Street File | AD_STRNUM | ADRSTREET | CHAR | 12 | 0 | ||||||||
STR_ABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | ADRSTRTYPE | CHAR | 2 | 0 | ||||||||
HOUSE_NO | House Number | AD_HSNM1 | 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 | |||||||||
ROOM_NO | 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 | |||||||||
TIME_ZONE | Address time zone | AD_TZONE | TTZZ | CHAR | 6 | 0 | ||||||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | 0 | |||||||||
ADR_NOTES | Address notes | AD_REMARK1 | CHAR | 50 | 0 | |||||||||
COMM_TYPE | Communication Method (Key) (Business Address Services) | AD_COMM | TSAC | CHAR | 3 | 0 | ||||||||
TEL1_NUMBR | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | 0 | |||||||||
TEL1_EXT | 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 | |||||||||
STREET_LNG | Street | AD_STREET | CHAR | 60 | 0 | |||||||||
DISTRCT_NO | District code for City and Street file | AD_CITYPNM | ADRCITYPRT | CHAR | 8 | 0 | ||||||||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | 0 |
Possible values
|
||||||||
PBOXCIT_NO | City PO box code (City file) | AD_CIT2NUM | ADRCITY | CHAR | 12 | 0 | ||||||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 | 0 | ||||||||
HOUSE_NO2 | House number supplement | AD_HSNM2 | CHAR | 10 | 0 | |||||||||
E_MAIL | E-Mail Address | AD_SMTPADR | CHAR | 241 | 0 | |||||||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | 0 | |||||||||
TITLE | Title text | AD_TITLETX | CHAR | 30 | 0 | |||||||||
COUNTRYISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | 0 | |||||||||
BUILD_LONG | Building (Number or Code) | AD_BLDNG | CHAR | 20 | 0 | |||||||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | ADRREGGRP | CHAR | 8 | 0 |
BAPIMEPOADDRVENDOR foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
BAPIMEPOADDRVENDOR | ADDR_NO | * | ADRC | Addresses (Business Address Services) | NATION | |
BAPIMEPOADDRVENDOR | ADDR_NO | * | ADRC | Addresses (Business Address Services) | CLIENT | |
BAPIMEPOADDRVENDOR | ADDR_NO | BAPIMEPOADDRVENDOR | ADDR_NO | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
BAPIMEPOADDRVENDOR | ADDR_NO | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
BAPIMEPOADDRVENDOR | CITY_NO | * | ADRCITY | Postal cities | CLIENT | |
BAPIMEPOADDRVENDOR | CITY_NO | BAPIMEPOADDRVENDOR | COUNTRY | ADRCITY | Postal cities | COUNTRY |
BAPIMEPOADDRVENDOR | CITY_NO | BAPIMEPOADDRVENDOR | CITY_NO | ADRCITY | Postal cities | CITY_CODE |
BAPIMEPOADDRVENDOR | COMM_TYPE | BAPIMEPOADDRVENDOR | COMM_TYPE | TSAC | Communication Methods (Business Address Services) | COMM_TYPE |
BAPIMEPOADDRVENDOR | COUNTRY | BAPIMEPOADDRVENDOR | COUNTRY | T005 | Countries | LAND1 |
BAPIMEPOADDRVENDOR | COUNTRY | * | T005 | Countries | MANDT | |
BAPIMEPOADDRVENDOR | DISTRCT_NO | * | ADRCITYPRT | Postal districts | CLIENT | |
BAPIMEPOADDRVENDOR | DISTRCT_NO | BAPIMEPOADDRVENDOR | COUNTRY | ADRCITYPRT | Postal districts | COUNTRY |
BAPIMEPOADDRVENDOR | DISTRCT_NO | BAPIMEPOADDRVENDOR | CITY_NO | ADRCITYPRT | Postal districts | CITY_CODE |
BAPIMEPOADDRVENDOR | DISTRCT_NO | BAPIMEPOADDRVENDOR | DISTRCT_NO | ADRCITYPRT | Postal districts | CITYP_CODE |
BAPIMEPOADDRVENDOR | LANGU | BAPIMEPOADDRVENDOR | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
BAPIMEPOADDRVENDOR | PBOXCIT_NO | BAPIMEPOADDRVENDOR | COUNTRY | ADRCITY | Postal cities | COUNTRY |
BAPIMEPOADDRVENDOR | PBOXCIT_NO | BAPIMEPOADDRVENDOR | PBOXCIT_NO | ADRCITY | Postal cities | CITY_CODE |
BAPIMEPOADDRVENDOR | PBOXCIT_NO | * | ADRCITY | Postal cities | CLIENT | |
BAPIMEPOADDRVENDOR | REGIOGROUP | * | ADRREGGRP | Regional structure grouping | CLIENT | |
BAPIMEPOADDRVENDOR | REGIOGROUP | BAPIMEPOADDRVENDOR | REGIOGROUP | ADRREGGRP | Regional structure grouping | REGIOGROUP |
BAPIMEPOADDRVENDOR | REGION | * | T005S | Taxes: Region (Province) Key | MANDT | |
BAPIMEPOADDRVENDOR | REGION | BAPIMEPOADDRVENDOR | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
BAPIMEPOADDRVENDOR | REGION | BAPIMEPOADDRVENDOR | REGION | T005S | Taxes: Region (Province) Key | BLAND |
BAPIMEPOADDRVENDOR | STREET_NO | * | ADRSTREET | Streets | CLIENT | |
BAPIMEPOADDRVENDOR | STREET_NO | BAPIMEPOADDRVENDOR | COUNTRY | ADRSTREET | Streets | COUNTRY |
BAPIMEPOADDRVENDOR | STREET_NO | BAPIMEPOADDRVENDOR | STREET_NO | ADRSTREET | Streets | STRT_CODE |
BAPIMEPOADDRVENDOR | STR_ABBR | * | ADRSTRTYPE | Street type | CLIENT | |
BAPIMEPOADDRVENDOR | STR_ABBR | BAPIMEPOADDRVENDOR | COUNTRY | ADRSTRTYPE | Street type | COUNTRY |
BAPIMEPOADDRVENDOR | STR_ABBR | BAPIMEPOADDRVENDOR | STR_ABBR | ADRSTRTYPE | Street type | STRTYPEAB |
BAPIMEPOADDRVENDOR | TIME_ZONE | BAPIMEPOADDRVENDOR | TIME_ZONE | TTZZ | Time zones | TZONE |
BAPIMEPOADDRVENDOR | TIME_ZONE | * | TTZZ | Time zones | CLIENT | |
BAPIMEPOADDRVENDOR | TRANSPZONE | * | TZONE | Customers: Regional zones | MANDT | |
BAPIMEPOADDRVENDOR | TRANSPZONE | BAPIMEPOADDRVENDOR | COUNTRY | TZONE | Customers: Regional zones | LAND1 |
BAPIMEPOADDRVENDOR | TRANSPZONE | BAPIMEPOADDRVENDOR | TRANSPZONE | TZONE | Customers: Regional zones | ZONE1 |