SAP MM Important Tables
List of all Important Tables used in Material Management
Materials Related Tables:
MARA |
Material Master:General data |
MAKT |
Material Master:Description |
MARM |
Material Master: Unit of Measure |
MAPE |
Material master: Export control file |
MARC |
Material master: Plant data |
MARD |
Material master: Storage location |
MAST |
Material link to BOM |
MBEW |
Material valuation |
MLGN |
Material Master: WM Inventory |
MLGT |
Material Master: WM Inventory type |
MDIP |
Material: MRP profiles (field contents) |
MKOP |
Consignment price segment (old versions
of SAP) |
EBEW |
Valuation of sales order stock |
QBEW |
Valuation of project stock |
MVER |
Material Master: Consumption
<Plant> |
DVER |
Material Master: Consumption <MRP
Area> |
MVKE |
Material Master: Sales <Sales Org,
Distr Ch> |
MLAN |
Material Master: Tax indicator |
MARC |
Material Master: Plant data |
MAPR |
Material Master: Forecast |
MARD |
Material Master: Storage Location |
MCH1 |
Material Master: X Plant Batches |
MCHA |
Material Master: Batches |
MCHB |
Material Master: Batch Stock |
MDMA |
MRP Area data |
DBVM |
MRP Planning File Entry: MRP Area |
MOFF |
Outstanding Material Master Records
(Maintenance status) |
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 |
LFA1 |
Vendor Master: General data |
LFB1 |
Vendor Master: Company data |
LFM1 |
Vendor Master: Purchasing Data (Purchasing organization) |
LFM2 |
Vendor Master: Purchasing Data (Plant, Vendor subrange) |
EBAN |
Purchase requisition: items |
EBKN |
Purchase Requisition: account assignment |
STXH |
SAPScript Text Header |
STXL |
SAPScript Text Lines |
EKKO |
Purchasing document header |
EKPO |
Purchasing Document: Item |
EKET |
Purchasing Document: Delivery Schedules |
MDBS |
Material View of Order Item/Schedule Line (good to find open PO’s) |
EKKN |
Account assignment in purchasing document |
EORD |
Purchasing Source List |
EIPA |
Order price history record |
EKAB |
Release documentation |
EKBE |
Purchasing document history |
EKBZ |
Purchasing document history: delivery costs |
EKPB |
“Material to be provided” item in purchasing document |
ESKL |
Account assignment specification for service line |
ESKN |
Account assignment in service package |
ESLH |
Service package header data |
ESLL |
Lines in service package |
ESSR |
Service entry sheet header data |
ESUC |
External services management: Unplanned limits for contract item |
ESUH |
External services management: unplanned service limits header data |
ESUP |
External services management: unplanned limits for service packages |
ESUS |
External services management: Unplanned limits for service types |
EINA |
Purchase Info Record: General |
EINE |
Purchasing info record: purchasing organization data |
KONP |
Condition Item |
KONH |
Condition Header |
Inventory Management Tables:
ISEG |
Physical inventory document items |
MKPF |
Material document: Header |
MSEG |
Material document: item |
RKPF |
Reservation: Header |
RESB |
Reservation: Item |
Invoice
Verification Tables:
BSIM |
Secondary index: documents for material |
MYMFT |
FIFO results table |
MYML |
LIFO material layer |
MYMLM |
LIFO material layer (monthly) |
MYMP |
LIFO period stocks, single material |
MYMP1 |
Receipt data LIFO/FIFO valuation |
MYPL |
LIFO pool layer |
MYPLM |
LIFO pool layer (monthly) |
RBCO |
Document item, incoming invoice account assignment |
RBDIFFKO |
Invoice Verification: conditions |
RBDIFFME |
Invoice Verification: quantity differences |
RBDRSEG |
Invoice Verification batch: invoice document items |
RBKP |
Document header: incoming invoice |
RBKPB |
Invoice document header (batch invoice verification) |
RBTX |
Taxes:incoming invoice |
RBVD |
Invoice document: summarization data |
RBVDMAT |
Invoice Verification: summarization data, material |
RBWT |
Withholding tax:incoming invoice |
RKWA |
Consignment withdrawals |
RSEG |
Document item, incoming invoice |
Customizing and Other Master Data Tables:
MDLV |
MRP Areas |
MDLG |
MRP Areas Storage Locations |
MDLW |
MRP Areas Plants |
MDLL |
MRP Areas Subcontractor |
T023 |
Material Groups |
T024 |
Purchasing groups |
T030 |
Standard Accounts Table (Automatic Account Determination) |
T156 |
Movement Type |
T156T |
Movement Type: Text |
AUSP |
Release Procedure:Strategy values (cl20n, cl24n) |
AGR_USERS |
Assignment of roles to users |
CDHDR & CDPOS |
Change history of master data and documents |
EDID4 |
EDI information |
TSTC |
SAP Transaction Codes,lock/unlock: sm01, created: se93 |
TSTCT |
Transaction codes TEXT |
NAST |
Message status |