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

Business scenarios where allowing negative stock in SAP

  Here are the primary business scenarios where allowing negative stock can be justified: Backflushing in Production (Especially in...