Thursday, June 21, 2012

Common Tables used by SAP MM

Tables for Material Master

MARA:   Table contains general data about materials like material type, group etc. 
MAKT:  Table contains description about materials. 
MARC: Plant Data for Material
MARD: Storage Location Data for Material
MARM: Materials unit of measure data for conversion and all.
MAPE: material export control files 
MAPR: material forecast data
MCHA: Material batch master record table
MCHB: Material batch stock data.
MLAN: Material Tax indicator
MBEW: Material valuation
MLGN: WM Inventory
MLGT: WM inventory type
MVER: material consumption data
MVKE: Material sales data
MAST:  Material to BOM Link
MSEG:  Document Segment- Material

Tables for Vendor master data

LFA1: vendor general data
LFB1: vendor company data
LFM1: Vendor purchasing data

Inventory Management tables

MKPF: Material document header data
MSEG: Material document segment (item)
RESB: Item reservation
RKPF: Reservation header data

Purchasing tables

EBAN:  Purchase Requisition
EBKN: Purchase Requisition Account Assignment
EINA: Purchasing Info Record- General Data
EINE: Purchasing Info Record- Purchasing Organization Data
EIPA: History of order price
EKAB: Release documentation
EKBE: Purchasing document history
EKET: Purchasing delivery schedules
EKKO: Purchasing document header
EKPO: purchasing item data document
EORD: Purchasing source list

Other tables

·         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
·         IKPF     : Header- Physical Inventory Document
·         ISE        : Physical Inventory Document Items
·         NRIV     : Number range intervals
·         RESB    : Reservation/dependent requirements
·         T161T  : Texts for Purchasing Document Types

1 comment:

YekTek Online Training said...

Valuable information thanks for sharing Shruthi

Pros and Cons of API vs IDOC in SAP