SAP ABAP Table WOSI_ISEG (Physical Inventory Document Items)

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	WOSI_ISEG	Table Relationship Diagram
Short Description	Physical Inventory Document 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	.INCLUDE	☐				0	0	Physical Inventory Document Items
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
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	MARA
7	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
8	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	MARD
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
10	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
11	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory	T064B
12	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
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	LFA1
16	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
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	T006
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)	T006
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	TCURC
42	ABCIN	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	T159C
43	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
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.	T157D
56	SAMAT	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
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	ERFMG_CHAR	☐	ERFMG_C	CHAR17	CHAR	17	0	Quantity in unit of entry (character)
67	EXVKW_CHAR	☐	EXVKW_C	CHAR30	CHAR	30	0	Externally entered sales value in local currency (character)
68	DIFMG	☐	DIFMG	MENGV13	QUAN	13	3	Difference quantity from inventory count
69	DIFWT_POSWS	☐	DIFVW	WERTV7	CURR	13	2	Difference sales value from physical inventory count
70	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
71	MESSAGE	☐	BAPI_MSG	TEXT220	CHAR	220	0	Message Text
72	IAC_STAT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
73	ITEM_ACTIV	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
74	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	*
75	QM_ACTIV	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
76	PRUEFLOS_CHAR	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
77	GRUND_CHAR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
78	POSWS	☐	POSWS	WAERS	CUKY	5	0	Currency of POS systems	*
79	EXVKW_POSWS	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
80	DIFMG_ERFME	☐	DIFMG	MENGV13	QUAN	13	3	Difference quantity from inventory count
81	BUCHM_ERFME	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
82	BUCHW_POSWS	☐	BUCHW	WERT13N	CURR	13	2	Book value based on sales prices (SP) at time of count
83	DMBTR_POSWS	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
84	STEXT	☐	TXINV	TEXT20	CHAR	20	0	Physical inventory status
85	.INCLU--AP	☐				0	0	Enhancement Add-On
86	COUNT_TIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
87	COUNT_TIME_CHAR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WOSI_ISEG	ABCIN	T159C	ABCIN	KEY	1	CN
2	WOSI_ISEG	BSTAR	T064B	BSTAR	REF	C	CN
3	WOSI_ISEG	CHARG	MCHA	CHARG	REF	C	CN
4	WOSI_ISEG	ERFME	T006	MSEHI	REF	1	N
5	WOSI_ISEG	GRUND	T157D	GRUND	REF	C	CN
6	WOSI_ISEG	KDAUF	VBUK	VBELN	REF	C	CN
7	WOSI_ISEG	KUNNR	KNA1	KUNNR	REF	C	CN
8	WOSI_ISEG	LGORT	MARD	LGORT	REF	C	CN
9	WOSI_ISEG	LIFNR	LFA1	LIFNR	REF	C	CN
10	WOSI_ISEG	MANDT	T000	MANDT	KEY	1	CN
11	WOSI_ISEG	MATNR	MARA	MATNR	REF	C	CN
12	WOSI_ISEG	MEINS	T006	MSEHI	REF	1	N
13	WOSI_ISEG	PS_PSP_PNR	PRPS	PSPNR	REF	1	CN
14	WOSI_ISEG	SAMAT	MARA	MATNR
15	WOSI_ISEG	SOBKZ	T148	SOBKZ	REF	C	CN
16	WOSI_ISEG	WAERS	TCURC	WAERS	REF	1	CN
17	WOSI_ISEG	WERKS	MARC	WERKS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in