Important tables related to Material Management in SAP

List of the tables used in MM(Material Management) in SAP, useful t-codes for ABAP consultants related to MM

+ -

The below are the list of tables related to Material Management(MM) in SAP, which we mostly use

Materials

DBVM - MRP Planning File Entry: MRP Area
DVER - Material Master: Consumption (MRP Area)
EBEW - Valuation of sales order stock
MAKT - Material Master: Description
MAPE - Material master: Export control file
MAPR - Material Master: Forecast
MARA - Material Master: General data
MARC - Material master: Plant data
MARD - Material master: Storage location
MARM - Material Master: Unit of Measure
MAST - Material link to BOM
MBEW - Material valuation
MCH1 - Material Master: X Plant Batches
MCHA - Material Master: Batches
MCHB - Material Master: Batch Stock
MDIP - Material: MRP profiles (field contents)
MDMA - MRP Area data
MKOP - Consignment price segment (old versions of SAP)
MLAN - Material Master: Tax indicator
MLGN - Material Master: WM Inventory
MLGT - Material Master: WM Inventory type
MOFF - Outstanding Material Master Records (Maintenance status)
MVER - Material Master: Consumption (Plant)
MVKE - Material Master: Sales (Sales Org, Distr Ch)
QBEW - Valuation of project stock

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)
WYT3 - Vendor Partner Functions

External Service Management

ASMD - Service Master: Basic Data
ASMDT - Service Short Texts
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 - MM-SRV: Unplanned limits for contract item
ESUH - MM-SRV: unplanned service limits header data
ESUP - MM-SRV: unplanned limits for service packages
ESUS - MM-SRV: Unplanned limits for service types

Purchasing

EBAN - Purchase requisition: items
EBKN - Purchase Requisition: account assignment
EINA - Purchase Info Record: General
EINE - Purchasing info record: purchasing organization data
EIPA - Order price history record
EKAB - Release documentation
EKBE - Purchasing document history
EKBZ - Purchasing document history: delivery costs
EKET - Purchasing Document: Delivery Schedules
EKKN - Account assignment in purchasing document
EKKO - Purchasing document header
EKPO - Purchasing Document: Item
EKPB - Material to be provided item in purchasing document
EORD - Purchasing Source List
KONH - Condition Header
KONP - Condition Item

MDBS - Material View of Order Item/Schedule LineSTXH - SAPScript Text Header
STXL - SAPScript Text Lines

Inventory Management

ISEG - Physical inventory document items
MKPF - Material document: Header
MSEG - Material document: item
RESB - Reservation: Item
RKPF - Reservation: Header

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 monthlyRBCO - 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)
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

Customizing

AGR_USERS - Assignment of roles to users
AUSP - Release Procedure: Strategy values (cl20n, cl24n)
CDHDR and CDPOS - Change history of master data and documents
EDID4 - EDI information
MDLG - MRP Areas - Storage Locations
MDLL - MRP Areas - Subcontractor
MDLV - MRP Areas
MDLW - MRP Areas - Plants
NAST - Message status
T023 - Material Groups
T024 - Purchasing groups
T030 - Standard Accounts Table (Automatic Account Determination)
T156 - Movement Type
T156T - Movement Type: Text
T16FC - Release Codes
T16FD - Description of Release Codes
T16FK - Release Statuses
T16FS - Release Strategies
T16FT - Descriptions of Release Strategies
T16FV - Release Prerequisites
TSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93

TSTCT - Transaction codes TEXT

Learner Questions


No Questions by learners, be first one to ask ..!!

    Please Sign in to ask a question

    Was this lesson helpful to you? Yes No 12 People out of 13 think this lesson helpful


    Lesson Navigation

    ←Previous Chapter
    Next Lesson → SD Basics for ABAP Consultants