SAP ABAP Table WSII_ITEM (SAP Retail Store II: Items)

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	WSII_ITEM	Table Relationship Diagram
Short Description	SAP Retail Store II: Items

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	INV_DOC_ITEM	☐	RBLGP	NUMC6	NUMC	6	0	Document Item in Invoice Document
2	IS_VALID	☐	XFELD	XFELD	CHAR	1	0	Checkbox
3	IS_VALID_ORIG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
4	MAT_KEY	☐	WSRS_MAT_KEY	WSRS_MAT_KEY	CHAR	40	0	Long material number for SAP Retail Store
5	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
6	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
7	SHORT_TEXT	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
8	QUANTITY_ORIG	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
9	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
10	QUANTITY_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
11	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
12	PO_UNIT_C	☐	WSRS_UNIT_CHAR		CHAR	3	0	SAP Retail Store: Output Display of Unit of Measure
13	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
14	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
15	REF_DOC	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
16	REF_FISC_YEAR	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
17	REF_DOC_IT	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
18	RET_ITEM	☐	RETPO	XFELD	CHAR	1	0	Returns Item
19	FACTOR	☐	INT4	INT4	INT4	10	0	Natural number
20	ITEM_AMOUNT_ORIG	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
21	ITEM_AMOUNT	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
22	ITEM_AMOUNT_C	☐	WSRS_QTY_CHAR		CHAR	17	0	SAP Retail Store: Quantity Field CHAR 17
23	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	DB_CR_IND	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
25	DB_CR_IND_D	☐	WSRS_DESCR_40	WSRS_DESCR_40	CHAR	40	0	SAP Retail Store: Text Field for Description (40 Characters)
26	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
27	TAX_CODE_D	☐	TEXT1_007S	TEXT50	CHAR	50	0	Name for value-added tax
28	TAX_CODE_ORIG	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
29	PO_PR_UOM	☐	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
30	CONV_NUM1	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
31	CONV_DEN1	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
32	TOL_BLOCK_QTY	☐	SPGRM	XFELD	CHAR	1	0	Blocking Reason: Quantity
33	TOL_BLOCK_AMOUNT	☐	SPGRP	XFELD	CHAR	1	0	Blocking Reason: Price
34	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
35	COND_TYPE	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
36	.INCLUDE	☐				0	0	SAP Retail Store II: Customer Enhancement Item
37	DUMMY_FIELD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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