SAP ABAP Table MCBEST (Stock Fields and Material Master Information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCB (Package) R/3 application development: Inventory Controlling

Basic Data

Table Category	INTTAB	Structure
Structure	MCBEST	Table Relationship Diagram
Short Description	Stock Fields and Material Master Information

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
5	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
6	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
7	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
8	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
9	PSPNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
10	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
11	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
12	KA_ANONYM	☐	MC_KAANONYM	MENGV15	QUAN	15	3	Sales Order Stock, Valuated Anonymously
13	CKA_ANON	☐	MC_CKAANON	MENGV15	QUAN	15	3	Sales Order Stock (Batch), Valuate Anonymously
14	PR_ANONYM	☐	MC_PRANON	MENGV15	QUAN	15	3	Project Stock, Valuated Anonymously
15	CPR_ANON	☐	MC_CPRANON	MENGV15	QUAN	15	3	Project Stock (Batch), Valuated Anonymously
16	.INCLUDE	☐				0	0	Stock Fields in Inventory Controlling
17	LABST	☐	MC_LABST	MENGV15	QUAN	15	3	Valuated stock with unrestricted use
18	UMLME	☐	MC_UMLMD	MENGV15	QUAN	15	3	Stock in transfer (from one storage location to another)
19	INSME	☐	MC_INSME	MENGV15	QUAN	15	3	Stock in quality inspection
20	KLABS	☐	MC_KLABS	MENGV15	QUAN	15	3	Unrestricted-use consignment stock
21	KINSM	☐	MC_KINSM	MENGV15	QUAN	15	3	Consignment Stock in Quality Inspection
22	UMLMC	☐	MC_UMLME	MENGV15	QUAN	15	3	Stock in transfer (plant to plant)
23	TRAME	☐	MC_TRAME	MENGV15	QUAN	15	3	Stock in transit
24	BWESB	☐	MC_BWESB	MENGV15	QUAN	15	3	Valuated GR Blocked Stock
25	KSPEM	☐	MC_KSPEM	MENGV15	QUAN	15	3	Blocked consignment stock
26	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
27	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
28	SPEME	☐	MC_SPEME	MENGV15	QUAN	15	3	Blocked stock
29	MBWBEST	☐	MBWBEST	MENGV15	QUAN	15	3	Quantity of valuated stock
30	MKOBEST	☐	MKOBEST	MENGV15	QUAN	15	3	Quantity of consignment stock
31	GSBEST	☐	GSBEST	MENGV15	QUAN	15	3	Total stock
32	WBWBEST	☐	WBWBEST	WERT15	CURR	15	2	Value of valuated stock
33	EISBE	☐	MC_EISBE	MENGV15	QUAN	15	3	Safety stock
34	BESZUG	☐	BESZUG	MENGV15	QUAN	15	3	Stock level at goods receipt
35	WBESZUG	☐	WBESZUG	WERT15	CURR	15	2	Value of stock at goods receipt
36	BVBEW	☐	BVBEW	MENGV15	QUAN	15	3	Change in valuated stock level
37	BVKON	☐	BVKON	MENGV15	QUAN	15	3	Change in stock level of consignment stock
38	BWERTV	☐	BWERTV	WERT15	CURR	15	2	Change in value of valuated stock
39	CMBWBEST	☐	CMBWBEST	MENGV15	QUAN	15	3	Quantity of valuated stock per batch
40	CMKOBEST	☐	CMKOBEST	MENGV15	QUAN	15	3	Quantity of vendor consignment stock per batch
41	CWBWBEST	☐	CWBWBEST	WERT15	CURR	15	2	Value of valuated stock per batch
42	CGSBEST	☐	CGSBEST	MENGV15	QUAN	15	3	Quantity of total stock per batch
43	KULAB	☐	MC_MKLKL	MENGV15	QUAN	15	3	Unrestricted-use returnable packaging at the customer's
44	KUINS	☐	MC_MKQKL	MENGV15	QUAN	15	3	Customer inspection stock
45	LBLAB	☐	MC_MSLBO	MENGV15	QUAN	15	3	Unrestricted-use material(s) provided to vendor
46	LBINS	☐	MC_MSQBO	MENGV15	QUAN	15	3	Materials provided to vendor in quality inspection
47	EINME	☐	MC_EINME	MENGV15	QUAN	15	3	Storage Location Inventory of All Restricted-Use Batches
48	LBEIN	☐	MC_LBEIN	MENGV15	QUAN	15	3	Subcontracting Stock of All Restricted-Use Batches
49	KUEIN	☐	MC_KUEIN	MENGV15	QUAN	15	3	Sales Order Stock of All Restricted-Use Batches
50	SEINM	☐	KEINM	MENG13V	QUAN	13	3	Restricted-use consignment stock
51	CEINM	☐	MC_EINME	MENGV15	QUAN	15	3	Storage Location Inventory of All Restricted-Use Batches
52	KEINM	☐	KEINM	MENG13V	QUAN	13	3	Restricted-use consignment stock
53	SLABS	☐	MC_KLABS	MENGV15	QUAN	15	3	Unrestricted-use consignment stock
54	SINSM	☐	MC_KINSM	MENGV15	QUAN	15	3	Consignment Stock in Quality Inspection
55	SSPEM	☐	MC_KSPEM	MENGV15	QUAN	15	3	Blocked consignment stock
56	CLABS	☐	MC_LABST	MENGV15	QUAN	15	3	Valuated stock with unrestricted use
57	CINSM	☐	MC_INSME	MENGV15	QUAN	15	3	Stock in quality inspection
58	CSPEM	☐	MC_SPEME	MENGV15	QUAN	15	3	Blocked stock
59	CUMLM	☐	MC_UMLME	MENGV15	QUAN	15	3	Stock in transfer (plant to plant)
60	GLGMG	☐	MC_GLGMG	MENGV15	QUAN	15	3	Tied empties stock
61	RETME	☐	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
62	CRETM	☐	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
63	PRLAB	☐	MC_PRLAB	MENGV15	QUAN	15	3	Project stock, unrestricted use
64	PRINS	☐	MC_PRINS	MENGV15	QUAN	15	3	Project stock, in quality inspection
65	PRSPE	☐	MC_PRSPE	MENGV15	QUAN	15	3	Project stock, blocked
66	PREIN	☐	MC_PREIN	MENGV15	QUAN	15	3	Project stock, restricted use
67	KALAB	☐	MC_KALAB	MENGV15	QUAN	15	3	Sales order stock, free
68	KAINS	☐	MC_KAINS	MENGV15	QUAN	15	3	Sales order stock, in quality inspection
69	KASPE	☐	MC_KASPE	MENGV15	QUAN	15	3	Sales order stock, blocked
70	KAEIN	☐	MC_KAEIN	MENGV15	QUAN	15	3	Sales order stock, not free
71	MTV_L	☐	MC_MTV_L	MENGV15	QUAN	15	3	Returnable transport packaging, free
72	MTV_I	☐	MC_MTV_I	MENGV15	QUAN	15	3	Returnable transport packaging, in quality inspection
73	MTV_S	☐	MC_MTV_S	MENGV15	QUAN	15	3	Returnable transport packaging, blocked
74	MTV_E	☐	MC_MTV_E	MENGV15	QUAN	15	3	RTP, not free
75	SALK3_E	☐	SALK3_E	WERT13N	CURR	13	2	Total Value of evaluated Sales Order Stock
76	SALK3_Q	☐	SALK3_Q	WERT13N	CURR	13	2	Total Value of Valuated Project Stock
77	LBKUM_E	☐	LBKUM_E	MENG13V	QUAN	13	3	Total valuated sales order stock
78	LBKUM_Q	☐	LBKUM_Q	MENG13V	QUAN	13	3	Total valuated project stock
79	MKABEST	☐	MC_MKABEST	MENGV15	QUAN	15	3	Total sales order stock
80	MPRBEST	☐	MC_MPRBEST	MENGV15	QUAN	15	3	Total project stock
81	WKABEST	☐	MC_WKABEST	WERT15	CURR	15	2	Sales Order Stock Value
82	WPRBEST	☐	MC_WPRBEST	WERT15	CURR	15	2	Project Stock Value
83	BVKA	☐	MC_BVKA	MENGV15	QUAN	15	3	Change in Stock Sales Order Stock
84	BVPR	☐	MC_BVPR	MENGV15	QUAN	15	3	Stock Change Project Stock
85	BWERTVKA	☐	MC_BWERTVKA	WERT15	CURR	15	2	Value Change Sales Order Stock
86	BWERTVPR	☐	MC_BWERTVPR	WERT15	CURR	15	2	Value Change Project Stock
87	BVLABST	☐	MC_BVLABST	MENGV15	QUAN	15	3	Change in Stock: Valuated, Unrestricted-Use Stock
88	BVUMLME	☐	MC_BVUMLME	MENGV15	QUAN	15	3	Change in Stock: Stock in Transfer
89	BVINSME	☐	MC_BVINSME	MENGV15	QUAN	15	3	Change in Stock: Stock in Quality Inspection
90	BVKLABS	☐	MC_BVKLABS	MENGV15	QUAN	15	3	Change in Stock: Unrestricted-Use Consignment Stock
91	BVKINSM	☐	MC_BVKINSM	MENGV15	QUAN	15	3	Change in Stock: Consignment Stock in Quality Inspection
92	BVUMLMC	☐	MC_BVUMLMC	MENGV15	QUAN	15	3	Change in Stock: Stock in Transfer (Plant to Plant)
93	BVTRAME	☐	MC_BVTRAME	MENGV15	QUAN	15	3	Change in Stock: Stock in Transit
94	BVBWESB	☐	MC_BVBWESB	MENGV15	QUAN	15	3	Change in Stock: Valuated GR Blocked Stock
95	BVKSPEM	☐	MC_BVKSPEM	MENGV15	QUAN	15	3	Change in Stock: Blocked Consignment Stock
96	BVSPEME	☐	MC_BVSPEME	MENGV15	QUAN	15	3	Change in Stock: Blocked Stock
97	BVKULAB	☐	MC_BVKULAB	MENGV15	QUAN	15	3	Change in Stock: Unrestricted-Use Stock at Customer
98	BVKUINS	☐	MC_BVKUINS	MENGV15	QUAN	15	3	Change in Stock: Stock in Quality Inspection at Customer
99	BVLBLAB	☐	MC_BVLBLAB	MENGV15	QUAN	15	3	Change in Stock: Provision of Material to Vendor-Unrest.-Use
100	BVLBINS	☐	MC_BVLBINS	MENGV15	QUAN	15	3	Change in Stock: Provision of Matl to Vendor in Qual. Insp.
101	BVEINME	☐	MC_BVEINME	MENGV15	QUAN	15	3	Change in Stock: Storage Locatn Stock All Restrd-Use Batches
102	BVLBEIN	☐	MC_BVLBEIN	MENGV15	QUAN	15	3	Stock Change: Stock Provided to Vendor(Restricted-Use Batch)
103	BVKUEIN	☐	MC_BVKUEIN	MENGV15	QUAN	15	3	Change in Stock: Sales Order Stock, Restricted-Use (Batch)
104	BVSEINM	☐	MC_BVSEINM	MENGV15	QUAN	15	3	Change in Stock: Restricted-Use Consignment Stock (Batch)
105	BVCEINM	☐	MC_BVCEINM	MENGV15	QUAN	15	3	Change in Stock: Storage Locatn Stock All Restrd-Use Batches
106	BVKEINM	☐	MC_BVKEINM	MENGV15	QUAN	15	3	Change in Stock: Restricted-Use Consignment Stock
107	BVSLABS	☐	MC_BVSLABS	MENGV15	QUAN	15	3	Change in Stock: Unrestricted-Use Consignment Stock
108	BVSINSM	☐	MC_BVSINSM	MENGV15	QUAN	15	3	Change in Stock: Consignment Stock in Quality Inspection
109	BVSSPEM	☐	MC_BVSSPEM	MENGV15	QUAN	15	3	Change in Stock: Blocked Consignment Stock
110	BVCLABS	☐	MC_BVCLABS	MENGV15	QUAN	15	3	Change in Stock: Valuated, Unrestricted-Use Stock
111	BVCINSM	☐	MC_BVCINSM	MENGV15	QUAN	15	3	Change in Stock: Stock in Quality Inspection (Batch-Related)
112	BVCSPEM	☐	MC_BVCSPEM	MENGV15	QUAN	15	3	Change in Stock: Blocked Stock (Batch-Related)
113	BVCUMLM	☐	MC_BVCUMLM	MENGV15	QUAN	15	3	Change in Stock: Stock in Transfer (Batch-Related)
114	BVGLGMG	☐	MC_BVGLGMG	MENGV15	QUAN	15	3	Change in Stock: Tied Empties Stock
115	BVRETME	☐	MC_BVRETME	MENGV15	QUAN	15	3	Stock Change Blocked Stock Returns
116	BVCRETM	☐	MC_BVCRETM	MENGV15	QUAN	15	3	Stock Change for Blocked Stock Returns (Batch-Related)
117	LBUML	☐	MC_LBUML	MENGV15	QUAN	15	3	Stock in Transfer for Subcontracting (Plant to Plant)
118	KUUML	☐	MC_KUUML	MENGV15	QUAN	15	3	Stock in Transfer for Customer Consignment (Plant to Plant)
119	CWESB	☐	MC_CWESB	MENG13V	QUAN	13	3	Valuated GR-blocked stock, batch
120	EWESB	☐	MC_EWESB	MENG13V	QUAN	13	3	Valuated GR-blocked stock, Salesorder with batch
121	QWESB	☐	MC_QWESB	MENG13V	QUAN	13	3	Valuated GR-blocked stock, Project with batch
122	BVSABWE	☐	MC_BVSABWE	MENGV15	QUAN	15	3	Change of Valuated GR-Stock, SD, batch
123	BVSQBWE	☐	MC_BVSQBWE	MENGV15	QUAN	15	3	Change in Valuated GR-Stock, Project, batch
124	.INCLUDE	☐				0	0	Characteristics for Updating in Inventory Controlling
125	WAERS	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
126	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
127	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
128	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
129	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
130	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
131	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
132	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
133	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
134	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
135	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
136	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
137	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
138	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
139	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
140	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
141	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
142	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
143	LBKUM_VZ	☐	LBKUM_VZ	CHAR1	CHAR	1	0	+/- sign for delta posting LBKUM
144	SALK3_VZ	☐	SALK3_VZ	CHAR1	CHAR	1	0	+/- sign for delta posting SALK3
145	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
146	SYDAT	☐	SYDATUM	SYDATS	DATS	8	0	System Date
147	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
148	EKLAS	☐	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	*
149	QKLAS	☐	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	*
150	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
151	.INCLUDE	☐				0	0	Extension of MCBEST for inventory processing of MG materials
152	VKLAB	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
153	VKUML	☐	VKUML	WERT13N	CURR	13	2	Sales value in stock transfer (SLOc to SLoc)
154	VKUMC	☐	VKUMC	WERT13N	CURR	13	2	Stock transfer sales value (plant to plant) for VO material
155	VKTRW	☐	VKTRW	WERT13N	CURR	13	2	Transit value at sales price for value-only material
156	VKGLG	☐	VKGLG	WERT13N	CURR	13	2	Sales value of tied empties stock
157	.INCLUDE	☐				0	0	User Structure: Stock Fields and Material Master Information
158	DUMMY_USR	☐	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	MCBEST	BKLAS	T025	BKLAS
2	MCBEST	BUKRS	T001	BUKRS
3	MCBEST	CHARG	MCH1	CHARG
4	MCBEST	DISMM	T438A	DISMM
5	MCBEST	DISPO	T024D	DISPO
6	MCBEST	GSBER	TGSB	GSBER
7	MCBEST	KOKRS	TKA01	KOKRS
8	MCBEST	KUNNR	KNA1	KUNNR
9	MCBEST	LGORT	T001L	LGORT
10	MCBEST	LIFNR	LFA1	LIFNR
11	MCBEST	MANDT	T000	MANDT
12	MCBEST	MATKL	T023	MATKL
13	MCBEST	MATNR	MARA	MATNR
14	MCBEST	MEINS	T006	MSEHI
15	MCBEST	MTART	T134	MTART
16	MCBEST	PRCTR	CEPC	PRCTR
17	MCBEST	PRDHA	T179	PRODH
18	MCBEST	SOBKZ	T148	SOBKZ
19	MCBEST	SPART	TSPA	SPART
20	MCBEST	WAERS	TCURC	WAERS
21	MCBEST	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in