2007 Jan 02 3:57 PM
Hi Friends
Can anybody tell me what are mostly tables are used in MM module with fields detail.
Rajnish Awasthi
2007 Jan 02 3:59 PM
Hi,
For MM tables
MARA - Material master
MARC - Material plant details
MARD - Material plant storage location details
MVKE - Material sales org details
MBEW - Material valuation
EKKO - PO HEADER
EKPO - PO LINE ITEM
EKBE - PO HISTORY
EINE - PURCHASING INFO RECORD
EBAN - Purchase requisition
EKET - PO schedule lines
EKES - PO confirmations..
Check this link also..
http://www.sapgenie.com/abap/tables_mm.htm
Thanks,
Naren
Hi Friends
Can anybody tell me what are mostly tables are used in MM module with fields detail.
Rajnish Awasthi
2007 Jan 02 3:59 PM
Hi,
For MM tables
MARA - Material master
MARC - Material plant details
MARD - Material plant storage location details
MVKE - Material sales org details
MBEW - Material valuation
EKKO - PO HEADER
EKPO - PO LINE ITEM
EKBE - PO HISTORY
EINE - PURCHASING INFO RECORD
EBAN - Purchase requisition
EKET - PO schedule lines
EKES - PO confirmations..
Check this link also..
http://www.sapgenie.com/abap/tables_mm.htm
Thanks,
Naren
2007 Jan 02 4:00 PM
Refer this link:
http://help.sap.com/saphelp_47x200/helpdata/en/96/df293581dc1f79e10000009b38f889/frameset.htm
Regards,
Ravi
2007 Jan 02 4:06 PM
hi ,
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
Regards,
GUDURI
2007 Jan 02 4:11 PM
MM - tables
EINA - Purchasing Info Record- General Data
EINE - Purchasing Info Record- Purchasing Organization Data
MARA - General Material Data
MAKT - Material Descriptions
MARC - Plant Data for Material
MARM Unit of measure
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 - Material Groups
T024 - Purchasing Groups
T156 - Movement Type
T157H - Help Texts for Movement Types
STKO BOM Header
STPO BOM Item
fields.
MATNR - material number
MAKTX - material description
2007 Jan 02 5:20 PM
Goto MG development class in SE80. Under Database tables, you would find list of related tables.
Thanks,
Santosh