SAP ABAP Table MCISEG (CS: Physical Inventory Document - Item Segment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	MCISEG	Table Relationship Diagram
Short Description	CS: Physical Inventory Document - Item Segment

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	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
2	.INCLUDE	☐				0	0	Physical Inventory Document Items
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	IBLNR	☐	IBLNR	BELNR	CHAR	10	0	Physical inventory document
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	ZEILI	☐	DZEILE	ZEILE	NUMC	3	0	Line Number
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
9	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	MARD
10	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
11	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
12	BSTAR	☐	I_BSTAR	BSTAR	CHAR	1	0	Stock Type (Physical Inventory	T064B
13	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
14	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
15	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
16	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
17	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
18	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
19	USNAM	☐	USNAA	USNAM	CHAR	12	0	Changed by
20	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
21	USNAZ	☐	USNAZ	USNAM	CHAR	12	0	Counted By
22	ZLDAT	☐	DZLDAT	DATUM	DATS	8	0	Date of last count
23	USNAD	☐	USNAD	USNAM	CHAR	12	0	Adjustment posting made by
24	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
25	XBLNI	☐	XBLNI1	XBLNR1	CHAR	16	0	Reference Number for Physical Inventory
26	XZAEL	☐	XZAEL	XFELD	CHAR	1	0	Item has been counted
27	XDIFF	☐	XDIFF	XFELD	CHAR	1	0	Difference posted
28	XNZAE	☐	XNZAE	XFELD	CHAR	1	0	Item will be recounted
29	XLOEK	☐	I_XLOEK	XFELD	CHAR	1	0	Item is Deleted (Physical Inventory)
30	XAMEI	☐	XAMEI	XFELD	CHAR	1	0	Handling in Alternative Unit of Measure
31	BUCHM	☐	BUCHM	MENGV13	QUAN	13	3	Book quantity immediately prior to count
32	XNULL	☐	XNULL	XFELD	CHAR	1	0	Zero count
33	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
34	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
35	ERFMG	☐	I_ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry (physical inventory)
36	ERFME	☐	I_ERFME	MEINS	UNIT	3	0	Unit of entry (physical inventory)	T006
37	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
38	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
39	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
40	NBLNR	☐	NBLNR	BELNR	CHAR	10	0	Number of recount document
41	DMBTR	☐	DIFWR	WERT7	CURR	13	2	Difference amount in local currency
42	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
43	ABCIN	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	T159C
44	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
45	VKWRT	☐	VKWRT	WERT7	CURR	13	2	Value at sales prices including value-added tax
46	EXVKW	☐	EXVKW	WERT7	CURR	13	2	Externally Entered Sales Value in Local Currency
47	BUCHW	☐	BUCHW	WERT13N	CURR	13	2	Book value based on sales prices (SP) at time of count
48	KWART	☐	XWART	XFELD	CHAR	1	0	Indicates that the value-only material is to be inventoried
49	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
50	VKMZL	☐	VKMZL	WERT7	CURR	13	2	Sales Value of Inv. Differences (with VAT) on Count Entry
51	VKNZL	☐	VKNZL	WERT7	CURR	13	2	Sales Value of Inventory Difference (w/o VAT) on Count Entry
52	WRTZL	☐	WRTZL	WERT7	CURR	13	2	Value of physical inventory count
53	WRTBM	☐	WRTBM	WERT7	CURR	13	2	Value of book quantity
54	DIWZL	☐	DIWZL	WERT7	CURR	13	2	Inventory difference value upon count entry
55	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
56	GRUND	☐	GRDIF	MB_GRBEW	NUMC	4	0	Reason for inventory diff.	T157D
57	SAMAT	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
58	XDISPATCH	☐	XDISPATCH	XFELD	CHAR	1	0	Distribution of Physical Inventory Differences
59	.INCLU--AP	☐				0	0	Retail Append for Physical Inventory Document Item
60	WSTI_COUNTDATE	☐	WSTI_COUNTDATE	WSTI_COUNTDATE	DATS	8	0	Date of Count During Opening Time
61	WSTI_COUNTTIME	☐	WSTI_COUNTTIME	WSTI_COUNTTIME	TIMS	6	0	Time of Count During Opening Time
62	WSTI_FREEZEDATE	☐	WSTI_FREEZEDATE	WSTI_FREEZEDATE	DATS	8	0	Freeze Date for Inventory Balance
63	WSTI_FREEZETIME	☐	WSTI_FREEZETIME	WSTI_FREEZETIME	TIMS	6	0	Freeze Time for Inventory Balance
64	WSTI_POSM	☐	WSTI_POSM	MENGV13	QUAN	13	3	Quantity to Which Book Quantity was Changed
65	WSTI_POSW	☐	WSTI_POSW	WERT13N	CURR	13	2	Retail Value to Which Retail Book Value was Changed
66	WSTI_XCALC	☐	WSTI_XCALC	XFELD	CHAR	1	0	Book Inventory Calculated at Count Time
67	WAERI	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
68	.INCLUDE	☐				0	0	IS-R Enhancements to MCISEG
69	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
70	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
71	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
72	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
73	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
74	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
75	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
76	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
77	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
78	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
79	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
80	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
81	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
82	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
83	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
84	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
85	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
86	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
87	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
88	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
89	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
90	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
91	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
92	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
93	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	T6WP2
94	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
95	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
96	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
97	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
98	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
99	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
100	LANDLF	☐	MCW_LANDLF	LAND1	CHAR	3	0	Country of vendor	T005
101	RLIFN	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
102	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
103	RLTSNR	☐	MCW_LTSNR	LTSNR	CHAR	6	0	Vendor sub-range at regular vendor	*
104	RIDNLF	☐	MCW_IDNLF	IDNEX	CHAR	35	0	Material number at regular vendor
105	RKOLIF	☐	MCW_KOLIF	LIFNR	CHAR	10	0	Prior vendor of regular vendor	*
106	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
107	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
108	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
109	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
110	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
111	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
112	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
113	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
114	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
115	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
116	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
117	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
118	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
119	IBUMNG	☐	MCW_IBUMNG	MENGV15_3	QUAN	15	3	Book inventory balance, quantity in base unit of measure
120	IBUGEO	☐	MCW_IBUGEO	WERTV9	CURR	17	2	Book inventory balance at cost
121	IBUGVO	☐	MCW_IBUGVO	WERTV9	CURR	17	2	Book inventory balance at retail
122	IBUGVP	☐	MCW_IBUGVP	WERTV9	CURR	17	2	Book inventory balance at retail with tax
123	IZLMNG	☐	MCW_IZLMNG	MENGV15_3	QUAN	15	3	Quantity of stock, counted in base unit of measure
124	IZLGEO	☐	MCW_IZLGEO	WERTV9	CURR	17	2	Quantity of stock counted at cost
125	IZLGVO	☐	MCW_IZLGVO	WERTV9	CURR	17	2	Quantity of stock counted at retail
126	IZLGVP	☐	MCW_IZLGVP	WERTV9	CURR	17	2	Quantity of stock counted at retail with tax
127	IDPMNG	☐	MCW_IDPMNG	MENGV15_3	QUAN	15	3	Plus inventory difference quantity in BUn
128	IDPGEO	☐	MCW_IDPGEO	WERTV9	CURR	17	2	Plus inventory difference at cost
129	IDPGVO	☐	MCW_IDPGVO	WERTV9	CURR	17	2	Plus inventory difference at retail
130	IDPGVP	☐	MCW_IDPGVP	WERTV9	CURR	17	2	Plus inventory difference at retail with tax
131	IDMMNG	☐	MCW_IDMMNG	MENGV15_3	QUAN	15	3	Minus inventory difference quantity in BUn
132	IDMGEO	☐	MCW_IDMGEO	WERTV9	CURR	17	2	Minus inventory difference at cost
133	IDMGVO	☐	MCW_IDMGVO	WERTV9	CURR	17	2	Minus inventory difference at retail
134	IDMGVP	☐	MCW_IDMGVP	WERTV9	CURR	17	2	Minus inventory difference at retail
135	IVSTAT	☐	IVSTATUS	IVSTATUS	NUMC	2	0	Statistical status of physical inventory
136	.INCLUDE	☐				0	0	User Strcuture: Physical Inventory Document - Item Segment
137	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCISEG	ABCIN	T159C	ABCIN	KEY	1	CN
2	MCISEG	ABTNR	TSAB	ABTNR
3	MCISEG	AKTHE	TWAT	AKTHE
4	MCISEG	AKTYP	TWTY	AKTYP
5	MCISEG	BSTAR	T064B	BSTAR	REF	C	CN
6	MCISEG	BWSCL	T6WP2	BWSCL
7	MCISEG	BWVOR	T6WP1	BWVOR
8	MCISEG	BZIRK	T171	BZIRK
9	MCISEG	CHARG	MCHA	CHARG	REF	C	CN
10	MCISEG	DISPO	T024D	DISPO
11	MCISEG	EKGRP	T024	EKGRP
12	MCISEG	EKORG	T024E	EKORG
13	MCISEG	EKSGB	T026	EKSGB
14	MCISEG	ERFME	T006	MSEHI	REF	1	N
15	MCISEG	GEWEI	T006	MSEHI
16	MCISEG	GRUND	T157D	GRUND	REF	C	CN
17	MCISEG	KDAUF	VBUK	VBELN	REF	C	CN
18	MCISEG	KOLIF	LFA1	LIFNR
19	MCISEG	KUNNR	KNA1	KUNNR	REF	C	CN
20	MCISEG	LAND1	T005	LAND1
21	MCISEG	LANDLF	T005	LAND1
22	MCISEG	LGORT	MARD	LGORT	REF	C	CN
23	MCISEG	LIFNR	LFA1	LIFNR	REF	C	CN
24	MCISEG	LTSNR	WYT1	LTSNR
25	MCISEG	MANDT	T000	MANDT	KEY	1	CN
26	MCISEG	MATKL	T023	MATKL
27	MCISEG	MATNR	MARA	MATNR	REF	C	CN
28	MCISEG	MEINS	T006	MSEHI	REF	1	N
29	MCISEG	MTART	T134	MTART
30	MCISEG	PLGTP	TWPT	PLGTP
31	MCISEG	PRDHA	T179	PRODH
32	MCISEG	PS_PSP_PNR	PRPS	PSPNR	REF	1	CN
33	MCISEG	RLIFN	LFA1	LIFNR
34	MCISEG	SAISO	T6WSP	SAISO
35	MCISEG	SAMAT	MARA	MATNR
36	MCISEG	SATNR	MARA	MATNR
37	MCISEG	SERVG	TWSG	SERVG
38	MCISEG	SOBKZ	T148	SOBKZ	REF	C	CN
39	MCISEG	STRNR	MARA	MATNR
40	MCISEG	VKORG	TVKO	VKORG
41	MCISEG	VOLEH	T006	MSEHI
42	MCISEG	VTWEG	TVTW	VTWEG
43	MCISEG	WAERS	TCURC	WAERS	REF	1	CN
44	MCISEG	WERKS	MARC	WERKS	REF	C	CN
45	MCISEG	WKUNNR	KNA1	KUNNR
46	MCISEG	WMINR	WWMI	WMINR

History

Last changed by/on	SAP	20110901
SAP Release Created in