Showing posts with label MM Tables. Show all posts
Showing posts with label MM Tables. Show all posts

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
SAP MM Tips by : Bahadur
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 |

IMG Change Logs and can ACCT Tables be Deleted

Problem One :
Does anyone knows where I can track who has made any changes in the configuration?

Problem Two :
Also, recently I was asked if those data can be deleted from ACCT* tables. Also, he commented there was a high increase in usage for these ACCT* tables that are related to MM. We have set up 2 phases in my company but this sudden increase in usage only happens in phase 2. Does anybody know what do these tables contain? Are there some settings that were made by the consultant in the configurations?

For :
1. - go to spro- then select any configuration tcode then menu-utilities-change log (provided the Change Log Tables is turn on by your Basis team. Usually this is turn off. To turn it on, you can refer to IMG - Basis Components - System Administration - Tables Changes Recording).

2. Please refer to OSS Note: 48009 - Tables ACCTHD, ACCTIT, ACCTCR: Questions and answers for the complete detail of ACCT* tables, when you post goods movement and invoice receipt, the FI/CO interface is documented in the forms of document in the tables ACCT*.