cancel
Showing results for 
Search instead for 
Did you mean: 

MM Tables

Former Member
0 Kudos

Plz give me MM tables,If u have any excel file Plz send it to my mailing address

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi

Use the below link to get download of a PDF doc of SAP MM Tables doc... 18 pages.

http://www.sapcustomization.com/document/sap_tables.pdf

Regards

Ram

Former Member
0 Kudos

Hi,

The following is the list of important MM 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

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

Please find all tables in MM-PUR (Purchasing) :

EBAN - Purchase Requisition

EBKN - Purchase Requisition Account Assignment

EBUB - Index for Stock Transport Requisitions for Materi

EINA - Purchasing Info Record: General Data

EINE - Purchasing Info Record: Purchasing Organization D

EIPA - Order Price History: Info Record

EKAB - Release Documentation

EKAN - Vendor Address: Purchasing Document

EKBE - History per Purchasing Document

EKBEH - Removed PO History Records

EKBZ - History per Purchasing Document: Delivery Costs

EKBZH - History per Purchasing Document: Delivery Costs

EKEH - Scheduling Agreement Release Documentation

EKEK - Header Data for Scheduling Agreement Releases

EKES - Vendor Confirmations

EKET - Scheduling Agreement Schedule Lines

EKETH - Scheduling Agreement Schedules: History Tables

EKKI - Purchasing Condition Index

EKKN - Account Assignment in Purchasing Document

EKKO - Purchasing Document Header

EKPA - Partner Roles in Purchasing

EKPB - "Material Provided" Item in Purchasing Document

EKPO - Purchasing Document Item

EKPV - Shipping-Specific Data on Stock Tfr. for Purch. D

EKRS - ERS Procedure: Goods (Merchandise) Movements to b

EKUB - Index for Stock Transport Orders for Material

EORD - Purchasing Source List

EQUK - Quota File: Header

EQUP - Quota File: Item

T024 - Purchasing Groups

T024E - Purchasing Organizations

T024W - Valid Purchasing Organizations for Plant

T024Z - Purchasing Organizations

T027A - Shipping Instructions, Purchasing

T027B - Texts: Shipping Instructions

T027C - Codes for Compliance with Shipping Instructions

T027D - Compliance with Shipping Instructions: Texts

T069 - Certificate Categories

T069Q - Control Data for Source Determination and Checkin

T069T - Certificate Categories: Text Description

T160 - SAP Transaction Control, Purchasing

T160B - SAP Transaction Control, List Displays, Purchasin

T160C - SAP Transaction Control for List Displays in CALL

T160D - Function Authorizations: Purchase Order

T160E - Function Authorizations: Purchasing: Descriptions

T160I - Control of Intrastat Reports

T160J - Text Table for Intrastat Reports

T160L - Scope of Purchasing Lists

T160M - Message Control: Purchasing (System Messages)

T160O - Description of Scope of List

T160P - Entities Table Routines

T160Q - Scope of List: Buyer's Negotiation Sheet: Routine

T160R - Routines for Buyer's Negotiation Sheet

T160S - Selection Parameters for Purchasing Lists

T160T - Description of Selection Parameters

T160V - Default Values for Purchasing

T160W - Description for Default Values for Purchasing Ope

T160X - Scope of List: Buyer's Negotiation Sheet

T160Y - Scope of List: Buyer's Negotiation Sheet: Descrip

T161 - Purchasing Document Types

T161A - Linkage of Requisition Doc. Type to Purchasing Do

T161B - Default Business Transaction Type for Import

T161E - Release Codes

T161F - Release Point Assignment for Purchase Requisition

T161G - Release Prerequisite, Purchase Requisition

T161H - Fields for Release Procedure, Purchase Requisitio

T161I - Determination of Release Strategy

T161M - Fine-Tuned Control: Message Types

T161N - Message Determination Schemas: Assignment

T161P - Check of Document Type, Document Category, Item C

T161R - REORG Control, Purchasing

T161S - Release Indicator, Purchase Requisition

T161T - Texts for Purchasing Document Types

T161U - Texts for Release Indicator

T161V - Shipping-Specific Data for Stock Tfr. for Purch.

T161W - Order Types for Stock Transfer

T161Z - Additional Checks for Outline Agreements on Reorg

T162 - Field Selection, Purchasing Document

T162K - Field Selection, Account Assignment Fields, Purch

T162T - Description of Field Selection Reference Key

T162X - Description of Field Groups from T162/T162K

T162Y - Groups: Field Selection

T163 - Item Categories in Purchasing Document

T163A - Check Item Category/Account Assignment Category

T163B - Purchase Order History Categories

T163C - Texts for Purchase Order History Categories

T163D - Assignment Internal/External Confirmation Categor

T163E - Confirmation Categories

T163F - Confirmation Categories: Descriptions

T163G - Confirmation Control

T163I - Texts for Account Assignment Categories

T163K - Account Assignment Categories in Purchasing Docum

T163KS - Assignment of Tax Indicator to Account Assignment

T163L - Confirmation Control Keys

T163M - Confirmation Control Keys: Description

T163P - Release Creation Profile

T163S - Description for Release Creation Profile

T163X - "Zombie" T163X

T163Y - Texts for Item Categories

T165K - Copying Options: Header Texts

T165P - Copying Options: Item texts

T166A - Supplement Text in Purchasing Document Printouts

T166C - Print-Relevant Purchasing Document Changes

T166K - Header Texts in Purchasing Document Printouts

T166P - Item Texts in Purchasing Document Printouts

T166T - Change Texts in Purchasing Document Printouts

T166U - Headings in Purchasing Document Printout

T167 - Number Range Management for Purchasing Master Dat

T167T - Transaction Description

T168 - Screen Control, Purchasing

T168F - Function Codes, Purchasing

T168T - Screen Titles

T16FB - Release Indicators: Purchasing Document

T16FC - Release Codes

T16FD - Description of Release Codes

T16FE - Descriptions of Release Indicators: Purchasing Do

T16FG - Release Groups

T16FH - Descriptions of Release Groups

T16FK - Release Statuses

T16FS - Release Strategies

MG

bye

N

kunal_ingale
Active Contributor
0 Kudos

hi

Materials management tables are

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 u2013 Material Master: WM Inventory

MLGT u2013 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 u2013 Material Master: Consumption <Plant>

DVER u2013 Material Master: Consumption <MRP Area>

MVKE u2013 Material Master: Sales <Sales Org, Distr Ch>

MLAN - Material Master: Tax indicator

MARC - Material Master: Plant data

MAPR u2013 Material Master: Forecast

MARD u2013 Material Master: Storage Location

MCH1 u2013 Material Master: X Plant Batches

MCHA u2013 Material Master: Batches

MCHB u2013 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

regards

kunal

Edited by: kunal ingale on Aug 1, 2008 1:15 PM

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

Find the details of Tables

MM 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 u2013 Material Master: WM Inventory

MLGT u2013 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 u2013 Material Master: Consumption <Plant>

DVER u2013 Material Master: Consumption <MRP Area>

MVKE u2013 Material Master: Sales <Sales Org, Distr Ch>

MLAN - Material Master: Tax indicator

MARC - Material Master: Plant data

MAPR u2013 Material Master: Forecast

MARD u2013 Material Master: Storage Location

MCH1 u2013 Material Master: X Plant Batches

MCHA u2013 Material Master: Batches

MCHB u2013 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

KONV - Conditions (Transaction Data)

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

The lists of tables used for MMBE Report are:

EKBE History per Purchasing Document

EKPO Purchasing Document Item

KNA1 General Data in Customer Master

LFA1 Vendor Master (General Section)

LFM1 Vendor master record purchasing organization data

MAKT Material Descriptions

MARA General Material Data

MARAV Generated Table for View MARAV

MARC Plant Data for Material

MARCV Generated Table for View MARCV

MARD Storage Location Data for Material

MARM Units of Measure for Material

MCH1 Batches (if Batch Management Cross-Plant)

MCHA Batches

MCHB Batch Stocks

MDLV Customizing MRP Area

MDMA MRP Area for Material

MKOL Special Stocks from Vendor

MSCA Sales Orders on Hand with Vendor

MSKA Sales Order Stock

MSKU Special Stocks with Customer

MSLB Special Stocks with Vendor

MSPR Project Stock

MTCOM Material Master Communication

The list of tables used for MB5B are:

BKPF Accounting Document Header

BSIM Secondary Index, Documents for Material

EBEW Sales Order Stock Valuation

MAKT Material Descriptions

MARA General Material Data

MARD Storage Location Data for Material

MBEW Material Valuation

MCHA Batches

MCHB Batch Stocks

MKOL Special Stocks from Vendor

MKPF Header: Material Document

MSEG Document Segment: Material

MSKA Sales Order Stock

MSKU Special Stocks with Customer

MSLB Special Stocks with Vendor

MSPR Project Stock

QBEW Project Stock Valuation

Regards,

Biju K