SAP Table WSPO_VNDR

SAP Retail Store PO: Vendor/Supplying Plant

WSPO_VNDR (SAP Retail Store PO: Vendor/Supplying Plant) 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 WSPO_VNDR to other SAP tables.

WSPO_VNDR table fields

Field Data element Checktable Datatype Length Decimals
VNDR_ID SAP Retail Store: Vendor or Plant Number WSRS_VENDOR_SITE_ID CHAR 10 0
VNDR_TYPE SAP Retail Store: Indicator Vendor or Plant WSRS_VENDOR_SITE_TYPE CHAR 1 0
NULL Unknown
1 External Vendor
2 Plant
VENDOR_NO Account Number of Vendor or Creditor LIFNR CHAR 10 0
PLANT Plant WERKS_D CHAR 4 0
VNDR_TYPE_D SAP Retail Store: Description 20 Characters WSRS_DESCR_20 CHAR 20 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
NULL Not checked
C checked against city index
D differs from city index
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
HOME_CITY City (different from postal city) AD_CITY3 CHAR 40 0
HOMECITYNO Different city for city/street file AD_CITYHNM CHAR 12 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_W_O_NO Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
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
PO_CTRYISO Country ISO code INTCA CHAR 2 0
HOMEPAGE URI, e.g. Homepage or ftp Address AD_URISCR CHAR 132 0
DONT_USE_S Street Address Undeliverable Flag AD_NO_USES TSAD12 CHAR 4 0
DONT_USE_P PO Box Address Undeliverable Flag AD_NO_USEP TSAD12 CHAR 4 0
HOUSE_NO3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
LANGU_CR Address record creation original language AD_LANGUCR LANG 1 0
LANGUCRISO 2-Character SAP Language Code LAISO CHAR 2 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 CHAR 4 0
DELI_SERV_NUMBER Number of Delivery Service AD_DELIVERY_SERVICE_NUMBER CHAR 10 0
URI_TYPE URI type flag AD_URITYPE CHAR 3 0
HPG Homepage (WWW)
FTP FTP address
STK Callup share prices
ACC Bank statement request
INT Intranet page
LOG Company logo
PFB Published Free/Busy information (calendar)
ROU Link to Route Planner
SIP Session Initiation Protocol
COUNTY_CODE County code for county AD_CNTYNUM CHAR 8 0
COUNTY County AD_COUNTY CHAR 40 0
TOWNSHIP_CODE Township code for Township AD_TWSHPNUM CHAR 8 0
TOWNSHIP Township AD_TOWNSHIP CHAR 40 0
AD_SHORT One-line short form of formatted address AD_LINE_S CHAR 80 0
AD_SHORT_NC One-line short form of formatted address AD_LINE_S CHAR 80 0
AD_LINE1 Address line LINES CHAR 80 0
AD_LINE1_TP Address line type in the formatted address AD_LINE_TP CHAR 1 0
A Form of Address
P Compulsory empty line
F Contact person function
4 Name4
3 Name3
R Region
T District
7 Street 3 (field STR_SUPPL2)
I Street 5 (field LOCATION)
8 Street 4 (field STR_SUPPL3)
6 Street 2 (field STR_SUPPL1)
L Country
C Postal Code
2 Name 2
B PO box
S Street
5 c/o name
N Name (and form of address) of a natural person
D Department
O City line
1 Name1
H Alternative place of residence
Y PO box locker
AD_LINE2 Address line LINES CHAR 80 0
AD_LINE2_TP Address line type in the formatted address AD_LINE_TP CHAR 1 0
A Form of Address
P Compulsory empty line
F Contact person function
4 Name4
3 Name3
R Region
T District
7 Street 3 (field STR_SUPPL2)
I Street 5 (field LOCATION)
8 Street 4 (field STR_SUPPL3)
6 Street 2 (field STR_SUPPL1)
L Country
C Postal Code
2 Name 2
B PO box
S Street
5 c/o name
N Name (and form of address) of a natural person
D Department
O City line
1 Name1
H Alternative place of residence
Y PO box locker
AD_LINE3 Address line LINES CHAR 80 0
AD_LINE3_TP Address line type in the formatted address AD_LINE_TP CHAR 1 0
A Form of Address
P Compulsory empty line
F Contact person function
4 Name4
3 Name3
R Region
T District
7 Street 3 (field STR_SUPPL2)
I Street 5 (field LOCATION)
8 Street 4 (field STR_SUPPL3)
6 Street 2 (field STR_SUPPL1)
L Country
C Postal Code
2 Name 2
B PO box
S Street
5 c/o name
N Name (and form of address) of a natural person
D Department
O City line
1 Name1
H Alternative place of residence
Y PO box locker
AD_LINE4 Address line LINES CHAR 80 0
AD_LINE4_TP Address line type in the formatted address AD_LINE_TP CHAR 1 0
A Form of Address
P Compulsory empty line
F Contact person function
4 Name4
3 Name3
R Region
T District
7 Street 3 (field STR_SUPPL2)
I Street 5 (field LOCATION)
8 Street 4 (field STR_SUPPL3)
6 Street 2 (field STR_SUPPL1)
L Country
C Postal Code
2 Name 2
B PO box
S Street
5 c/o name
N Name (and form of address) of a natural person
D Department
O City line
1 Name1
H Alternative place of residence
Y PO box locker
AD_LINE5 Address line LINES CHAR 80 0
AD_LINE5_TP Address line type in the formatted address AD_LINE_TP CHAR 1 0
A Form of Address
P Compulsory empty line
F Contact person function
4 Name4
3 Name3
R Region
T District
7 Street 3 (field STR_SUPPL2)
I Street 5 (field LOCATION)
8 Street 4 (field STR_SUPPL3)
6 Street 2 (field STR_SUPPL1)
L Country
C Postal Code
2 Name 2
B PO box
S Street
5 c/o name
N Name (and form of address) of a natural person
D Department
O City line
1 Name1
H Alternative place of residence
Y PO box locker
AD_LINE6 Address line LINES CHAR 80 0
AD_LINE6_TP Address line type in the formatted address AD_LINE_TP CHAR 1 0
A Form of Address
P Compulsory empty line
F Contact person function
4 Name4
3 Name3
R Region
T District
7 Street 3 (field STR_SUPPL2)
I Street 5 (field LOCATION)
8 Street 4 (field STR_SUPPL3)
6 Street 2 (field STR_SUPPL1)
L Country
C Postal Code
2 Name 2
B PO box
S Street
5 c/o name
N Name (and form of address) of a natural person
D Department
O City line
1 Name1
H Alternative place of residence
Y PO box locker

WSPO_VNDR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WSPO_VNDR ADDR_NO * ADRC Addresses (Business Address Services) NATION
WSPO_VNDR ADDR_NO * ADRC Addresses (Business Address Services) CLIENT
WSPO_VNDR ADDR_NO WSPO_VNDR ADDR_NO ADRC Addresses (Business Address Services) ADDRNUMBER
WSPO_VNDR ADDR_NO * ADRC Addresses (Business Address Services) DATE_FROM
WSPO_VNDR CITY_NO * ADRCITY Postal cities CLIENT
WSPO_VNDR CITY_NO WSPO_VNDR COUNTRY ADRCITY Postal cities COUNTRY
WSPO_VNDR CITY_NO WSPO_VNDR CITY_NO ADRCITY Postal cities CITY_CODE
WSPO_VNDR COMM_TYPE WSPO_VNDR COMM_TYPE TSAC Communication Methods (Business Address Services) COMM_TYPE
WSPO_VNDR COUNTRY WSPO_VNDR COUNTRY T005 Countries LAND1
WSPO_VNDR COUNTRY * T005 Countries MANDT
WSPO_VNDR DISTRCT_NO * ADRCITYPRT Postal districts CLIENT
WSPO_VNDR DISTRCT_NO WSPO_VNDR COUNTRY ADRCITYPRT Postal districts COUNTRY
WSPO_VNDR DISTRCT_NO WSPO_VNDR CITY_NO ADRCITYPRT Postal districts CITY_CODE
WSPO_VNDR DISTRCT_NO WSPO_VNDR DISTRCT_NO ADRCITYPRT Postal districts CITYP_CODE
WSPO_VNDR DONT_USE_P WSPO_VNDR DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
WSPO_VNDR DONT_USE_P SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
WSPO_VNDR DONT_USE_S SYST MANDT TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
WSPO_VNDR DONT_USE_S WSPO_VNDR DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
WSPO_VNDR LANGU WSPO_VNDR LANGU T002 Language Keys (Component BC-I18) SPRAS
WSPO_VNDR PBOXCIT_NO WSPO_VNDR COUNTRY ADRCITY Postal cities COUNTRY
WSPO_VNDR PBOXCIT_NO WSPO_VNDR PBOXCIT_NO ADRCITY Postal cities CITY_CODE
WSPO_VNDR PBOXCIT_NO * ADRCITY Postal cities CLIENT
WSPO_VNDR REGIOGROUP * ADRREGGRP Regional structure grouping CLIENT
WSPO_VNDR REGIOGROUP WSPO_VNDR REGIOGROUP ADRREGGRP Regional structure grouping REGIOGROUP
WSPO_VNDR REGION * T005S Taxes: Region (Province) Key MANDT
WSPO_VNDR REGION WSPO_VNDR COUNTRY T005S Taxes: Region (Province) Key LAND1
WSPO_VNDR REGION WSPO_VNDR REGION T005S Taxes: Region (Province) Key BLAND
WSPO_VNDR STREET_NO * ADRSTREET Streets CLIENT
WSPO_VNDR STREET_NO WSPO_VNDR COUNTRY ADRSTREET Streets COUNTRY
WSPO_VNDR STREET_NO WSPO_VNDR STREET_NO ADRSTREET Streets STRT_CODE
WSPO_VNDR STR_ABBR * ADRSTRTYPE Street type CLIENT
WSPO_VNDR STR_ABBR WSPO_VNDR COUNTRY ADRSTRTYPE Street type COUNTRY
WSPO_VNDR STR_ABBR WSPO_VNDR STR_ABBR ADRSTRTYPE Street type STRTYPEAB
WSPO_VNDR TIME_ZONE * TTZZ Time zones CLIENT
WSPO_VNDR TIME_ZONE WSPO_VNDR TIME_ZONE TTZZ Time zones TZONE
WSPO_VNDR TRANSPZONE * TZONE Customers: Regional zones MANDT
WSPO_VNDR TRANSPZONE WSPO_VNDR COUNTRY TZONE Customers: Regional zones LAND1
WSPO_VNDR TRANSPZONE WSPO_VNDR TRANSPZONE TZONE Customers: Regional zones ZONE1