SAP ABAP Table WSAO_ALST_POSITION (Item structure for assortment list business object)

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_ALST_POSITION	Table Relationship Diagram
Short Description	Item structure for assortment list business object

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_NO	☐	BBGNO	AL_GROUP_NO	NUMC	10	0	Assortment list group no.	WBBL
2	POSITION_NO	☐	BBRNO	BBRNO	INT4	10	0	Sequence number of item in assortment list	WBBP
3	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
5	VEND_MAT	☐	BB_LIFARTN	CHAR22	CHAR	22	0	Material no. of vendor
6	TEXT_20	☐	BB_ARTTXT	TEXT20	CHAR	20	0	Material text (abbrev. for the assortment list output)
7	TEXT_30	☐	BB_TXT30	TEXT30	CHAR	30	0	Material text, length 30 (reduced for AL output)
8	TEXT_40_UOM	☐	BB_MAKTM	TEXT40	CHAR	40	0	Material description, unit of measure
9	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
10	PO_UNIT_ISO	☐	ISOCD_BSTME	ISOCD_UNIT	CHAR	3	0	ISO code for order unit	T006I
11	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
12	SALES_UNIT_ISO	☐	ISOCD_VRKME	ISOCD_UNIT	CHAR	3	0	ISO code for sales unit	T006I
13	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
14	BASE_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
15	FACTOR_UNIT_CON	☐	BB_FACTR	CHAR6	CHAR	6	0	Conversion factor for order Un to sales Un for astmt. list
16	SALES_PRICE_10	☐	BB_PRICE	CHAR10	CHAR	10	0	Sales price for assortment list output (10 characters)
17	SALES_PRICE	☐	BB_VKP	BAPICURR	DEC	23	4	Sales price for assortment list output via BAPI
18	PURCHASE_PRICE_10	☐	SL_EKPNN10	CHAR10	CHAR	10	0	Purchase Price for Assortment List Output (10 Characters)
19	PURCHASE_PRICE	☐	BB_EKP	BAPICURR	DEC	23	4	Purchase price for assortment list output via BAPI
20	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
22	MATERIAL_COMMENT	☐	COMMNT	TEXT10	CHAR	10	0	Comments on a material in the assortment list
23	CONF_MATL	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
24	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
25	MRP_TYPE	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
26	ORDER_FLAG	☐	KNZBB	XFELD	CHAR	1	0	ID: replenishable
27	SAFETY_STK	☐	EISBE	MENG13	QUAN	13	3	Safety stock
28	REORDER_PT	☐	MINBE	MENG13	QUAN	13	3	Reorder point
29	MAX_STOCK	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
30	FOLLOW_UP	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	MARA
31	EFF_O_DAY	☐	BB_ERSAB	DATUM	DATS	8	0	Expir. date
32	MIN_PO_QTY	☐	MINBM	MENG13	QUAN	13	3	Minimum Purchase Order Quantity
33	PLND_DELRY	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
34	SUPPL_FROM	☐	BB_LIFAB	DATUM	DATS	8	0	Available for delivery from
35	SUPPL_TO	☐	BB_LIFBI	DATUM	DATS	8	0	Available for delivery until
36	PROMOTION_DIST	☐	BB_AKTION	XFELD	CHAR	1	0	Promotion indicator Y/N
37	PROMOTION_NO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
38	PROMOTION_FROM	☐	BB_AKTAB	DATUM	DATS	8	0	On sale, promotion from
39	PROMOTION_TO	☐	BB_AKTBIS	DATUM	DATS	8	0	On sale, promotion to
40	EARLIEST_RP_DATE	☐	BB_FBDAT	DATUM	DATS	8	0	Earliest order date with vendor
41	LATEST_RP_DATE	☐	BB_A_SBDAT	DATUM	DATS	8	0	Latest order date with vendor
42	VALID_FROM	☐	BB_GUELTAB	DATUM	DATS	8	0	Change valid from
43	CONF_MATL_EXTERNAL	☐	MGV_CONF_MATL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for CONF_MATL field
44	CONF_MATL_GUID	☐	MGV_CONF_MATL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for CONF_MATL Field
45	CONF_MATL_VERSION	☐	MGV_CONF_MATL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for Field CONF_MATL
46	FOLLOW_UP_EXTERNAL	☐	MGV_FOLLOW_UP_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for field FOLLOW_UP
47	FOLLOW_UP_GUID	☐	MGV_FOLLOW_UP_GUID	MATNR_EGUID	CHAR	32	0	External GUID for FOLLOW_UP Field
48	FOLLOW_UP_VERSION	☐	MGV_FOLLOW_UP_VERSION	MATNR_VERS	CHAR	10	0	Version Number for FOLLOW_UP Field
49	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
50	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
51	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field

Foreign Keys

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

History

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