SAP table WISO_PLADDR (Plant number and address)

Field Description Data Type Length Decimals Checktable Data Element
PLANT Plant CHAR 4 0 WERKS_D
ADDR_NO Address Number CHAR 10 0 ADRC AD_ADDRNUM
FORMOFADDR Form of address text CHAR 20 0 AD_TITLE_T
NAME Name 1 CHAR 40 0 AD_NAME1
NAME_2 Name 2 CHAR 40 0 AD_NAME2
NAME_3 Name 3 CHAR 40 0 AD_NAME3
NAME_4 Name 4 CHAR 40 0 AD_NAME4
C_O_NAME c/o name CHAR 40 0 AD_NAME_CO
CITY City CHAR 40 0 AD_CITY1
DISTRICT District CHAR 40 0 AD_CITY2
CITY_NO City code for city/street file CHAR 12 0 ADRCITY AD_CITYNUM
POSTL_COD1 City postal code CHAR 10 0 AD_PSTCD1
POSTL_COD2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
POSTL_COD3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
PO_BOX PO Box CHAR 10 0 AD_POBX
PO_BOX_CIT PO Box city CHAR 40 0 AD_POBXLOC
DELIV_DIS (Not Supported) Post Delivery District CHAR 15 0 AD_PSTLAR
STREET Street CHAR 40 0 AD_STR_OLD
STREET_NO Street Number for City/Street File CHAR 12 0 ADRSTREET AD_STRNUM
STR_ABBR (Not Supported) Abbreviation of Street Name CHAR 2 0 ADRSTRTYPE AD_STRABBR
HOUSE_NO House Number CHAR 10 0 AD_HSNM1
STR_SUPPL1 Street 2 CHAR 40 0 AD_STRSPP1
STR_SUPPL2 Street 3 CHAR 40 0 AD_STRSPP2
LOCATION Street 5 CHAR 40 0 AD_LCTN
BUILDING old: building (no. or abbreviation) CHAR 10 0 AD_BLD_OLD
FLOOR Floor in building CHAR 10 0 AD_FLOOR
ROOM_NO Room or Apartment Number CHAR 10 0 AD_ROOMNUM
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
LANGU Language Key LANG 1 0 T002 SPRAS
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
SORT1 Search Term 1 CHAR 20 0 AD_SORT1
SORT2 Search Term 2 CHAR 20 0 AD_SORT2
TIME_ZONE Address time zone CHAR 6 0 TTZZ AD_TZONE
TAXJURCODE Tax Jurisdiction CHAR 15 0 AD_TXJCD
ADR_NOTES Address notes CHAR 50 0 AD_REMARK1
COMM_TYPE Communication Method (Key) (Business Address Services) CHAR 3 0 TSAC AD_COMM
TEL1_NUMBR First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
TEL1_EXT First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
FAX_NUMBER First Fax No.: Area Code + Number CHAR 30 0 AD_FXNMBR1
FAX_EXTENS First fax no.: extension CHAR 10 0 AD_FXXTNS1
STREET_LNG Street CHAR 60 0 AD_STREET
DISTRCT_NO District code for City and Street file CHAR 8 0 ADRCITYPRT AD_CITYPNM
CHCKSTATUS City file test status CHAR 1 0 AD_CHECKST
Not Checked
C checked against city index
D differs from city index
PBOXCIT_NO City PO box code (City file) CHAR 12 0 ADRCITY AD_CIT2NUM
TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
HOUSE_NO2 House number supplement CHAR 10 0 AD_HSNM2
E_MAIL E-Mail Address CHAR 241 0 AD_SMTPADR
STR_SUPPL3 Street 4 CHAR 40 0 AD_STRSPP3
TITLE Title text CHAR 30 0 AD_TITLETX
COUNTRYISO ISO Code of the Country/Region CHAR 2 0 INTCA
LANGU_ISO 2-Character SAP Language Code CHAR 2 0 LAISO
BUILD_LONG Building (Number or Code) CHAR 20 0 AD_BLDNG
REGIOGROUP Regional structure grouping CHAR 8 0 ADRREGGRP REGIOGROUP
HOME_CITY City (different from postal city) CHAR 40 0 AD_CITY3
HOMECITYNO Different city for city/street file CHAR 12 0 * AD_CITYHNM
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR 10 0 AD_PST1XT
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR 10 0 AD_PST2XT
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR 10 0 AD_PST3XT
PO_W_O_NO Flag: PO Box Without Number CHAR 1 0 AD_POBXNUM
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) CHAR 3 0 * AD_POBXREG
POBOX_CTRY PO Box of Country/Region CHAR 3 0 * AD_POBXCTY
PO_CTRYISO ISO Code of the Country/Region CHAR 2 0 INTCA
HOMEPAGE URI, e.g. Homepage or ftp Address CHAR 132 0 AD_URISCR
DONT_USE_S Street Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USES
DONT_USE_P PO Box Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USEP
HOUSE_NO3 (Not supported) House Number Range CHAR 10 0 AD_HSNM3
LANGU_CR Address record creation original language LANG 1 0 * AD_LANGUCR
LANGUCRISO 2-Character SAP Language Code CHAR 2 0 LAISO
PO_BOX_LOBBY PO Box Lobby CHAR 40 0 AD_PO_BOX_LBY
DELI_SERV_TYPE Type of Delivery Service CHAR 4 0 * AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR 10 0 AD_DELIVERY_SERVICE_NUMBER
URI_TYPE URI type flag CHAR 3 0 AD_URITYPE
ACC Bank statement request
FTP FTP address
HPG Homepage (WWW)
INT Intranet page
LOG Company logo
PFB Published Free/Busy information (calendar)
ROU Link to Route Planner
SIP Session Initiation Protocol
STK Callup share prices
COUNTY_CODE County code for county CHAR 8 0 * AD_CNTYNUM
COUNTY County CHAR 40 0 AD_COUNTY
TOWNSHIP_CODE Township code for Township CHAR 8 0 * AD_TWSHPNUM
TOWNSHIP Township CHAR 40 0 AD_TOWNSHIP
XPCPT Business Purpose Completed Flag CHAR 1 0 AD_XPCPT
False
X True
AD_SHORT One-line short form of formatted address CHAR 80 0 AD_LINE_S
AD_SHORT_NC One-line short form of formatted address CHAR 80 0 AD_LINE_S
AD_LINE1 Address line CHAR 80 0 LINES
AD_LINE1_TP Address line type in the formatted address CHAR 1 0 AD_LINE_TP
1 Name1
2 Name 2
3 Name3
4 Name4
5 c/o name
6 Street 2 (field STR_SUPPL1)
7 Street 3 (field STR_SUPPL2)
8 Street 4 (field STR_SUPPL3)
A Form of Address
B PO box
C Postal Code
D Department
E County (Secondary Region)
F Contact person function
G District (Tertiary Region)
H Alternative place of residence
I Street 5 (field LOCATION)
L Country
N Name (and form of address) of a natural person
O City line
P Compulsory empty line
R Region
S Street
T District
Y PO box locker
AD_LINE2 Address line CHAR 80 0 LINES
AD_LINE2_TP Address line type in the formatted address CHAR 1 0 AD_LINE_TP
1 Name1
2 Name 2
3 Name3
4 Name4
5 c/o name
6 Street 2 (field STR_SUPPL1)
7 Street 3 (field STR_SUPPL2)
8 Street 4 (field STR_SUPPL3)
A Form of Address
B PO box
C Postal Code
D Department
E County (Secondary Region)
F Contact person function
G District (Tertiary Region)
H Alternative place of residence
I Street 5 (field LOCATION)
L Country
N Name (and form of address) of a natural person
O City line
P Compulsory empty line
R Region
S Street
T District
Y PO box locker
AD_LINE3 Address line CHAR 80 0 LINES
AD_LINE3_TP Address line type in the formatted address CHAR 1 0 AD_LINE_TP
1 Name1
2 Name 2
3 Name3
4 Name4
5 c/o name
6 Street 2 (field STR_SUPPL1)
7 Street 3 (field STR_SUPPL2)
8 Street 4 (field STR_SUPPL3)
A Form of Address
B PO box
C Postal Code
D Department
E County (Secondary Region)
F Contact person function
G District (Tertiary Region)
H Alternative place of residence
I Street 5 (field LOCATION)
L Country
N Name (and form of address) of a natural person
O City line
P Compulsory empty line
R Region
S Street
T District
Y PO box locker
AD_LINE4 Address line CHAR 80 0 LINES
AD_LINE4_TP Address line type in the formatted address CHAR 1 0 AD_LINE_TP
1 Name1
2 Name 2
3 Name3
4 Name4
5 c/o name
6 Street 2 (field STR_SUPPL1)
7 Street 3 (field STR_SUPPL2)
8 Street 4 (field STR_SUPPL3)
A Form of Address
B PO box
C Postal Code
D Department
E County (Secondary Region)
F Contact person function
G District (Tertiary Region)
H Alternative place of residence
I Street 5 (field LOCATION)
L Country
N Name (and form of address) of a natural person
O City line
P Compulsory empty line
R Region
S Street
T District
Y PO box locker
AD_LINE5 Address line CHAR 80 0 LINES
AD_LINE5_TP Address line type in the formatted address CHAR 1 0 AD_LINE_TP
1 Name1
2 Name 2
3 Name3
4 Name4
5 c/o name
6 Street 2 (field STR_SUPPL1)
7 Street 3 (field STR_SUPPL2)
8 Street 4 (field STR_SUPPL3)
A Form of Address
B PO box
C Postal Code
D Department
E County (Secondary Region)
F Contact person function
G District (Tertiary Region)
H Alternative place of residence
I Street 5 (field LOCATION)
L Country
N Name (and form of address) of a natural person
O City line
P Compulsory empty line
R Region
S Street
T District
Y PO box locker
AD_LINE6 Address line CHAR 80 0 LINES
AD_LINE6_TP Address line type in the formatted address CHAR 1 0 AD_LINE_TP
1 Name1
2 Name 2
3 Name3
4 Name4
5 c/o name
6 Street 2 (field STR_SUPPL1)
7 Street 3 (field STR_SUPPL2)
8 Street 4 (field STR_SUPPL3)
A Form of Address
B PO box
C Postal Code
D Department
E County (Secondary Region)
F Contact person function
G District (Tertiary Region)
H Alternative place of residence
I Street 5 (field LOCATION)
L Country
N Name (and form of address) of a natural person
O City line
P Compulsory empty line
R Region
S Street
T District
Y PO box locker

WISO_PLADDR foreign key relationships

Table Field Check Table Check Field
0 WISO_PLADDR ADDR_NO ADRC Addresses (Business Address Services) DATE_FROM
0 WISO_PLADDR ADDR_NO ADRC Addresses (Business Address Services) NATION
1 WISO_PLADDR CITY_NO ADRCITY Postal cities COUNTRY
1 WISO_PLADDR CITY_NO ADRCITY Postal cities CITY_CODE
0 WISO_PLADDR COMM_TYPE TSAC Communication Methods (Business Address Services) COMM_TYPE
1 WISO_PLADDR COUNTRY T005 Countries MANDT
1 WISO_PLADDR COUNTRY T005 Countries LAND1
0 WISO_PLADDR DISTRCT_NO ADRCITYPRT Postal districts CLIENT
0 WISO_PLADDR DISTRCT_NO ADRCITYPRT Postal districts COUNTRY
0 WISO_PLADDR DISTRCT_NO ADRCITYPRT Postal districts CITY_CODE
1 WISO_PLADDR DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
1 WISO_PLADDR DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
0 WISO_PLADDR DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
0 WISO_PLADDR DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
1 WISO_PLADDR PBOXCIT_NO ADRCITY Postal cities COUNTRY
1 WISO_PLADDR PBOXCIT_NO ADRCITY Postal cities CITY_CODE
0 WISO_PLADDR REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
1 WISO_PLADDR REGION T005S Taxes: Region (Province) Key LAND1
0 WISO_PLADDR STREET_NO ADRSTREET Streets CLIENT
0 WISO_PLADDR STREET_NO ADRSTREET Streets COUNTRY
0 WISO_PLADDR STREET_NO ADRSTREET Streets STRT_CODE
1 WISO_PLADDR STR_ABBR ADRSTRTYPE Street type CLIENT
1 WISO_PLADDR STR_ABBR ADRSTRTYPE Street type COUNTRY
0 WISO_PLADDR TIME_ZONE TTZZ Time zones TZONE
1 WISO_PLADDR TRANSPZONE TZONE Customers: Regional zones MANDT
1 WISO_PLADDR TRANSPZONE TZONE Customers: Regional zones LAND1
1 WISO_PLADDR TRANSPZONE TZONE Customers: Regional zones ZONE1