SAP MM Tables

MM / WM related tables and structures

Purpose

This page will discuss SAP tables and structures used in SAP Material management. This can be used as a ready reference for writing FS or for data analysis.

  • Transaction code: SE16N can be used to view data in Table
  • Transaction code: SE11 can be used to view Table structure

Purchasing Document

Table/Structure Description
EKPO Purchasing Document Item
EKKO Purchasing Document Header
EBAN Purchase Requisition
EKBE History per Purchasing Document
EKET Scheduling Agreement Schedule Lines
EINE Purchasing Info Record: Purchasing Organization Data
EKKN Account Assignment in Purchasing Document
EINA Purchasing Info Record: General Data
EKES Vendor Confirmations
EBKN Purchase Requisition Account Assignment
EORD Purchasing Source List
T024 Purchasing Groups
EKBZ History per Purchasing Document: Delivery Costs
AMPL Table of Approved Manufacturer Parts
EKAN  Vendor Address: Purchasing Document
EKPO Purchasing Document Item
 

Inventory management Document

Table/Structure Description
MSEG Document Segment: Material
MKPF Header: Material Document
RESB Reservation/dependent requirements
MARI Short document: material movement
ISEG Physical Inventory Document Items
RKPF Document Header: Reservation
T156  Movement Type
IKPF Header: Physical Inventory Document
T156T  Movement Type Text
CHVW Table CHVW for Batch Where-Used List
T156SY Mvt Type: Qty/Value Update: System Table; Rel. 4.6A
MMIM_REP_PRINT Print Settings, Reporting MM-IM
T156S  Movement Type: Quantities/Value Posting (Until Rel. 4.5B)
T156W Posting string values
T156M Posting String: Quantity
MSEG  Document Segment: Material
 

Outbound Delivery Document

Table/Structure Description
LIKP Delivery Document: Header data
LIPS Delivery Document: Item data

Shipping and Transportation documents

Table/Structure Description
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit – Header Table
VEPO Packing: Handling Unit Item – Contents

Vendor Invoice  Document

Table/Structure Description
RSEG Document Item: Incoming Invoice
RBKP Document Header: Invoice Receipt
BSIM Secondary Index, Documents for Material
RKWA Consignment Withdrawals
RBCO Document Item, Incoming Invoice, Account Assignment
RBKP_BLOCKED Logistics Invoice Verification: Blocked Invoices
RBKP_V Generierte Tabelle zu einem View
V_169P_MB Generierte Tabelle zu einem View
T149D Global Valuation Types
RBDRSEG Batch IV: Invoice Document Items

 Customer Master Data

Table/Structure Description
KNA1 Customer Master: General Data
KNB1 Customer Master: Company Code Data
KNB4 Customer Payment History
KNB5 Customer Master: Dunning data
KNBK Customer Master: Bank Details
KNBW Customer Master: Wwithholding tax types
KNKA Customer Master: Credit Mgmt.
KNKK Customer Master: Credit Control Area Data – credit limits
KNVA Customer Master: Loading/Unloading Points
KNVD Customer Master: Record sales request form/documents
KNVH Customer Hierarchies
KNVI Customer Master: Tax Indicator
KNVK Customer Master: Contact Partner
KNVL Customer Master: Licenses
KNVP Customer Master: Partner Functions
KNVS Customer Master: Shipping Data
KNVT Customer Master: Record Texts for Sales
KNVV Customer Master: Sales Data
KLPA Customer/Vendor Link

Vendor  Master  Data

Table/Structure Description
LFA1 Vendor Master (General Section)
LFB1 Vendor Master (Company Code)
LFAS Vendor master (VAT registration numbers general section)
LFB5 Vendor master (dunning data)
LFBK Vendor Master (Bank Details)
LFBW Vendor master record (withholding tax types) X
LFM1 Vendor master record purchasing organization data
LFM2 Vendor Master Record: Purchasing Data
LFM2 Vendor Subrange
WYT1T Vendor Sub Range Description
WYT3 Partner Functions

 Material Master Data

Table/Structure Description
MARA General Material Data
MVKE Sales Data for Material
MARC Plant Data for Material
MARD Storage Location Data for Material
MAKT Short texts
MARM Conversion factors
MVKE Sales data – for each sales organization and distribution channel
MLAN Sales data – for each country
MAEX Export licenses
MBEW Valuation data
MLGN Warehouse management inventory data
MLGT Warehouse management inventory type data
MVER Consumption data
MAPR Pointers for forecast data
MCHA Batches
MCH1 Cross-plant Batches
MCHB Batch stocks
KNMTK Header table – for increased performance
KNMT Data table

Bill of Material (BOM)

Table/Structure Description
MAST Material assignment to BOM
EQST Equipment assignment to BOM
KDST Sales order assignment to BOM
DOST Document assignment to BOM
STST Standard object assignment to BOM
TPST Functional location assignment to BOM
STKO BOM header data
STZU Time-independent STL data
STAS BOM item selection
STPO BOM item data
STPU BOM sub-item data

Purchase Pricing

Table/Structure Description
KOMK Pricing Communications: Header (Structure)
KOMP Pricing Communication: Item (Structure)
KONV Conditions: Transaction Data
KONP Conditions: Item
KONH Conditions: Header
KOND Contracts
VEDA Contract Data

Output

Table/Structure Description
NAST Output: Message Status

Text

Table/Structure Description
STXH Texts: Header
STXL Texts: Line

 Warehouse management Tables:

Table/Structure Description
LTBK Transfer requirement – header
LTBP Transfer requirement – item
LTAK Transfer order – header
LTAP Transfer order – item
LQUA  Quants
LINK Inventory document header
LINP Inventory document item