MCBESTADD1 SAP (Stock Fields in Inventory Controlling) Structure details
Description: Stock Fields in Inventory Controlling
Structure field list including key, data, relationships and ABAP select examples
MCBESTADD1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Stock Fields in Inventory Controlling" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCBESTADD1 TYPE MCBESTADD1.
The MCBESTADD1 table consists of various fields, each holding specific information or linking keys about Stock Fields in Inventory Controlling data available in SAP. These include UMLME (Stock in transfer (from one storage location to another)), INSME (Stock in quality inspection), KLABS (Unrestricted-use consignment stock), KINSM (Consignment Stock in Quality Inspection).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCBESTADD1 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
LABST | Valuated stock with unrestricted use | MC_LABST | QUAN | 15(3) | MENGV15 | ||||
UMLME | Stock in transfer (from one storage location to another) | MC_UMLMD | QUAN | 15(3) | MENGV15 | ||||
INSME | Stock in quality inspection | MC_INSME | QUAN | 15(3) | MENGV15 | ||||
KLABS | Unrestricted-use consignment stock | MC_KLABS | QUAN | 15(3) | MENGV15 | ||||
KINSM | Consignment Stock in Quality Inspection | MC_KINSM | QUAN | 15(3) | MENGV15 | ||||
UMLMC | Stock in transfer (plant to plant) | MC_UMLME | QUAN | 15(3) | MENGV15 | ||||
TRAME | Stock in transit | MC_TRAME | QUAN | 15(3) | MENGV15 | ||||
BWESB | Valuated GR Blocked Stock | MC_BWESB | QUAN | 15(3) | MENGV15 | ||||
KSPEM | Blocked consignment stock | MC_KSPEM | QUAN | 15(3) | MENGV15 | ||||
LBKUM | Total Valuated Stock | LBKUM | QUAN | 13(3) | MENG13V | ||||
SALK3 | Value of Total Valuated Stock | SALK3 | CURR | 13(2) | WERT13N | ||||
SPEME | Blocked stock | MC_SPEME | QUAN | 15(3) | MENGV15 | ||||
MBWBEST | Quantity of valuated stock | MBWBEST | QUAN | 15(3) | MENGV15 | ||||
MKOBEST | Quantity of consignment stock | MKOBEST | QUAN | 15(3) | MENGV15 | ||||
GSBEST | Total stock | GSBEST | QUAN | 15(3) | MENGV15 | ||||
WBWBEST | Value of valuated stock | WBWBEST | CURR | 15(2) | WERT15 | ||||
EISBE | Safety stock | MC_EISBE | QUAN | 15(3) | MENGV15 | ||||
BESZUG | Stock level at goods receipt | BESZUG | QUAN | 15(3) | MENGV15 | ||||
WBESZUG | Value of stock at goods receipt | WBESZUG | CURR | 15(2) | WERT15 | ||||
BVBEW | Change in valuated stock level | BVBEW | QUAN | 15(3) | MENGV15 | ||||
BVKON | Change in stock level of consignment stock | BVKON | QUAN | 15(3) | MENGV15 | ||||
BWERTV | Change in value of valuated stock | BWERTV | CURR | 15(2) | WERT15 | ||||
CMBWBEST | Quantity of valuated stock per batch | CMBWBEST | QUAN | 15(3) | MENGV15 | ||||
CMKOBEST | Quantity of vendor consignment stock per batch | CMKOBEST | QUAN | 15(3) | MENGV15 | ||||
CWBWBEST | Value of valuated stock per batch | CWBWBEST | CURR | 15(2) | WERT15 | ||||
CGSBEST | Quantity of total stock per batch | CGSBEST | QUAN | 15(3) | MENGV15 | ||||
KULAB | Unrestricted-use returnable packaging at the customer's | MC_MKLKL | QUAN | 15(3) | MENGV15 | ||||
KUINS | Customer inspection stock | MC_MKQKL | QUAN | 15(3) | MENGV15 | ||||
LBLAB | Unrestricted-use material(s) provided to vendor | MC_MSLBO | QUAN | 15(3) | MENGV15 | ||||
LBINS | Materials provided to vendor in quality inspection | MC_MSQBO | QUAN | 15(3) | MENGV15 | ||||
EINME | Storage Location Inventory of All Restricted-Use Batches | MC_EINME | QUAN | 15(3) | MENGV15 | ||||
LBEIN | Subcontracting Stock of All Restricted-Use Batches | MC_LBEIN | QUAN | 15(3) | MENGV15 | ||||
KUEIN | Sales Order Stock of All Restricted-Use Batches | MC_KUEIN | QUAN | 15(3) | MENGV15 | ||||
SEINM | Restricted-Use Consignment Stock | KEINM | QUAN | 13(3) | MENG13V | ||||
CEINM | Storage Location Inventory of All Restricted-Use Batches | MC_EINME | QUAN | 15(3) | MENGV15 | ||||
KEINM | Restricted-Use Consignment Stock | KEINM | QUAN | 13(3) | MENG13V | ||||
SLABS | Unrestricted-use consignment stock | MC_KLABS | QUAN | 15(3) | MENGV15 | ||||
SINSM | Consignment Stock in Quality Inspection | MC_KINSM | QUAN | 15(3) | MENGV15 | ||||
SSPEM | Blocked consignment stock | MC_KSPEM | QUAN | 15(3) | MENGV15 | ||||
CLABS | Valuated stock with unrestricted use | MC_LABST | QUAN | 15(3) | MENGV15 | ||||
CINSM | Stock in quality inspection | MC_INSME | QUAN | 15(3) | MENGV15 | ||||
CSPEM | Blocked stock | MC_SPEME | QUAN | 15(3) | MENGV15 | ||||
CUMLM | Stock in transfer (plant to plant) | MC_UMLME | QUAN | 15(3) | MENGV15 | ||||
GLGMG | Tied empties stock | MC_GLGMG | QUAN | 15(3) | MENGV15 | ||||
RETME | Blocked Stock Returns | RETME | QUAN | 13(3) | MENG13V | ||||
CRETM | Blocked Stock Returns | RETME | QUAN | 13(3) | MENG13V | ||||
PRLAB | Project stock, unrestricted use | MC_PRLAB | QUAN | 15(3) | MENGV15 | ||||
PRINS | Project stock, in quality inspection | MC_PRINS | QUAN | 15(3) | MENGV15 | ||||
PRSPE | Project stock, blocked | MC_PRSPE | QUAN | 15(3) | MENGV15 | ||||
PREIN | Project stock, restricted use | MC_PREIN | QUAN | 15(3) | MENGV15 | ||||
KALAB | Sales order stock, free | MC_KALAB | QUAN | 15(3) | MENGV15 | ||||
KAINS | Sales order stock, in quality inspection | MC_KAINS | QUAN | 15(3) | MENGV15 | ||||
KASPE | Sales order stock, blocked | MC_KASPE | QUAN | 15(3) | MENGV15 | ||||
KAEIN | Sales order stock, not free | MC_KAEIN | QUAN | 15(3) | MENGV15 | ||||
MTV_L | Returnable transport packaging, free | MC_MTV_L | QUAN | 15(3) | MENGV15 | ||||
MTV_I | Returnable transport packaging, in quality inspection | MC_MTV_I | QUAN | 15(3) | MENGV15 | ||||
MTV_S | Returnable transport packaging, blocked | MC_MTV_S | QUAN | 15(3) | MENGV15 | ||||
MTV_E | RTP, not free | MC_MTV_E | QUAN | 15(3) | MENGV15 | ||||
SALK3_E | Total Value of evaluated Sales Order Stock | SALK3_E | CURR | 13(2) | WERT13N | ||||
SALK3_Q | Total Value of Valuated Project Stock | SALK3_Q | CURR | 13(2) | WERT13N | ||||
LBKUM_E | Total valuated sales order stock | LBKUM_E | QUAN | 13(3) | MENG13V | ||||
LBKUM_Q | Total valuated project stock | LBKUM_Q | QUAN | 13(3) | MENG13V | ||||
MKABEST | Total sales order stock | MC_MKABEST | QUAN | 15(3) | MENGV15 | ||||
MPRBEST | Total project stock | MC_MPRBEST | QUAN | 15(3) | MENGV15 | ||||
WKABEST | Sales Order Stock Value | MC_WKABEST | CURR | 15(2) | WERT15 | ||||
WPRBEST | Project Stock Value | MC_WPRBEST | CURR | 15(2) | WERT15 | ||||
BVKA | Change in Stock Sales Order Stock | MC_BVKA | QUAN | 15(3) | MENGV15 | ||||
BVPR | Stock Change Project Stock | MC_BVPR | QUAN | 15(3) | MENGV15 | ||||
BWERTVKA | Value Change Sales Order Stock | MC_BWERTVKA | CURR | 15(2) | WERT15 | ||||
BWERTVPR | Value Change Project Stock | MC_BWERTVPR | CURR | 15(2) | WERT15 | ||||
BVLABST | Change in Stock: Valuated, Unrestricted-Use Stock | MC_BVLABST | QUAN | 15(3) | MENGV15 | ||||
BVUMLME | Change in Stock: Stock in Transfer | MC_BVUMLME | QUAN | 15(3) | MENGV15 | ||||
BVINSME | Change in Stock: Stock in Quality Inspection | MC_BVINSME | QUAN | 15(3) | MENGV15 | ||||
BVKLABS | Change in Stock: Unrestricted-Use Consignment Stock | MC_BVKLABS | QUAN | 15(3) | MENGV15 | ||||
BVKINSM | Change in Stock: Consignment Stock in Quality Inspection | MC_BVKINSM | QUAN | 15(3) | MENGV15 | ||||
BVUMLMC | Change in Stock: Stock in Transfer (Plant to Plant) | MC_BVUMLMC | QUAN | 15(3) | MENGV15 | ||||
BVTRAME | Change in Stock: Stock in Transit | MC_BVTRAME | QUAN | 15(3) | MENGV15 | ||||
BVBWESB | Change in Stock: Valuated GR Blocked Stock | MC_BVBWESB | QUAN | 15(3) | MENGV15 | ||||
BVKSPEM | Change in Stock: Blocked Consignment Stock | MC_BVKSPEM | QUAN | 15(3) | MENGV15 | ||||
BVSPEME | Change in Stock: Blocked Stock | MC_BVSPEME | QUAN | 15(3) | MENGV15 | ||||
BVKULAB | Change in Stock: Unrestricted-Use Stock at Customer | MC_BVKULAB | QUAN | 15(3) | MENGV15 | ||||
BVKUINS | Change in Stock: Stock in Quality Inspection at Customer | MC_BVKUINS | QUAN | 15(3) | MENGV15 | ||||
BVLBLAB | Change in Stock: Provision of Material to Vendor-Unrest.-Use | MC_BVLBLAB | QUAN | 15(3) | MENGV15 | ||||
BVLBINS | Change in Stock: Provision of Matl to Vendor in Qual. Insp. | MC_BVLBINS | QUAN | 15(3) | MENGV15 | ||||
BVEINME | Change in Stock: Storage Locatn Stock All Restrd-Use Batches | MC_BVEINME | QUAN | 15(3) | MENGV15 | ||||
BVLBEIN | Stock Change: Stock Provided to Vendor(Restricted-Use Batch) | MC_BVLBEIN | QUAN | 15(3) | MENGV15 | ||||
BVKUEIN | Change in Stock: Sales Order Stock, Restricted-Use (Batch) | MC_BVKUEIN | QUAN | 15(3) | MENGV15 | ||||
BVSEINM | Change in Stock: Restricted-Use Consignment Stock (Batch) | MC_BVSEINM | QUAN | 15(3) | MENGV15 | ||||
BVCEINM | Change in Stock: Storage Locatn Stock All Restrd-Use Batches | MC_BVCEINM | QUAN | 15(3) | MENGV15 | ||||
BVKEINM | Change in Stock: Restricted-Use Consignment Stock | MC_BVKEINM | QUAN | 15(3) | MENGV15 | ||||
BVSLABS | Change in Stock: Unrestricted-Use Consignment Stock | MC_BVSLABS | QUAN | 15(3) | MENGV15 | ||||
BVSINSM | Change in Stock: Consignment Stock in Quality Inspection | MC_BVSINSM | QUAN | 15(3) | MENGV15 | ||||
BVSSPEM | Change in Stock: Blocked Consignment Stock | MC_BVSSPEM | QUAN | 15(3) | MENGV15 | ||||
BVCLABS | Change in Stock: Valuated, Unrestricted-Use Stock | MC_BVCLABS | QUAN | 15(3) | MENGV15 | ||||
BVCINSM | Change in Stock: Stock in Quality Inspection (Batch-Related) | MC_BVCINSM | QUAN | 15(3) | MENGV15 | ||||
BVCSPEM | Change in Stock: Blocked Stock (Batch-Related) | MC_BVCSPEM | QUAN | 15(3) | MENGV15 | ||||
BVCUMLM | Change in Stock: Stock in Transfer (Batch-Related) | MC_BVCUMLM | QUAN | 15(3) | MENGV15 | ||||
BVGLGMG | Change in Stock: Tied Empties Stock | MC_BVGLGMG | QUAN | 15(3) | MENGV15 | ||||
BVRETME | Stock Change Blocked Stock Returns | MC_BVRETME | QUAN | 15(3) | MENGV15 | ||||
BVCRETM | Stock Change for Blocked Stock Returns (Batch-Related) | MC_BVCRETM | QUAN | 15(3) | MENGV15 | ||||
LBUML | Stock in Transfer for Subcontracting (Plant to Plant) | MC_LBUML | QUAN | 15(3) | MENGV15 | ||||
KUUML | Stock in Transfer for Customer Consignment (Plant to Plant) | MC_KUUML | QUAN | 15(3) | MENGV15 | ||||
CWESB | Valuated GR-blocked stock, batch | MC_CWESB | QUAN | 13(3) | MENG13V | ||||
EWESB | Valuated GR-blocked stock, Salesorder with batch | MC_EWESB | QUAN | 13(3) | MENG13V | ||||
QWESB | Valuated GR-blocked stock, Project with batch | MC_QWESB | QUAN | 13(3) | MENG13V | ||||
BVSABWE | Change of Valuated GR-Stock, SD, batch | MC_BVSABWE | QUAN | 15(3) | MENGV15 | ||||
BVSQBWE | Change in Valuated GR-Stock, Project, batch | MC_BVSQBWE | QUAN | 15(3) | MENGV15 |
Key field | Non-key field |
How do I retrieve data from SAP structure MCBESTADD1 using ABAP code?
As MCBESTADD1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCBESTADD1 as there is no data to select.How to access SAP table MCBESTADD1
Within an ECC or HANA version of SAP you can also view further information about MCBESTADD1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects