6 Replies Latest reply: Mar 12, 2008 9:59 AM by Guest RSS

SAP MM Tables

AYYAPPA S
Currently Being Moderated

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

  • Re: SAP MM Tables
    Currently Being Moderated

    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

  • Re: SAP MM Tables
    gopi sangani
    Currently Being Moderated

    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

  • Re: SAP MM Tables
    Balaji Ganapathiraman
    Currently Being Moderated

    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

  • Re: SAP MM Tables
    Mahalakshmi Padmanaban
    Currently Being Moderated

    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

  • Re: SAP MM Tables
    Radha Vineela Aepuru
    Currently Being Moderated

    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

  • Re: SAP MM Tables
    Currently Being Moderated

    Hi

     

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

     

    and their relationships

     

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

Actions