GitHub

SAP MM Module

DOCS related to Materials Management in SAP

Commands:

SAP MM ...

PurchaseContract

CentralPurchasing

Material typesDescription
ROHRaw materials
KMATConfigurable Materials
HALBSemi finished materials
LIEHReturnable Packaging
HIBEOperating Supplies
HAWATrading goods
FERTFinished products
ERSASpare Parts
VERPPacking Material
NLAGNon stock items
PIPEPipe line
DIENServices
UNBWNon valuated items
-----------------------------

Note: Configuration - Material Valuation by Material Type (MAP vs Standard)

Sr.No.Material TypeBasic DataSalesMRPPurchaseStoreAccountingForecasteCosting
1ROHX-XXXXX-
2KMATXXXXXXX-
3HALBXXXXXXX-
4LIEHX--XXX-X
5HIBEX-XXXXX-
6NLAGX-XXXXX-
7HAWAXXX-XXX-
8FERTX-XXXXX-
9ERSAX--X-X--
10VERPX--XX---
11PIPEX--XX---
12DIENX--XX---
13UNBWX--XX---
----------------------------------
Sr. NoMaterial GroupCode (SAP)
121MT21
222MT22
323MT23
424MT24
525MT25
626MT26
727MT27
828MT28
929MT29
1030MT30
1131MT31
1232MT32
1333MT33
1434MT34
1535MT35
1636MT36
1737MT37
1838MT38
1939MT39
2040MT40
2141MT41
------------------------------------
TableNameS/4HANA - Notes
MAEXMaterial Master: Legal Control
MAKTMaterial DescriptionsField ‘Mat. desc MAKTG’ for search. Logical Database MMIMRKPFRESB S1L S2L.
MAKVMaterial Cost Distribution
MAKZMaterial cost distribution equivalence numbers
MAPEMaterial Master: Export Control File
MAPLAssignment of Task Lists to MaterialsIn Logical Database PNM PNM_OLD.
MARAGeneral Material DataIn Logical Database /SAPSLL/CUSMSM BAM BKM BMM CKM EBM ECM ENM ESM IFM S1L WTY.
MARCPlant Data for MaterialS/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM S1L.
MARDStorage Location Data for MaterialS/4: Master data without stock aggregates. In Logical Database /SAPSLL/CUSMSM MSM.
MARMUnits of Measure for MaterialIn Logical Database MSM.
MARVMaterial Control RecordCurrent MM-Period.
MASTMaterial to BOM LinkIn Logical Database CKA CSR.
MBEWMaterial ValuationIn Logical Database /SAPSLL/CUSMSM BMM CKA.
MDFDMRP firming date
MDIPMaterial: MRP Profiles (Field Contents)
MKALProduction Versions of Material
MLANTax Classification for Material
MLGNMaterial Data for Each Warehouse NumberIn Logical Database MSM S1L.
MLGTMaterial Data for Each Storage TypeIn Logical Database MSM.
MPGD_MASSPlanning Data
MPOPForecast Parameters
MSPRProject Stock
MSSATotal Customer Orders on Hand
MSSLTotal Special Stocks with Vendor
MVERMaterial Consumption
MVKESales Data for MaterialIn Logical Database MSM.
PROPForecast parameters
QMATInspection type - material parametersInspection type.
STXHSTXD SAPscript text file headerIn Logical Database AAV AKV ALV ARV BBM ERM ILM.
STXLSTXD SAPscript text file linesIn Logical Database AAV AKV ALV ARV BBM ERM ILM.
T179Materials: Product Hierarchies
Production    
CHVWTable CHVW for Batch Where-Used List
MCH1Batches (if Batch Management Cross-Plant)
MCHABatches
MCHBBatch StocksIn Logical Database /SAPSLL/CUSMSM MSM.
Dispatch data    
DBVMPlanning File Entry, MRP Area
DVERMaterial Consumption for MRP Area
MAPRMaterial Index for Forecast
MDMAMRP Area for Material
Status    
MOFFOutstanding Material Master Records
MSTAMaterial Master Status
Historical data    
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
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    
MKPFHeader: Material DocumentIn Logical Database BMM LMM LNM MRM PGQ.
MSEGDocument Segment: MaterialIn Logical Database BMM L1M LMM LNM MRM PGQ.
Material documents in S/4    
MATDOCMaterial Documents
MLDOCMaterial Ledger Document
MLDOCCCSMaterial Ledger Document Cost Component Split
Reservation    
RESBReservation/dependent requirementsIn Logical Database BBM ERM MEPOLDB MMIMRKPFRESB ODC OFC OHC OPC POH RMM RNM.
RKPFDocument Header: ReservationIn Logical Database MMIMRKPFRESB RKM RNM.
Enterprise Structure    Part of the Customizing
T001KValuation area
T001LStorage Locations
T001WPlants/Branches
T024Purchasing Groups
T024EPurchasing Organizations
T024WValid Purchasing Organizations for Plant
T024ZPurchasing Organizations
T499SLocation
TSPAOrganizational Unit: Sales Divisions
Customizing    
MDLGCustomizing: MRP Area Storage Location
MDLLCustomizing: MRP Area Subcontractor
MDLVCustomizing MRP Area
MDLWCustomizing: MRP Area Plants
NRIVNumber Range IntervalsEdit with transaction SNUM. Object=MATERIALNR for materials
T025TValuation Class Descriptions
T030Standard Accounts TableFI-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 TextIn Logical Database MMIMRKPFRESB.
T156WPosting string values
T157HHelp Texts for Movement Types
------------------------------
  • Allocation Results
  • Cost Center (Plan/Actual)
  • Functional Area
  • Internal Orders
  • Projects
  • Statistical Key Figures
ECCS/4 HANAU/XDatabase
SAP ERPSAP S/4 HANASAP FIORISAP HANA
----------------------------------------------------------

Note: S/4 (cloud & on-premise) works only on Hana DB while SAP ERP is compatible with Hana DB, MS Sql, Oracle DB, IBM DB2 etc.