SAP MM Tables

[Former Member]

Pls send me some MM related tables...........

[Former Member]

Hi,

Materials

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

Vendors

LFA1 - Vendor Master: General data

LFB1 - Vendor Master: Company data

LFM1 - Vendor Master: Purchasing Data (Purchasing organization)

LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)

Purchasing

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

ISEG - Physical inventory document items

MKPF - Material document: Header

MSEG - Material document: item

RKPF - Reservation: Header

RESB - Reservation: Item

Invoice Verification

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

Customising and other master data

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

[Former Member]

Materials

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

Vendors

LFA1 - Vendor Master: General data

LFB1 - Vendor Master: Company data

LFM1 - Vendor Master: Purchasing Data (Purchasing organization)

LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)

Purchasing

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

ISEG - Physical inventory document items

MKPF - Material document: Header

MSEG - Material document: item

RKPF - Reservation: Header

RESB - Reservation: Item

Invoice Verification

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

Customising and other master data

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

[Former Member]

Following are the list of Important MM tables. Please check if its useful.

Inventory Management:

|-------------------------+--------+-----------------------------------------|
|                         | Table  | Description                             |
|-------------------------+--------+-----------------------------------------|
| Material                | MSEG   | Material document / transaction details |
| Document/Movements      | MKPF   | Material document header information    |
|-------------------------+--------+-----------------------------------------|
| Material Stock Balances | MARD   | Material stock                          |
|                         | MBEW   | Material stock with valuation           |
|-------------------------+--------+-----------------------------------------|
| Sales Order Stock       | MSKA   | Stock balance with associated sales     |
|                         |        | order data                              |
|-------------------------+--------+-----------------------------------------|
| Stock Transport         | EKUB   | Index for Stock Transport Orders for    |
|                         | MDUB   | Material                                |
|                         |        | Reading View of Stock Transport Ord. for|
|                         |        | Release Ord.                            |
|-------------------------+--------+-----------------------------------------|
| Special Stocks          | MKOL   | Consignment, material provided to       |
|                         |        | vendor, etc.                            |
|-------------------------+--------+-----------------------------------------|

Material Master Data:

|-------------------------+---------+--------------------------------------|
|                         |Table    | Description                          |
|-------------------------+---------+--------------------------------------|
| Materials               | MARA    | General Data, material type, group,  |
|                         |         | configurable & batch ind.            |
|                         | MAKT    | Short Texts, descriptions            |
|                         | MARM    | Conversion Factors                   |
|                         | MVKE    | Sales Org, distribution channel      |
|                         | MLAN    | Sales data, tax indicator, tax       |
|                         | MARC    | classification                       |
|                         | MBEW    | Plant Planning Data                  |
|                         | MLGN    | Valuation Data                       |
|                         | MLGT    | Warehouse Management Inventory Data  |
|                         | MVER    | Warehouse Management Storage Type    |
|                         | MAPR    | Data                                 |
|                         | MARD    | Consumption Data                     |
|                         | MCHA    | Pointer for Forecast Data            |
|                         | MCHB    | Storage location data with stock     |
|                         |         | balances                             |
|                         |         | Batches                              |
|                         |         | Batch Stocks                         |
|-------------------------+---------+--------------------------------------|

Common Tables used by SAP MM

Below are few important Common Tables used in Materials Management Modules:

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

Hope this helps.

Thanks,

Balaji

[Former Member]

Chk these links.

Materials Management Table links

http://www.erpgenie.com/abap/tables_mm.htm

Common Tables used by SAP MM

http://www.sap-img.com/materials/common-tables-used-by-sap-mm.htm

[Former Member]

Hi,

Materials Management Tables

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

Purchasing Tables

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

also follow this link

http://www.erpgenie.com/sap/abap/tables_mm.htm

Regards,

vineela

[Former Member]

Hi

see this link it will show list of table related to MM

and their relationships

http://www.erpgenie.com/abap/tables_mm.htm