SAP ABAP Table WISO_ITEM (SAP Retail Store: IAC Consumer Order. Subscr. Item Display)

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_ITEM	Table Relationship Diagram
Short Description	SAP Retail Store: IAC Consumer Order. Subscr. Item Display

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	.INCLUDE	☐				0	0	SAP Retail Store: IAC Consumer Order, Key Fields Item
2	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
3	PO_ITM_NO	☐	W_WISO_HANDLE_POSEX	POSEX	CHAR	6	0	SAP Retail Store Sales Order: Handle Sales Document Item
4	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
5	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
6	UNIT	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	*
7	QUAN_REQ	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
8	QUAN_AVAIL	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
9	PRICE_ITM_SUM	☐	W_WISO_PRICE_ITM_SUM	WERTV8	CURR	15	2	SAP Retail Store Sales Order: Item Value
10	CURR	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
11	NET_VALUE	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
12	TAX_AMOUNT	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
13	DLV_DATE	☐	EDATU	DATUM	DATS	8	0	Schedule line date
14	NUMB_DLVS	☐	W_NUMB_DLVS	NUMC4	NUMC	4	0	SAP Store Order: Number of delivery schedules/deliveries
15	PLANT_DLV	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
16	REA_FOR_RE	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
17	REL_FOR_BI	☐	FKREL	FKREL	CHAR	1	0	Relevant for Billing
18	.INCLU--AP	☐				0	0	SAP Retail Store Sales Order: WISO_ITM Append
19	HG_LV_ITEM	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
20	.INCLUDE	☐				0	0	SAP Ret.Store: IAC Cons. order as per fields BASKET and ITEM
21	UNAVAIL_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
22	THIRD_PTY	☐	W_THIRD_PTY	XFELD	CHAR	1	0	Indicates direct delivery
23	NAME_PLANT_DLV	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
24	CITY_PLANT_DLV	☐	AD_CITY1	TEXT40	CHAR	40	0	City
25	ITEM_CATEG	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
26	PO_ITEM_CAT	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
27	PO_ITEM_CAT_DESC	☐	PTEXT_D	TEXT20	CHAR	20	0	Text for Item Category
28	REA_FOR_RE_DESCR	☐	BEZEI40	TEXT40	CHAR	40	0	Description
29	MSG_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
30	.INCLU--AP	☐				0	0	SAP Retail Store Sales Order: WISO_BAIT Append
31	MAT_ID_INPUT	☐	W_WISO_MAT_ID_INPUT	W_WISO_MAT_ID_INPUT	CHAR	40	0	SAP Retail Store: Store Order: Material Identifier
32	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
33	T184_KEY	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
34	ITMCAT_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
35	ITEM_CATEG_DESCR	☐	BEZEI20	TEXT20	CHAR	20	0	Description
36	DLV_CLLCT	☐	W_DLV_CLLCT	CHAR01	CHAR	1	0	Indicates delivery/ collection
37	DLV_CLLCT_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
38	SHIP_POINT	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
39	DLV_GROUP	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
40	PLANT_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
41	MARKED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
42	QUAN_REF_OPEN	☐	ORFMNG	MENG13	QUAN	13	3	Open reference quantity
43	REA_RE_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
44	ITEM_CATEG_AUTO	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
45	ITEM_CAT	☐	MTPOS	MTPOS	CHAR	4	0	Item category group from material master	*
46	SCHED_TYPE	☐	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	*
47	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
48	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
49	EXISTS_IN_DB	☐	XFELD	XFELD	CHAR	1	0	Checkbox
50	MAT_ENTRD	☐	MATWA	MATNR	CHAR	18	0	Material entered	*
51	.INCLU--AP	☐				0	0	SAP Retail Store Sales Order: WISO_ITEM Append
52	REF_DOC	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
53	REF_DOC_IT	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
54	SUBTOTAL_1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
55	SUBTOTAL_2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
56	SUBTOTAL_3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
57	SUBTOTAL_4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
58	SUBTOTAL_5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
59	SUBTOTAL_6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
60	BOM_NO	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
61	ITUSAGEID	☐	UEPVW	UEPVW	CHAR	1	0	ID for higher-level item usage
62	AUTO_GENERATED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
63	QUAN_REQ_ORIG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
64	MATDETERID	☐	PROSA	PROSA	CHAR	1	0	ID for material selection - active
65	SUBSTREASON	☐	SUGRD	SUGRD	CHAR	4	0	Reason for material substitution	*
66	CONSUMPT	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
67	WBS_ELEM	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
68	ITMCAT_ACCPT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
69	SCHEDTYP_ACCPT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
70	.INCLUDE	☐				0	0	SAP Retail Store: Append Structure for WISO_ITEM
71	DUMMY_FIELD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20140121
SAP Release Created in