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 |
Possible values
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 |
Possible values
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 |
Possible values
|
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
|