SAP ABAP Table MCBESTB (Communications Structure for MCBEST)

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	MCBESTB	Table Relationship Diagram
Short Description	Communications Structure for MCBEST

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	470