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

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in