on 08-01-2008 12:09 PM
Plz give me MM tables,If u have any excel file Plz send it to my mailing address
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.