SAP ABAP Table WISO_SHIPTO (SAP Retail Store: Consumer order: Different delivery address)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-SRS (Application Component) SAP Retail Store
     ⤷ WOST_CORE (Package) SAP Retail Store Core Objects

Basic Data

Table Category	INTTAB	Structure
Structure	WISO_SHIPTO	Table Relationship Diagram
Short Description	SAP Retail Store: Consumer order: Different delivery address

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	COUNTRY_DESCR	☐	LANDX	TEXT15	CHAR	15	0	Country Name
2	.INCLUDE	☐				0	0	Communications Fields: SD Document Partner: WWW
3	PARTN_ROLE	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
4	PARTN_NUMB	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
5	ITM_NUMBER	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
6	TITLE	☐	ANRED_VP	ANRED	CHAR	15	0	Form of address
7	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
8	NAME_2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
9	NAME_3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
10	NAME_4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
11	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
12	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	COUNTRY_ISO	☐	LAND1_ISO	INTCA	CHAR	2	0	Country key in ISO code
14	POSTL_CODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
15	POBX_PCD	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
16	POBX_CTY	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
17	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
18	DISTRICT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
19	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
20	PO_BOX	☐	PFACH	PFACH	CHAR	10	0	PO Box
21	TELEPHONE	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
22	TELEPHONE2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
23	TELEBOX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
24	FAX_NUMBER	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
25	TELETEX_NO	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
26	TELEX_NO	☐	TELX1	TEXT30	CHAR	30	0	Telex number
27	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
28	LANGU_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
29	UNLOAD_PT	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
30	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
31	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
32	ADDRESS	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
33	PRIV_ADDR	☐	ADRNP	ADRNR	CHAR	10	0	Private address	*
34	ADDR_TYPE	☐	AD_ADRTYPE	AD_ADRTYPE	CHAR	1	0	Address type (1=Organization, 2=Person, 3=Contact person)
35	ADDR_ORIG	☐	ADDR_ORIGIN	ADDR_ORIGIN	CHAR	1	0	Origin of an address
36	ADDR_LINK	☐	ADDR_LINK	AD_ADDRNUM	CHAR	10	0	Link to address number	*
37	VAT_REG_NO	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
38	.INCLUDE	☐				0	0	SAP Retail Store Sales Order: Print Formatting Address
39	AD_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
40	AD_SHORT_NC	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
41	AD_LINE1	☐	LINES	LINES	CHAR	80	0	Address line
42	AD_LINE1_TP	☐	AD_LINE_TP	AD_LINE_TP	CHAR	1	0	Address line type in the formatted address
43	AD_LINE2	☐	LINES	LINES	CHAR	80	0	Address line
44	AD_LINE2_TP	☐	AD_LINE_TP	AD_LINE_TP	CHAR	1	0	Address line type in the formatted address
45	AD_LINE3	☐	LINES	LINES	CHAR	80	0	Address line
46	AD_LINE3_TP	☐	AD_LINE_TP	AD_LINE_TP	CHAR	1	0	Address line type in the formatted address
47	AD_LINE4	☐	LINES	LINES	CHAR	80	0	Address line
48	AD_LINE4_TP	☐	AD_LINE_TP	AD_LINE_TP	CHAR	1	0	Address line type in the formatted address
49	AD_LINE5	☐	LINES	LINES	CHAR	80	0	Address line
50	AD_LINE5_TP	☐	AD_LINE_TP	AD_LINE_TP	CHAR	1	0	Address line type in the formatted address
51	AD_LINE6	☐	LINES	LINES	CHAR	80	0	Address line
52	AD_LINE6_TP	☐	AD_LINE_TP	AD_LINE_TP	CHAR	1	0	Address line type in the formatted address
53	.INCLU--AP	☐				0	0	SAP Retail Store Sales Order: Add-On for WISO_SHIPTO
54	REGION_DESCR	☐	BEZEI20	TEXT20	CHAR	20	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WISO_SHIPTO	COUNTRY	T005	LAND1
2	WISO_SHIPTO	ITM_NUMBER	VBUP	POSNR
3	WISO_SHIPTO	LANGU	T002	SPRAS
4	WISO_SHIPTO	PARTN_NUMB	KNA1	KUNNR
5	WISO_SHIPTO	PARTN_ROLE	TPAR	PARVW
6	WISO_SHIPTO	REGION	T005S	BLAND
7	WISO_SHIPTO	TAXJURCODE	TTXJ	TXJCD
8	WISO_SHIPTO	TRANSPZONE	TZONE	ZONE1

History

Last changed by/on	SAP	20140121
SAP Release Created in