SAP ABAP Table WSTI_POS_EVENT_EX (WSTI_POS_EVENT and ISEG)

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	WSTI_POS_EVENT_EX	Table Relationship Diagram
Short Description	WSTI_POS_EVENT and ISEG

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	ISEG	☐	ISEG		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
4	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	ZEILI	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
7	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
8	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
10	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator
11	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory
12	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number
13	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
14	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
15	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number
16	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer
17	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
18	USNAM	☐	USNAA	USNAM	CHAR	12	0	Changed by
19	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
20	USNAZ	☐	USNAZ	USNAM	CHAR	12	0	Counted By
21	ZLDAT	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
22	USNAD	☐	USNAD	USNAM	CHAR	12	0	Adjustment posting made by
23	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
24	XBLNI	☐	XBLNI1	XBLNR1	CHAR	16	0	Reference Number for Physical Inventory
25	XZAEL	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
26	XDIFF	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
27	XNZAE	☐	XNZAE	XFELD	CHAR	1	0	Item will be recounted
28	XLOEK	☐	I_XLOEK	XFELD	CHAR	1	0	Item is Deleted (Physical Inventory)
29	XAMEI	☐	XAMEI	XFELD	CHAR	1	0	Handling in Alternative Unit of Measure
30	BUCHM	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
31	XNULL	☐	XNULL	XFELD	CHAR	1	0	Zero count
32	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
33	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
34	ERFMG	☐	I_ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry (physical inventory)
35	ERFME	☐	I_ERFME	MEINS	UNIT	3	0	Unit of entry (physical inventory)
36	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
37	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
38	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
39	NBLNR	☐	NBLNR	BELNR	CHAR	10	0	Number of recount document
40	DMBTR	☐	DIFWR	WERT7	CURR	13	2	Difference amount in local currency
41	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
42	ABCIN	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting
43	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
44	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
45	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
46	BUCHW	☐	BUCHW	WERT13N	CURR	13	2	Book value based on sales prices (SP) at time of count
47	KWART	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried
48	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
49	VKMZL	☐	VKMZL	WERT7	CURR	13	2	Sales Value of Inv. Differences (with VAT) on Count Entry
50	VKNZL	☐	VKNZL	WERT7	CURR	13	2	Sales Value of Inventory Difference (w/o VAT) on Count Entry
51	WRTZL	☐	WRTZL	WERT7	CURR	13	2	Value of physical inventory count
52	WRTBM	☐	WRTBM	WERT7	CURR	13	2	Value of book quantity
53	DIWZL	☐	DIWZL	WERT7	CURR	13	2	Inventory difference value upon count entry
54	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
55	GRUND	☐	GRDIF	MB_GRBEW	NUMC	4	0	Reason for inventory diff.
56	SAMAT	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material
57	XDISPATCH	☐	XDISPATCH	XFELD	CHAR	1	0	Distribution of Physical Inventory Differences
58	.INCLU--AP	☐				0	0	Retail Append for Physical Inventory Document Item
59	WSTI_COUNTDATE	☐	WSTI_COUNTDATE	WSTI_COUNTDATE	DATS	8	0	Date of Count During Opening Time
60	WSTI_COUNTTIME	☐	WSTI_COUNTTIME	WSTI_COUNTTIME	TIMS	6	0	Time of Count During Opening Time
61	WSTI_FREEZEDATE	☐	WSTI_FREEZEDATE	WSTI_FREEZEDATE	DATS	8	0	Freeze Date for Inventory Balance
62	WSTI_FREEZETIME	☐	WSTI_FREEZETIME	WSTI_FREEZETIME	TIMS	6	0	Freeze Time for Inventory Balance
63	WSTI_POSM	☐	WSTI_POSM	MENGV13	QUAN	13	3	Quantity to Which Book Quantity was Changed
64	WSTI_POSW	☐	WSTI_POSW	WERT13N	CURR	13	2	Retail Value to Which Retail Book Value was Changed
65	WSTI_XCALC	☐	WSTI_XCALC	XFELD	CHAR	1	0	Book Inventory Calculated at Count Time
66	WSTI_POS_EVENT	☐	WSTI_POS_EVENT		STRU	0	0
67	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
68	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
69	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
70	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
71	VORGDATUM	☐	WSTI_POSDATE	WSTI_POSDATE	DATS	8	0	Transaction Date
72	VORGZEIT	☐	WSTI_POSTIME	WSTI_POSTIME	TIMS	6	0	Transaction Time
73	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
74	CNTNR	☐	WSTI_COUNT		NUMC	4	0	Number Below Material Document Item
75	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
76	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
77	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
78	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
79	STATPI	☐	WSTI_STATUS_PI	WSTI_STATUS_PI	CHAR	1	0	Physical Inventory Status of POS Transaction
80	ORIGIN	☐	WSTI_ORIGIN	WSTI_ORIGIN	CHAR	1	0	Origin of Transaction
81	STORNO	☐	WSTI_STORNO	XFELD	CHAR	1	0	Indicator: Reverse Posting
82	SIGN	☐	WSTI_SIGN	WSTI_SIGN	CHAR	1	0	Plus/Minus Sign of POS Transaction
83	SIGN_CALC	☐	WSTI_SIGN_CALC		CHAR	1	0	Plus/Minus Sign in Book Inventory Calculation
84	ERFMG	☐	MB_ERFMG	MENG13	QUAN	13	3	Quantity in Unit of Entry
85	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry
86	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
87	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
88	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
89	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
90	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory
91	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator
92	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number
93	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
94	WAART	☐	WAART	XFELD	CHAR	1	0	Indicates that material is a value-only material
95	EMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
96	DOCNUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
97	XBUIB_DONE	☐	WSTI_XBUIB_DONE	XFELD	CHAR	1	0	Indicator: Book Inventory Changed Using Standard Function
98	TIME_COMPARE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

History

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