Materials Management MM, Plan to Inventory (PTI)

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   

TableTable - nameS/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
MAPEMaterial 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
MDIPMaterial: 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   

TableTable - nameS/4HANA -Table and general Notes
MCHB Batch Stocks In Logical Database /SAPSLL/CUSMSM MSM.
MKOL Special Stocks from Vendor In Logical Database MSM.
MSKASales Order Stock
MSKUSpecial Stocks with Customer
MSLBSpecial Stocks with Supplier
MSPR Project Stock
MSSA Total Customer Orders on Hand
MSSQProject Stock Total
MSTBStock in Transit
MSTEStock in Transit to Sales and Distribution Document
MSTQStock in Transit for Project

Production   

TableTable - nameS/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   

TableTable - nameS/4HANA -Table and general Notes
DBVMPlanning File Entry, MRP Area
DVERMaterial Consumption for MRP Area
MAPR Material Index for Forecast
MDMAMRP Area for Material

Status   

TableTable - nameS/4HANA -Table and general Notes
MOFFOutstanding Material Master Records
MSTAMaterial Master Status

Historical data   

TableTable - nameS/4HANA -Table and general Notes
MARCHMaterial Master C Segment: History
MARDHMaterial Master Storage Location Segment: History
MBEWHMaterial Valuation: History
MCHBHBatch Stocks: History
MKOLHSpecial Stocks from Vendor: History
MSCAHSales Order Stock at Vendor: History
MSKAHSales Order Stock: History
MSKUHSpecial Stocks at Customer: History
MSLBHSpecial Stocks at Vendor: History
MSPRHProject Stock: History
MSSAHTotal Sales Order Stocks: History
MSSQHTotal Project Stocks: History
MSTBHStock in Transit - History
MSTEHSiT to Sales and Distribution Document - History
MSTQHStock in Transit for Project - History

Material Ledger   Mandatory in S/4

TableTable - nameS/4HANA -Table and general Notes
CKMLCRMaterial Ledger: Period Totals Records Values
CKMLKEPHMaterial Ledger: Cost Component Split (Elements)
CKMLPPMaterial Ledger Period Totals Records Quantity
CKMLPPWIPMaterial-Ledger: Period Records WIP (Quantities)
MLCDMaterial Ledger: Summarization Record (from Documents)
MLCRMaterial Ledger Document: Currencies and Values
MLCRFMaterial Ledger Document: Field Groups (Currencies)
MLHDMaterial Ledger Document: Header
MLITMaterial Ledger Document: Items
MLPPMaterial Ledger Document: Posting Periods and Quantities
MLPPFMaterial Ledger Document: Field Groups (Posting Periods)

Material documents   

TableTable - nameS/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   

TableTable - nameS/4HANA -Table and general Notes
MATDOCMaterial Documents
MLDOCMaterial Ledger Document
MLDOCCCSMaterial Ledger Document Cost Component Split

Inventory   

TableTable - nameS/4HANA -Table and general Notes
IKPFHeader: Physical Inventory Document In Logical Database IMM INM IRM.
ISEGPhysical Inventory Document Items In Logical Database IMM INM IRM.

Reservation   

TableTable - nameS/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'.

TableTable - nameS/4HANA -Table and general Notes
T001KValuation area
T001LStorage Locations
T001W Plants/Branches
T024Purchasing Groups
T024EPurchasing Organizations
T024WValid Purchasing Organizations for Plant
T024ZPurchasing Organizations
T499SLocation
TSPAOrganizational 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'.

TableTable - nameS/4HANA -Table and general Notes
MDLGCustomizing: MRP Area Storage Location
MDLLCustomizing: MRP Area Subcontractor
MDLVCustomizing MRP Area
MDLWCustomizing: 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.
T023Material Groups
T025Valuation Classes
T025T Valuation Class Descriptions
T030 Standard Accounts Table FI-Accounting determination in MM. Edit with transaction OBYC or OMWB.
T030HAcct Determ.for Open Item Exch.Rate Differences
T137Industries for materials
T156Movement Type
T156MPosting String: Quantity
T156SYMvt Type: Qty/Value Update: System Table; Rel. 4.6A
T156TMovement Type Text In Logical Database MMIMRKPFRESB.
T156WPosting string values
T157HHelp 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   

TransactionTransaction - NameNotes
MM01Create MaterialExtend material number length up to 40 digits via customizing transaction OMSL
MM04Display Material Change Documents
MM11Schedule Creation of Material
MM12Schedule Changing of Material
MM17Mass Maintenance: Indus. Matl Master
MM41Create Material
MMAMChange Material Type
MMCCCopy Material

Customizing - Transactions   

TransactionTransaction - NameNotes
MMNRDefine Material Master Number Ranges
OBA7C FI maintain table T003Document Types for Finance
OMS2Maintain Material Types
OMSLC MM-BD Maintain TMCNVExtend material number length up to 40 digits