SAP ABAP Table WSAO_DISP_ITEM_RAW (Item in Planning List Store Order)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-SRS (Application Component) SAP Retail Store
     ⤷ WOST (Package) SAP Retail Store: Internet Application Components

Basic Data

Table Category	INTTAB	Structure
Structure	WSAO_DISP_ITEM_RAW	Table Relationship Diagram
Short Description	Item in Planning List Store Order

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	GROUP_HEADER	☐	WSAO_DISP_GROUP_NAME		CHAR	40	0	Name (Heading) for Customer-Specific Material Group
2	DISPO_KEY	☐	WSAO_DISP_DISPO_KEY	WSAO_DISP_DISPO_KEY	CHAR	1	0	Planning Key (SAP Retail Store Store Order)
3	SORTING_METHOD	☐	BSORT	BSORT	CHAR	1	0	Sorting Procedure in Assortment List
4	ASSORTLIST_TYPE	☐	BBTYP	BBTYP	CHAR	1	0	Assortment List Type	*
5	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
6	LAYOUT_MOD	☐	LAYGR	LAYGR	CHAR	10	0	Layout Module	*
7	DEPARTMENT_NO	☐	ABTNR	ABTNR	CHAR	4	0	Department number	*
8	VEND_PART	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	*
9	TEMPLATE	☐	WSAO_DYNP_RAW_ITEM		STRU	0	0
10	QUANTITY	☐	AVWCTXCONT	CHAR1024	CHAR	1024	0	ALE/Web (ITS) context - field contents
11	QUANTITY_TAB	☐	WSAO_DYNP_QTY_TAB		TTYP	0	0
12	QUANTITY	☐	BESTMG	MENG13	QUAN	13	3	Purchase order quantity
13	QUANTITY_TAB	☐	WSAO_ORDR_QTY_TAB		TTYP	0	0
14	PROPOSAL	☐	BESTMG	MENG13	QUAN	13	3	Purchase order quantity
15	STOCK	☐	WRSTOCK	MENG13V	QUAN	13	3	Stock level of recipient
16	RECEIPTS	☐	MNG04	MENGV13	QUAN	13	3	ATP quantity
17	RECEIPTS_TAB	☐	WSAO_DISP_ATP_TAB		TTYP	0	0
18	CUSTOMER_FIELDS	☐	WSAO_DISP_EX_CONTENT_TAB		TTYP	0	0
19	STATUS	☐	WSAO_ORDR_ITEM_STATUS	WSAO_ORDR_ITEM_STATUS	CHAR	1	0	Status of an item in the order list (SAP Retail Store)
20	MSGTX	☐	MSGTX	TEXT100	CHAR	100	0	Message text
21	DELETED	☐	WSAO_DISP_DELETED_FLAG	FLAG	CHAR	1	0	Indicates Whether an Item was Deleted
22	OBJTYP	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
23	BELNR	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
24	POSNR	☐	WVFB_BELP	POSNR	NUMC	6	0	Document Item in Follow-On Document for Store Order	*
25	QTY_ROUNDED	☐	WSAO_FLAG	WSAO_FLAG	CHAR	1	0	Indicator: SAP Retail Store Store Order
26	EAN_UPC_TAB	☐	WSAO_EAN_UPC_TAB		TTYP	0	0
27	.INCLUDE	☐				0	0	Item structure for assortment list business object
28	GROUP_NO	☐	BBGNO	AL_GROUP_NO	NUMC	10	0	Assortment list group no.	WBBL
29	POSITION_NO	☐	BBRNO	BBRNO	INT4	10	0	Sequence number of item in assortment list	WBBP
30	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
31	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
32	VEND_MAT	☐	BB_LIFARTN	CHAR22	CHAR	22	0	Material no. of vendor
33	TEXT_20	☐	BB_ARTTXT	TEXT20	CHAR	20	0	Material text (abbrev. for the assortment list output)
34	TEXT_30	☐	BB_TXT30	TEXT30	CHAR	30	0	Material text, length 30 (reduced for AL output)
35	TEXT_40_UOM	☐	BB_MAKTM	TEXT40	CHAR	40	0	Material description, unit of measure
36	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
37	ISOCODE_PO_UNIT	☐	ISOCD_BSTME	ISOCD_UNIT	CHAR	3	0	ISO code for order unit	T006I
38	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
39	ISOCODE_SALES_UNIT	☐	ISOCD_VRKME	ISOCD_UNIT	CHAR	3	0	ISO code for sales unit	T006I
40	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
41	ISOCODE_UNIT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
42	FACTOR_UNIT_CON	☐	BB_FACTR	CHAR6	CHAR	6	0	Conversion factor for order Un to sales Un for astmt. list
43	SALES_PRICE_10	☐	BB_PRICE	CHAR10	CHAR	10	0	Sales price for assortment list output (10 characters)
44	SALES_PRICE	☐	BB_VKP	BAPICURR	DEC	23	4	Sales price for assortment list output via BAPI
45	PURCHASE_PRICE_10	☐	SL_EKPNN10	CHAR10	CHAR	10	0	Purchase Price for Assortment List Output (10 Characters)
46	PURCHASE_PRICE	☐	BB_EKP	BAPICURR	DEC	23	4	Purchase price for assortment list output via BAPI
47	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	ISOCODE_CURRENCY	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
49	MATERIAL_COMMENT	☐	COMMNT	TEXT10	CHAR	10	0	Comments on a material in the assortment list
50	CONF_MATL	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
51	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
52	MRP_TYPE	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
53	ORDER_FLAG	☐	KNZBB	XFELD	CHAR	1	0	ID: replenishable
54	SAFETY_STK	☐	EISBE	MENG13	QUAN	13	3	Safety stock
55	REORDER_PT	☐	MINBE	MENG13	QUAN	13	3	Reorder point
56	MAX_STOCK	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
57	FOLLOW_UP	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	MARA
58	EFF_O_DAY	☐	BB_ERSAB	DATUM	DATS	8	0	Expir. date
59	MIN_PO_QTY	☐	MINBM	MENG13	QUAN	13	3	Minimum Purchase Order Quantity
60	PLND_DELRY	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
61	SUPPL_FROM	☐	BB_LIFAB	DATUM	DATS	8	0	Available for delivery from
62	SUPPL_TO	☐	BB_LIFBI	DATUM	DATS	8	0	Available for delivery until
63	PROMOTION_DIST	☐	BB_AKTION	XFELD	CHAR	1	0	Promotion indicator Y/N
64	PROMOTION_NO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
65	PROMOTION_FROM	☐	BB_AKTAB	DATUM	DATS	8	0	On sale, promotion from
66	PROMOTION_TO	☐	BB_AKTBIS	DATUM	DATS	8	0	On sale, promotion to
67	EARLIEST_RP_DATE	☐	BB_FBDAT	DATUM	DATS	8	0	Earliest order date with vendor
68	LATEST_RP_DATE	☐	BB_A_SBDAT	DATUM	DATS	8	0	Latest order date with vendor
69	VALID_FROM	☐	BB_GUELTAB	DATUM	DATS	8	0	Change valid from
70	CONF_MATL_EXTERNAL	☐	MGV_CONF_MATL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for CONF_MATL field
71	CONF_MATL_GUID	☐	MGV_CONF_MATL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for CONF_MATL Field
72	CONF_MATL_VERSION	☐	MGV_CONF_MATL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for Field CONF_MATL
73	FOLLOW_UP_EXTERNAL	☐	MGV_FOLLOW_UP_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for field FOLLOW_UP
74	FOLLOW_UP_GUID	☐	MGV_FOLLOW_UP_GUID	MATNR_EGUID	CHAR	32	0	External GUID for FOLLOW_UP Field
75	FOLLOW_UP_VERSION	☐	MGV_FOLLOW_UP_VERSION	MATNR_VERS	CHAR	10	0	Version Number for FOLLOW_UP Field
76	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
77	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
78	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
79	EMPTIESBOM	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
80	GROUP1	☐	GROUP1	DOM_GROUP1	CHAR	10	0	Assortment List: Grouping Field 1
81	GROUP2	☐	GROUP2	DOM_GROUP2	CHAR	10	0	Assortment List: Grouping Field 2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WSAO_DISP_ITEM_RAW	BASE_UOM	T006	MSEHI	KEY	1	CN
2	WSAO_DISP_ITEM_RAW	CONF_MATL	MARA	MATNR	KEY	1	CN
3	WSAO_DISP_ITEM_RAW	CURRENCY	TCURC	WAERS	KEY	1	CN
4	WSAO_DISP_ITEM_RAW	FOLLOW_UP	MARA	MATNR	KEY	1	CN
5	WSAO_DISP_ITEM_RAW	GROUP_NO	WBBL	BBGNO	KEY	1	CN
6	WSAO_DISP_ITEM_RAW	ISOCODE_PO_UNIT	T006I	ISOCODE	KEY	1	CN
7	WSAO_DISP_ITEM_RAW	ISOCODE_SALES_UNIT	T006I	ISOCODE	KEY	1	CN
8	WSAO_DISP_ITEM_RAW	ISOCODE_UNIT	T006I	ISOCODE	KEY	1	CN
9	WSAO_DISP_ITEM_RAW	MATERIAL	MARA	MATNR	KEY	1	CN
10	WSAO_DISP_ITEM_RAW	MRP_TYPE	T438A	DISMM	KEY	1	CN
11	WSAO_DISP_ITEM_RAW	POSITION_NO	WBBP	BBRNO	KEY	1	CN
12	WSAO_DISP_ITEM_RAW	PO_UNIT	T006	MSEHI	KEY	1	CN
13	WSAO_DISP_ITEM_RAW	PROMOTION_NO	WAKH	AKTNR	KEY	1	CN
14	WSAO_DISP_ITEM_RAW	SALES_UNIT	T006	MSEHI	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110