Top Table - list SAP © Materials Management Module MM
View table content with transaction SE16, SE16N or SE16H (with HANA-Database) and tablestructure with SE11
Material Master , Submodule MM-MD
Table | Table - name | S/4HANA -Table and general Notes | MAEX | Material Master: Legal Control | MAKT | Material Descriptions | Field ‘Material description in upper case’ (MAKTG) for the search. In Logical Database MMIMRKPFRESB S1L S2L. | MAKV | Material Cost Distribution | MAKZ | Material cost distribution equivalence numbers | MAPE | Material Master: Export Control File | MAPL | Assignment of Task Lists to Materials | In Logical Database PNM PNM_OLD. | MARA | General Material Data | In Logical Database /SAPSLL/CUSMSM BAM BKM BMM CKM EBM ECM ENM ESM IFM S1L WTY. | MARC | Plant Data for Material | S/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM S1L. | MARD | Storage Location Data for Material | S/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM MSM. | MARM | Units of Measure for Material | In Logical Database MSM. | MARV | Material Control Record | Current MM-Period. | MAST | Material to BOM Link | In Logical Database CKA CSR. | MBEW | Material Valuation | In Logical Database /SAPSLL/CUSMSM BMM CKA. | MDFD | MRP firming date | MDIP | Material: MRP Profiles (Field Contents) | MKAL | Production Versions of Material | MLAN | Tax Classification for Material | MLGN | Material Data for Each Warehouse Number | In Logical Database MSM S1L. | MLGT | Material Data for Each Storage Type | In Logical Database MSM. | MPGD_MASS | Planning Data | MPOP | Forecast Parameters | MSPR | Project Stock | MSSA | Total Customer Orders on Hand | MSSL | Total Special Stocks with Vendor | MVER | Material Consumption | MVKE | Sales Data for Material | In Logical Database MSM. | PROP | Forecast parameters | QMAT | Inspection type - material parameters | Inspection type. | STXH | STXD SAPscript text file header | STXH is always filled for a SO10 text module. Edit with transaction SO10. Function READ_TEXT to show and SAVE_TEXT to insert. In Logical Database AAV AKV ALV ARV BBM ERM ILM. | STXL | STXD SAPscript text file lines | Edit with transaction SO10. Function READ_TEXT to show and SAVE_TEXT to insert . In Logical Database AAV AKV ALV ARV BBM ERM ILM. | T179 | Materials: Product Hierarchies |
Inventory
Table | Table - name | S/4HANA -Table and general Notes | MCHB | Batch Stocks | In Logical Database /SAPSLL/CUSMSM MSM. | MKOL | Special Stocks from Vendor | In Logical Database MSM. | MSKA | Sales Order Stock | MSKU | Special Stocks with Customer | MSLB | Special Stocks with Supplier | MSPR | Project Stock | MSSA | Total Customer Orders on Hand | MSSQ | Project Stock Total | MSTB | Stock in Transit | MSTE | Stock in Transit to Sales and Distribution Document | MSTQ | Stock in Transit for Project |
Production
Table | Table - name | S/4HANA -Table and general Notes | CHVW | Table CHVW for Batch Where-Used List | MCH1 | Batches (if Batch Management Cross-Plant) | MCHA | Batches | MCHB | Batch Stocks | In Logical Database /SAPSLL/CUSMSM MSM. |
Dispatch data
Table | Table - name | S/4HANA -Table and general Notes | DBVM | Planning File Entry, MRP Area | DVER | Material Consumption for MRP Area | MAPR | Material Index for Forecast | MDMA | MRP Area for Material |
Status
Table | Table - name | S/4HANA -Table and general Notes | MOFF | Outstanding Material Master Records | MSTA | Material Master Status |
Historical data
Table | Table - name | S/4HANA -Table and general Notes | MARCH | Material Master C Segment: History | MARDH | Material Master Storage Location Segment: History | MBEWH | Material Valuation: History | MCHBH | Batch Stocks: History | MKOLH | Special Stocks from Vendor: History | MSCAH | Sales Order Stock at Vendor: History | MSKAH | Sales Order Stock: History | MSKUH | Special Stocks at Customer: History | MSLBH | Special Stocks at Vendor: History | MSPRH | Project Stock: History | MSSAH | Total Sales Order Stocks: History | MSSQH | Total Project Stocks: History | MSTBH | Stock in Transit - History | MSTEH | SiT to Sales and Distribution Document - History | MSTQH | Stock in Transit for Project - History |
Material Ledger Mandatory in S/4
Table | Table - name | S/4HANA -Table and general Notes | CKMLCR | Material Ledger: Period Totals Records Values | CKMLKEPH | Material Ledger: Cost Component Split (Elements) | CKMLPP | Material Ledger Period Totals Records Quantity | CKMLPPWIP | Material-Ledger: Period Records WIP (Quantities) | MLCD | Material Ledger: Summarization Record (from Documents) | MLCR | Material Ledger Document: Currencies and Values | MLCRF | Material Ledger Document: Field Groups (Currencies) | MLHD | Material Ledger Document: Header | MLIT | Material Ledger Document: Items | MLPP | Material Ledger Document: Posting Periods and Quantities | MLPPF | Material Ledger Document: Field Groups (Posting Periods) |
Material documents
Table | Table - name | S/4HANA -Table and general Notes | MKPF | Header: Material Document | In Logical Database BMM LMM LNM MRM PGQ. | MSEG | Document Segment: Material | In Logical Database BMM L1M LMM LNM MRM PGQ. |
New Material documents - tables in S/4
Table | Table - name | S/4HANA -Table and general Notes | MATDOC | Material Documents | MLDOC | Material Ledger Document | MLDOCCCS | Material Ledger Document Cost Component Split |
Inventory
Table | Table - name | S/4HANA -Table and general Notes | IKPF | Header: Physical Inventory Document | In Logical Database IMM INM IRM. | ISEG | Physical Inventory Document Items | In Logical Database IMM INM IRM. |
Reservation
Table | Table - name | S/4HANA -Table and general Notes | RESB | Reservation/dependent requirements | In Logical Database BBM ERM MEPOLDB MMIMRKPFRESB ODC OFC OHC OPC POH RMM RNM. | RKPF | Document Header: Reservation | In Logical Database MMIMRKPFRESB RKM RNM. |
Enterprise Structure Part of the Customizing. To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
Table | Table - name | S/4HANA -Table and general Notes | T001K | Valuation area | T001L | Storage Locations | T001W | Plants/Branches | T024 | Purchasing Groups | T024E | Purchasing Organizations | T024W | Valid Purchasing Organizations for Plant | T024Z | Purchasing Organizations | T499S | Location | TSPA | Organizational Unit: Sales Divisions |
Customizing - Tables To go to the IMG customizing entry, enter the table name in transaction SM30, click on 'Customizing' and then on 'Continue w/o Specifying Project'.
Table | Table - name | S/4HANA -Table and general Notes | MDLG | Customizing: MRP Area Storage Location | MDLL | Customizing: MRP Area Subcontractor | MDLV | Customizing MRP Area | MDLW | Customizing: MRP Area Plants | NRIV | Number Range Intervals | Edit with transaction SNUM. Object=MATERIALNR for materials. Maintain Material Master Number Ranges intervals directly via transaction MMNR. | T023 | Material Groups | T025 | Valuation Classes | T025T | Valuation Class Descriptions | T030 | Standard Accounts Table | FI-Accounting determination in MM. Edit with transaction OBYC or OMWB. | T030H | Acct Determ.for Open Item Exch.Rate Differences | T137 | Industries for materials | T156 | Movement Type | T156M | Posting String: Quantity | T156SY | Mvt Type: Qty/Value Update: System Table; Rel. 4.6A | T156T | Movement Type Text | In Logical Database MMIMRKPFRESB. | T156W | Posting string values | T157H | Help Texts for Movement Types |
Report a missing table or a suggestion for improvement here...
Additional tables for the following modules at Erp-Top.com:
Financial Accounting Module FI General Ledger Module FI-GL Accounts Receivable Module FI-AR Accounts Payable Module FI-AP Banks Module FI-BL Fixed Assets Module FI-AA Controlling Module CO Cost Element Accounting Module CO-OM-CEL Cost Center Accounting Module CO-OM-CCA Internal Orders Module CO-OM-OPA Product Cost Controlling Module CO-PC Profitcenter Module EC-PCA Flexible Real Estate Management Module RE-FX Lease Management RE-FX-LA Sales and Distribution Module SD Purchasing Module MM-PUR Quality-Management Module QM Plant Maintenance Module PM Production Planning and Manufacturing Module PP Production Planning Process Industries Module PP-PI Project System Module PS Personnel Management Module PA for ABAP for the Basis and Administrators Cross Module Business Partner BP, Module AP-MD-BP Top Transaction - list SAP © Materials Management Module MM
Material Master , Submodule MM-MD
Transaction | Transaction - Name | Notes | MM01 | Create Material | Extend material number length up to 40 digits via customizing transaction OMSL | MM04 | Display Material Change Documents | MM11 | Schedule Creation of Material | MM12 | Schedule Changing of Material | MM17 | Mass Maintenance: Indus. Matl Master | MM41 | Create Material | MMAM | Change Material Type | MMCC | Copy Material |
Customizing - Transactions
Transaction | Transaction - Name | Notes | MMNR | Define Material Master Number Ranges | OBA7 | C FI maintain table T003 | Document Types for Finance | OMS2 | Maintain Material Types | OMSL | C MM-BD Maintain TMCNV | Extend material number length up to 40 digits |