SAP Table MCBESTADD1
Stock Fields in Inventory Controlling
MCBESTADD1 (Stock Fields in Inventory Controlling) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MCBESTADD1 to other SAP tables.
MCBESTADD1 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
LABST | Valuated stock with unrestricted use | MC_LABST | QUAN | 15 | 3 | |||
UMLME | Stock in transfer (from one storage location to another) | MC_UMLMD | QUAN | 15 | 3 | |||
INSME | Stock in quality inspection | MC_INSME | QUAN | 15 | 3 | |||
KLABS | Unrestricted-use consignment stock | MC_KLABS | QUAN | 15 | 3 | |||
KINSM | Consignment Stock in Quality Inspection | MC_KINSM | QUAN | 15 | 3 | |||
UMLMC | Stock in transfer (plant to plant) | MC_UMLME | QUAN | 15 | 3 | |||
TRAME | Stock in transit | MC_TRAME | QUAN | 15 | 3 | |||
BWESB | Valuated GR Blocked Stock | MC_BWESB | QUAN | 15 | 3 | |||
KSPEM | Blocked consignment stock | MC_KSPEM | QUAN | 15 | 3 | |||
LBKUM | Total Valuated Stock | LBKUM | QUAN | 13 | 3 | |||
SALK3 | Value of Total Valuated Stock | SALK3 | CURR | 13 | 2 | |||
SPEME | Blocked stock | MC_SPEME | QUAN | 15 | 3 | |||
MBWBEST | Quantity of valuated stock | MBWBEST | QUAN | 15 | 3 | |||
MKOBEST | Quantity of consignment stock | MKOBEST | QUAN | 15 | 3 | |||
GSBEST | Total stock | GSBEST | QUAN | 15 | 3 | |||
WBWBEST | Value of valuated stock | WBWBEST | CURR | 15 | 2 | |||
EISBE | Safety stock | MC_EISBE | QUAN | 15 | 3 | |||
BESZUG | Stock level at goods receipt | BESZUG | QUAN | 15 | 3 | |||
WBESZUG | Value of stock at goods receipt | WBESZUG | CURR | 15 | 2 | |||
BVBEW | Change in valuated stock level | BVBEW | QUAN | 15 | 3 | |||
BVKON | Change in stock level of consignment stock | BVKON | QUAN | 15 | 3 | |||
BWERTV | Change in value of valuated stock | BWERTV | CURR | 15 | 2 | |||
CMBWBEST | Quantity of valuated stock per batch | CMBWBEST | QUAN | 15 | 3 | |||
CMKOBEST | Quantity of vendor consignment stock per batch | CMKOBEST | QUAN | 15 | 3 | |||
CWBWBEST | Value of valuated stock per batch | CWBWBEST | CURR | 15 | 2 | |||
CGSBEST | Quantity of total stock per batch | CGSBEST | QUAN | 15 | 3 | |||
KULAB | Unrestricted-use returnable packaging at the customer's | MC_MKLKL | QUAN | 15 | 3 | |||
KUINS | Customer inspection stock | MC_MKQKL | QUAN | 15 | 3 | |||
LBLAB | Unrestricted-use material(s) provided to vendor | MC_MSLBO | QUAN | 15 | 3 | |||
LBINS | Materials provided to vendor in quality inspection | MC_MSQBO | QUAN | 15 | 3 | |||
EINME | Storage Location Inventory of All Restricted-Use Batches | MC_EINME | QUAN | 15 | 3 | |||
LBEIN | Subcontracting Stock of All Restricted-Use Batches | MC_LBEIN | QUAN | 15 | 3 | |||
KUEIN | Sales Order Stock of All Restricted-Use Batches | MC_KUEIN | QUAN | 15 | 3 | |||
SEINM | Restricted-Use Consignment Stock | KEINM | QUAN | 13 | 3 | |||
CEINM | Storage Location Inventory of All Restricted-Use Batches | MC_EINME | QUAN | 15 | 3 | |||
KEINM | Restricted-Use Consignment Stock | KEINM | QUAN | 13 | 3 | |||
SLABS | Unrestricted-use consignment stock | MC_KLABS | QUAN | 15 | 3 | |||
SINSM | Consignment Stock in Quality Inspection | MC_KINSM | QUAN | 15 | 3 | |||
SSPEM | Blocked consignment stock | MC_KSPEM | QUAN | 15 | 3 | |||
CLABS | Valuated stock with unrestricted use | MC_LABST | QUAN | 15 | 3 | |||
CINSM | Stock in quality inspection | MC_INSME | QUAN | 15 | 3 | |||
CSPEM | Blocked stock | MC_SPEME | QUAN | 15 | 3 | |||
CUMLM | Stock in transfer (plant to plant) | MC_UMLME | QUAN | 15 | 3 | |||
GLGMG | Tied empties stock | MC_GLGMG | QUAN | 15 | 3 | |||
RETME | Blocked Stock Returns | RETME | QUAN | 13 | 3 | |||
CRETM | Blocked Stock Returns | RETME | QUAN | 13 | 3 | |||
PRLAB | Project stock, unrestricted use | MC_PRLAB | QUAN | 15 | 3 | |||
PRINS | Project stock, in quality inspection | MC_PRINS | QUAN | 15 | 3 | |||
PRSPE | Project stock, blocked | MC_PRSPE | QUAN | 15 | 3 | |||
PREIN | Project stock, restricted use | MC_PREIN | QUAN | 15 | 3 | |||
KALAB | Sales order stock, free | MC_KALAB | QUAN | 15 | 3 | |||
KAINS | Sales order stock, in quality inspection | MC_KAINS | QUAN | 15 | 3 | |||
KASPE | Sales order stock, blocked | MC_KASPE | QUAN | 15 | 3 | |||
KAEIN | Sales order stock, not free | MC_KAEIN | QUAN | 15 | 3 | |||
MTV_L | Returnable transport packaging, free | MC_MTV_L | QUAN | 15 | 3 | |||
MTV_I | Returnable transport packaging, in quality inspection | MC_MTV_I | QUAN | 15 | 3 | |||
MTV_S | Returnable transport packaging, blocked | MC_MTV_S | QUAN | 15 | 3 | |||
MTV_E | RTP, not free | MC_MTV_E | QUAN | 15 | 3 | |||
SALK3_E | Total Value of evaluated Sales Order Stock | SALK3_E | CURR | 13 | 2 | |||
SALK3_Q | Total Value of Valuated Project Stock | SALK3_Q | CURR | 13 | 2 | |||
LBKUM_E | Total valuated sales order stock | LBKUM_E | QUAN | 13 | 3 | |||
LBKUM_Q | Total valuated project stock | LBKUM_Q | QUAN | 13 | 3 | |||
MKABEST | Total sales order stock | MC_MKABEST | QUAN | 15 | 3 | |||
MPRBEST | Total project stock | MC_MPRBEST | QUAN | 15 | 3 | |||
WKABEST | Sales Order Stock Value | MC_WKABEST | CURR | 15 | 2 | |||
WPRBEST | Project Stock Value | MC_WPRBEST | CURR | 15 | 2 | |||
BVKA | Change in Stock Sales Order Stock | MC_BVKA | QUAN | 15 | 3 | |||
BVPR | Stock Change Project Stock | MC_BVPR | QUAN | 15 | 3 | |||
BWERTVKA | Value Change Sales Order Stock | MC_BWERTVKA | CURR | 15 | 2 | |||
BWERTVPR | Value Change Project Stock | MC_BWERTVPR | CURR | 15 | 2 | |||
BVLABST | Change in Stock: Valuated, Unrestricted-Use Stock | MC_BVLABST | QUAN | 15 | 3 | |||
BVUMLME | Change in Stock: Stock in Transfer | MC_BVUMLME | QUAN | 15 | 3 | |||
BVINSME | Change in Stock: Stock in Quality Inspection | MC_BVINSME | QUAN | 15 | 3 | |||
BVKLABS | Change in Stock: Unrestricted-Use Consignment Stock | MC_BVKLABS | QUAN | 15 | 3 | |||
BVKINSM | Change in Stock: Consignment Stock in Quality Inspection | MC_BVKINSM | QUAN | 15 | 3 | |||
BVUMLMC | Change in Stock: Stock in Transfer (Plant to Plant) | MC_BVUMLMC | QUAN | 15 | 3 | |||
BVTRAME | Change in Stock: Stock in Transit | MC_BVTRAME | QUAN | 15 | 3 | |||
BVBWESB | Change in Stock: Valuated GR Blocked Stock | MC_BVBWESB | QUAN | 15 | 3 | |||
BVKSPEM | Change in Stock: Blocked Consignment Stock | MC_BVKSPEM | QUAN | 15 | 3 | |||
BVSPEME | Change in Stock: Blocked Stock | MC_BVSPEME | QUAN | 15 | 3 | |||
BVKULAB | Change in Stock: Unrestricted-Use Stock at Customer | MC_BVKULAB | QUAN | 15 | 3 | |||
BVKUINS | Change in Stock: Stock in Quality Inspection at Customer | MC_BVKUINS | QUAN | 15 | 3 | |||
BVLBLAB | Change in Stock: Provision of Material to Vendor-Unrest.-Use | MC_BVLBLAB | QUAN | 15 | 3 | |||
BVLBINS | Change in Stock: Provision of Matl to Vendor in Qual. Insp. | MC_BVLBINS | QUAN | 15 | 3 | |||
BVEINME | Change in Stock: Storage Locatn Stock All Restrd-Use Batches | MC_BVEINME | QUAN | 15 | 3 | |||
BVLBEIN | Stock Change: Stock Provided to Vendor(Restricted-Use Batch) | MC_BVLBEIN | QUAN | 15 | 3 | |||
BVKUEIN | Change in Stock: Sales Order Stock, Restricted-Use (Batch) | MC_BVKUEIN | QUAN | 15 | 3 | |||
BVSEINM | Change in Stock: Restricted-Use Consignment Stock (Batch) | MC_BVSEINM | QUAN | 15 | 3 | |||
BVCEINM | Change in Stock: Storage Locatn Stock All Restrd-Use Batches | MC_BVCEINM | QUAN | 15 | 3 | |||
BVKEINM | Change in Stock: Restricted-Use Consignment Stock | MC_BVKEINM | QUAN | 15 | 3 | |||
BVSLABS | Change in Stock: Unrestricted-Use Consignment Stock | MC_BVSLABS | QUAN | 15 | 3 | |||
BVSINSM | Change in Stock: Consignment Stock in Quality Inspection | MC_BVSINSM | QUAN | 15 | 3 | |||
BVSSPEM | Change in Stock: Blocked Consignment Stock | MC_BVSSPEM | QUAN | 15 | 3 | |||
BVCLABS | Change in Stock: Valuated, Unrestricted-Use Stock | MC_BVCLABS | QUAN | 15 | 3 | |||
BVCINSM | Change in Stock: Stock in Quality Inspection (Batch-Related) | MC_BVCINSM | QUAN | 15 | 3 | |||
BVCSPEM | Change in Stock: Blocked Stock (Batch-Related) | MC_BVCSPEM | QUAN | 15 | 3 | |||
BVCUMLM | Change in Stock: Stock in Transfer (Batch-Related) | MC_BVCUMLM | QUAN | 15 | 3 | |||
BVGLGMG | Change in Stock: Tied Empties Stock | MC_BVGLGMG | QUAN | 15 | 3 | |||
BVRETME | Stock Change Blocked Stock Returns | MC_BVRETME | QUAN | 15 | 3 | |||
BVCRETM | Stock Change for Blocked Stock Returns (Batch-Related) | MC_BVCRETM | QUAN | 15 | 3 | |||
LBUML | Stock in Transfer for Subcontracting (Plant to Plant) | MC_LBUML | QUAN | 15 | 3 | |||
KUUML | Stock in Transfer for Customer Consignment (Plant to Plant) | MC_KUUML | QUAN | 15 | 3 | |||
CWESB | Valuated GR-blocked stock, batch | MC_CWESB | QUAN | 13 | 3 | |||
EWESB | Valuated GR-blocked stock, Salesorder with batch | MC_EWESB | QUAN | 13 | 3 | |||
QWESB | Valuated GR-blocked stock, Project with batch | MC_QWESB | QUAN | 13 | 3 | |||
BVSABWE | Change of Valuated GR-Stock, SD, batch | MC_BVSABWE | QUAN | 15 | 3 | |||
BVSQBWE | Change in Valuated GR-Stock, Project, batch | MC_BVSQBWE | QUAN | 15 | 3 |