SAP ABAP Table WSPO_ITEM (SAP Retail Store PO: Item Data)

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	WSPO_ITEM	Table Relationship Diagram
Short Description	SAP Retail Store PO: Item Data

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	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
2	HL_ITEM	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	*
3	DELETE_IND	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
4	EXISTS_IN_DB	☐	XFELD	XFELD	CHAR	1	0	Checkbox
5	ITEM_CAT	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
6	ITEM_CAT_DESCR	☐	PTEXT_D	TEXT20	CHAR	20	0	Text for Item Category
7	SI_CAT	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	*
8	RET_ITEM	☐	RETPO	XFELD	CHAR	1	0	Returns Item
9	NO_MORE_GR	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
10	MAT_KEY	☐	WSRS_MAT_KEY	WSRS_MAT_KEY	CHAR	40	0	Long material number for SAP Retail Store
11	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
12	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
13	EAN_UPC_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
14	VEND_MAT	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
15	MAT_KEY_TYPED_IN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
16	MAT_KEY_MISSING	☐	XFELD	XFELD	CHAR	1	0	Checkbox
17	SHORT_TEXT	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
18	PLANT	☐	EWERK	WERKS	CHAR	4	0	Plant	*
19	PLANT_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
20	PLANT_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	QUANTITY	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
22	QUANTITY_CHAR	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
23	QUANTITY_ORIG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
24	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
25	PO_UNIT_CHAR	☐	WSRS_UNIT_CHAR		CHAR	3	0	SAP Retail Store: Output Display of Unit of Measure
26	PO_UNIT_ORIG	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
27	QTY_GM_HIST	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
28	QTY_GM	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
29	QTY_GM_CHAR	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
30	OVER_DLV_TOL	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
31	UNLIMITED_DLV	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
32	UNDER_DLV_TOL	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
33	DELIV_DATE	☐	EINDT	DATUM	DATS	8	0	Item delivery date
34	DELIV_DATE_CHAR	☐	WSRS_DATE_CHAR		CHAR	10	0	SAP Retail Store: Output Format of a Date
35	DELIV_DATE_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
36	NET_VALUE	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
37	GROSS_VALUE	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
38	VALUE	☐	WSPO_ITEM_VALUE	WERT7	CURR	13	2	SAP Retail Store: Value of Purchase Order Item
39	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	ORDER_REASON	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
41	ORDREA_DESCR	☐	WSRS_DESCR_40	WSRS_DESCR_40	CHAR	40	0	SAP Retail Store: Text Field for Description (40 Characters)
42	ORDREA_MANUAL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
43	NUMB_SCHED_LINES	☐	INT4	INT4	INT4	10	0	Natural number
44	DOC_NUMBER_SD	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
45	ITM_NUMBER_SD	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
46	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
47	STATISTIC	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
48	SI_EXIST	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
49	GR_IND	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
50	IR_IND	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
51	FINAL_INV	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
52	NO_ROUNDING	☐	NO_ROUNDING	XFELD	CHAR	1	0	Indicator: Suppress Rounding in Purchase Order Item
53	MULTI_SCHED_OK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
54	.INCLUDE	☐				0	0	SAP Retail Store PO: Append Loop Item Data
55	DUMMY_FIELD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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