SAP ABAP Table WSAO_ORDR_ITEM (SAP Retail Store: Store Order Item)

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_ORDR_ITEM	Table Relationship Diagram
Short Description	SAP Retail Store: Store Order Item

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

History

Last changed by/on	SAP	20130529
SAP Release Created in