SAP ABAP Table INV_ISEG_DETAILVIEW (Structure for Output of ISEG for Detail View of PI Documents)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	INTTAB	Structure
Structure	INV_ISEG_DETAILVIEW	Table Relationship Diagram
Short Description	Structure for Output of ISEG for Detail View of PI Documents

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	STEXT	☐	TXINV	TEXT20	CHAR	20	0	Physical inventory status
2	INVNU	☐	INVNU	XBLNR	CHAR	16	0	Physical inventory number
3	.INCLUDE	☐				0	0	Physical Inventory Document Items
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
6	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	ZEILI	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	MARD
11	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
12	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
13	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory	T064B
14	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
15	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
16	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
17	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
18	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
19	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
20	USNAM	☐	USNAA	USNAM	CHAR	12	0	Changed by
21	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
22	USNAZ	☐	USNAZ	USNAM	CHAR	12	0	Counted By
23	ZLDAT	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
24	USNAD	☐	USNAD	USNAM	CHAR	12	0	Adjustment posting made by
25	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
26	XBLNI	☐	XBLNI1	XBLNR1	CHAR	16	0	Reference Number for Physical Inventory
27	XZAEL	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
28	XDIFF	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
29	XNZAE	☐	XNZAE	XFELD	CHAR	1	0	Item will be recounted
30	XLOEK	☐	I_XLOEK	XFELD	CHAR	1	0	Item is Deleted (Physical Inventory)
31	XAMEI	☐	XAMEI	XFELD	CHAR	1	0	Handling in Alternative Unit of Measure
32	BUCHM	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
33	XNULL	☐	XNULL	XFELD	CHAR	1	0	Zero count
34	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
35	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
36	ERFMG	☐	I_ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry (physical inventory)
37	ERFME	☐	I_ERFME	MEINS	UNIT	3	0	Unit of entry (physical inventory)	T006
38	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
39	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
40	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
41	NBLNR	☐	NBLNR	BELNR	CHAR	10	0	Number of recount document
42	DMBTR	☐	DIFWR	WERT7	CURR	13	2	Difference amount in local currency
43	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
44	ABCIN	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	T159C
45	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
46	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
47	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
48	BUCHW	☐	BUCHW	WERT13N	CURR	13	2	Book value based on sales prices (SP) at time of count
49	KWART	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried
50	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
51	VKMZL	☐	VKMZL	WERT7	CURR	13	2	Sales Value of Inv. Differences (with VAT) on Count Entry
52	VKNZL	☐	VKNZL	WERT7	CURR	13	2	Sales Value of Inventory Difference (w/o VAT) on Count Entry
53	WRTZL	☐	WRTZL	WERT7	CURR	13	2	Value of physical inventory count
54	WRTBM	☐	WRTBM	WERT7	CURR	13	2	Value of book quantity
55	DIWZL	☐	DIWZL	WERT7	CURR	13	2	Inventory difference value upon count entry
56	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
57	GRUND	☐	GRDIF	MB_GRBEW	NUMC	4	0	Reason for inventory diff.	T157D
58	SAMAT	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
59	XDISPATCH	☐	XDISPATCH	XFELD	CHAR	1	0	Distribution of Physical Inventory Differences
60	.INCLU--AP	☐				0	0	Retail Append for Physical Inventory Document Item
61	WSTI_COUNTDATE	☐	WSTI_COUNTDATE	WSTI_COUNTDATE	DATS	8	0	Date of Count During Opening Time
62	WSTI_COUNTTIME	☐	WSTI_COUNTTIME	WSTI_COUNTTIME	TIMS	6	0	Time of Count During Opening Time
63	WSTI_FREEZEDATE	☐	WSTI_FREEZEDATE	WSTI_FREEZEDATE	DATS	8	0	Freeze Date for Inventory Balance
64	WSTI_FREEZETIME	☐	WSTI_FREEZETIME	WSTI_FREEZETIME	TIMS	6	0	Freeze Time for Inventory Balance
65	WSTI_POSM	☐	WSTI_POSM	MENGV13	QUAN	13	3	Quantity to Which Book Quantity was Changed
66	WSTI_POSW	☐	WSTI_POSW	WERT13N	CURR	13	2	Retail Value to Which Retail Book Value was Changed
67	WSTI_XCALC	☐	WSTI_XCALC	XFELD	CHAR	1	0	Book Inventory Calculated at Count Time
68	BUPER	☐	BUPER	BUPER	ACCP	6	0	Posting period in the form YYYYMM
69	BTEXT	☐	BTEXT	BTEXT	CHAR	20	0	Text for stock type

Foreign Keys

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

History

Last changed by/on	SAP	20100310
SAP Release Created in	605