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