MCBESTB SAP (Communications Structure for MCBEST) Structure details
Description: Communications Structure for MCBEST
Structure field list including key, data, relationships and ABAP select examples
MCBESTB 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 "Communications Structure for MCBEST" 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_MCBESTB TYPE MCBESTB.
The MCBESTB table consists of various fields, each holding specific information or linking keys about Communications Structure for MCBEST data available in SAP. These include MANDT (Client), MATNR (Material Number), WERKS (Plant), LGORT (Storage Location).. 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 MCBESTB 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
KUNNR | Account Number of Customer | EKUNN | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
KA_ANONYM | Sales Order Stock, Valuated Anonymously | MC_KAANONYM | QUAN | 15(3) | MENGV15 | ||||
CKA_ANON | Sales Order Stock (Batch), Valuate Anonymously | MC_CKAANON | QUAN | 15(3) | MENGV15 | ||||
PR_ANONYM | Project Stock, Valuated Anonymously | MC_PRANON | QUAN | 15(3) | MENGV15 | ||||
CPR_ANON | Project Stock (Batch), Valuated Anonymously | MC_CPRANON | QUAN | 15(3) | MENGV15 | ||||
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 | ||||
WAERS | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | T024D | DISPO | DGR | HS_T024D | |
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
DISMM | MRP Type | DISMM | CHAR | 2 | T438A | DISMM | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
BKLAS | Valuation Class | BKLAS | CHAR | 4 | T025 | BKLAS | |||
SAKTO | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
PRDHA | Product hierarchy | PRODH_D | CHAR | 18 | T179 | PRODH | VPR | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | Assigned to domain | BWTTY | |||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | SUPKZ | ||||
LBKUM_VZ | +/- sign for delta posting LBKUM | LBKUM_VZ | CHAR | 1 | CHAR1 | ||||
SALK3_VZ | +/- sign for delta posting SALK3 | SALK3_VZ | CHAR | 1 | CHAR1 | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
SYDAT | System Date | SYDATUM | DATS | 8 | SYDATS | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
EKLAS | Valuation Class for Sales Order Stock | EKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
QKLAS | Valuation Class for Project Stock | QKLAS | CHAR | 4 | Assigned to domain | BKLAS | |||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
VKLAB | Stock value of a value-only material at sales price | VKLAB | CURR | 13(2) | WERT13N | ||||
VKUML | Sales value in stock transfer (SLOc to SLoc) | VKUML | CURR | 13(2) | WERT13N | ||||
VKUMC | Stock transfer sales value (plant to plant) for VO material | VKUMC | CURR | 13(2) | WERT13N | ||||
VKTRW | Transit value at sales price for value-only material | VKTRW | CURR | 13(2) | WERT13N | ||||
VKGLG | Sales value of tied empties stock | VKGLG | CURR | 13(2) | WERT13N | ||||
DUMMY_USR | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP structure MCBESTB using ABAP code?
As MCBESTB 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 MCBESTB as there is no data to select.How to access SAP table MCBESTB
Within an ECC or HANA version of SAP you can also view further information about MCBESTB 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