MTCOM SAP (Material Master Communication) Structure details
Description: Material Master Communication
Structure field list including key, data, relationships and ABAP select examples
MTCOM 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 "Material Master Communication" 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_MTCOM TYPE MTCOM.
The MTCOM table consists of various fields, each holding specific information or linking keys about Material Master Communication data available in SAP. These include MATNR (Material Number), BUKRS (Company Code), 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 MTCOM 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 |
KENNG | View ID | KENNG____1 | CHAR | 5 | KENNG____1 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
LGTYP | Storage Type | LGTYP | CHAR | 3 | Assigned to domain | LGTYP | LGT | H_T301 | |
MYKEY | LIFO valuation level | MYKEY | CHAR | 4 | Assigned to domain | MYKEY | MYL | ||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | Assigned to domain | BWKEY | BWK | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
MEINH | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PSTAT | Maintenance status | PSTAT_D | CHAR | 15 | PSTAT | ||||
XRUEJ | Indicator: post to previous year | XRUEJ | CHAR | 1 | XFELD | ||||
XRUEM | Allow Posting to Previous Period (Backposting) | XRUEM | CHAR | 1 | XFELD | ||||
EKWSL | Purchasing Value Key | EKWSL | CHAR | 4 | Assigned to domain | EKWSL | |||
NOMUS | Ind.: suppress error message in the case of required tables | NOMUS | CHAR | 1 | XFELD | ||||
MTART | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
DISMM | MRP Type | DISMM | CHAR | 2 | Assigned to domain | DISMM | |||
DISLS | Lot size (materials planning) | DISLS | CHAR | 2 | Assigned to domain | DISLS | |||
NOVOR | Indicator: no default val. for valuation area and sales org. | NOVOR | CHAR | 1 | XFELD | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | Assigned to domain | BWTTY | |||
ALAND | Departure country (country from which the goods are sent) | ALAND | CHAR | 3 | Assigned to domain | LAND1 | VAL | ||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2 | Assigned to domain | MMSTA | |||
MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2 | Assigned to domain | MMSTA | |||
VMSTA | Distribution-chain-specific material status | VMSTA | CHAR | 2 | Assigned to domain | VMSTA | |||
MSTAV | Cross-distribution-chain material status | MSTAV | CHAR | 2 | Assigned to domain | VMSTA | |||
LIFSP_MVKE | Default delivery block | LIFSP | CHAR | 2 | Assigned to domain | LIFSP | |||
LIFSP_MARA | Default delivery block | LIFSP | CHAR | 2 | Assigned to domain | LIFSP | |||
KZSPR | Indicator: Lock | KZSPR | CHAR | 1 | XFELD | ||||
KZSPM | Indicator: Lock MBEW differently (E/S/N/blank) | KZSPM | CHAR | 1 | XFELD | ||||
SPR_MEINS | Indicator: Lock base unit of measure instead of MARA segment | SPR_MEINS | CHAR | 1 | XFELD | ||||
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
KZRFB | Indicator: reset buffer for Material_Pre_Fetch | KZRFB | CHAR | 1 | XFELD | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
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 | |||
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
KZVPL | Indicator that planning data for plant should be read | KZVPL | CHAR | 1 | XFLAG | ||||
MAXTZ | Maximum number of table lines | MAXTZ | INT4 | 10 | SYST_LONG | ||||
PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
SOBSL | Special procurement type | SOBSL | CHAR | 2 | Assigned to domain | SOBSL | |||
XVKBW | Sales price valuation active | XVKBW | CHAR | 1 | XFELD | ||||
KZISO | Indicator: Switch to committed level (for MBEW/MBEFU) | KZISO | CHAR | 1 | XFELD | ||||
NOPLTRS | No error message if MARC does not exist (with MC29S) | NOPLTRS | CHAR | 1 | XFELD | ||||
SAEXC | Indicator: Raise exception if generic material | SAEXC | CHAR | 1 | XFELD | ||||
WVEXC | Ind.: Raise exception if material group reference material | WVEXC | CHAR | 1 | XFELD | ||||
DATUM | Date for calling MATERIAL_READ | MTCOM_DAT | DATS | 8 | DATUM | ||||
T141_FELD | Field from table T141 relevant for reading T141T | T141_FELD | CHAR | 30 | Assigned to domain | ROLLNAME | |||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
KZMPN | Indicator: Use manufacturer part numbers | KZMPN | CHAR | 1 | XFELD | ||||
SYSDEF | Configuration: manufacturing or industry-solution system | SYSDEF | CHAR | 2 | SYSDEF | ||||
SCOPELOCK | Control lock behavior when calling the update task | DDENQSCOPE | NUMC | 1 | DDENQSCOPE | ||||
WAITLOCK | Indicator: Lock with wait locks | MTCOM_WAIT | CHAR | 1 | XFELD | ||||
NO_RFMARA | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
NO_RFMAKT | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
XVPER | Indicator: Determine data for previous period | XVPER | CHAR | 1 | XFELD | ||||
XVVPR | Indicator: Determine data for period before last | XVVPR | CHAR | 1 | XFELD | ||||
XVJAH | Indicator: Determine data for last period of previous year | XVJAH | CHAR | 1 | XFELD | ||||
XVVJA | Ind.: Determine data for last period of year before last | XVVJA | CHAR | 1 | XFELD | ||||
READ_MARA | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
XOBEW | Vendor Stock Valuation Indicator | XOBEW | CHAR | 1 | XFELD | ||||
NO_LIST | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
BERID | MRP Area | BERID | CHAR | 10 | Assigned to domain | BERID | BERID | ||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
KZSPC | Lock Mode Set on Table MCH1 by BAdI (Exclusive/Shared) | KZSPC | CHAR | 1 | CHAR1 | ||||
.INCLU--AP | 0 | ||||||||
OWNER | Owner of stock | OWNER_D | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
.INCLU--AP | 0 | ||||||||
IND_HEAD | Indicator: Read header materials | MGVINDHEAD | CHAR | 1 | XFELD | ||||
IND_INVALID | Indicator: Read invalid versions | MGVINDINVALID | CHAR | 1 | XFELD | ||||
IND_NOVALCHECK | Indicator: Do not execute effectivity check | MGVINDNOVALCHECK | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure MTCOM using ABAP code?
As MTCOM 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 MTCOM as there is no data to select.How to access SAP table MTCOM
Within an ECC or HANA version of SAP you can also view further information about MTCOM 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