SAP 常用表及表关系

SAP MM常用表及表关系

一、MM常用表

1、MARA: 常规物料数据 2、MARC: 物料的工厂数据 3、MAKT: 物料描述

4、MARD: 物料的工厂/库存地点数据

5、MBEW: 物料评估（财务数据），其中MBEW-WERKS指工厂 6、MVKE: 物料销售数据

7、MLGN: 每一个仓库号物料数据（仓库）

8、MLGT: 每一个存储类型的物料数据（仓库/存储类型）

8.1、MSTA：物料主记录状态

9、LFA1: 供应商主数据（一般数据） 10、LFB1: 供应商主数据（公司代码） 11、LFM1: 供应商采购组织数据

12、EINA: 采购信息记录（一般数据） 13、EINE: 采购信息记录（采购组织数据） 14、EKKO: 采购订单抬头 15、EKPO: 采购订单行项目 16、EKET: 计划协议计划行

17、EKKN: 采购凭证中的帐户设置 18、EKBE: 采购凭证历史 19、MKPF: 物料凭证抬头 20、MSEG: 物料凭证行项目

21、RBKP: 凭证抬头供应商发票数据 22、RSEG: 凭证项目供应商发票数据

EKKO/EKPO–>MKPF/MSEG–>RBKP/RSEG–>BKPF-BSEG 23、KNA1: 客户主数据（一般数据） 24、KNB1: 客户主数据（公司代码） 25、KNVV: 客户主记录销售数据 26、ADRC: 地址 27、EBAN: 采购申请

Materials

MARA - Material Master: General data MAKT - Material Master: Description

MARM - Material Master: Unit of Measure MAPE - Material master: Export control file MARC - Material master: Plant data

MARD - Material master: Storage location MAST - Material link to BOM MBEW - Material valuation

MLGN – Material Master: WM Inventory

MLGT – Material Master: WM Inventory type MDIP - Material: MRP profiles (field contents)

MKOP - Consignment price segment (old versions of SAP) EBEW - Valuation of sales order stock QBEW - Valuation of project stock

MVER – Material Master: Consumption DVER – Material Master: Consumption

MVKE – Material Master: Sales MLAN - Material Master: Tax indicator MARC - Material Master: Plant data MAPR – Material Master: Forecast

MARD – Material Master: Storage Location MCH1 – Material Master: X Plant Batches MCHA – Material Master: Batches MCHB – Material Master: Batch Stock MDMA - MRP Area data

DBVM - MRP Planning File Entry: MRP Area

MOFF - Outstanding Material Master Records (Maintenance status)

MARCH - Material Master C Segment: History

MARDH - Material Master Storage Location Segment: History MBEWH - Material Valuation: History MCHBH - Batch Stocks: History

MKOLH - Special Stocks from Vendor: History MSCAH - Sales Order Stock at Vendor: History MSKAH - Sales Order Stock: History

MSKUH - Special Stocks at Customer: History MSLBH - Special Stocks at Vendor: History MSPRH - Project Stock: History

MSSAH - Total Sales Order Stocks: History MSSQH - Total Project Stocks: History

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)

Purchasing

EBAN - Purchase requisition: items

EBKN - Purchase Requisition: account assignment STXH - SAPScript Text Header

STXL - SAPScript Text Lines

EKKO - Purchasing document header EKPO - Purchasing Document: Item

EKET - Purchasing Document: Delivery Schedules

MDBS - Material View of Order Item/Schedule Line (good to find open PO's) EKKN - Account assignment in purchasing document EORD - Purchasing Source List EIPA - Order price history record EKAB - Release documentation

EKBE - Purchasing document history

EKBZ - Purchasing document history: delivery costs

EKPB - \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 - External services management: Unplanned limits for contract item ESUH - External services management: unplanned service limits header data ESUP - External services management: unplanned limits for service packages

ESUS - External services management: Unplanned limits for service types

EINA - Purchase Info Record: General

EINE - Purchasing info record: purchasing organization data KONP - Condition Item KONH - Condition Header

Inventory Management

ISEG - Physical inventory document items

MKPF - Material document: Header MSEG - Material document: item

RKPF - Reservation: Header RESB - Reservation: Item

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 (monthly)

RBCO - 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 invoice verification) 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

Customising and other master data

MDLV - MRP Areas

MDLG - MRP Areas - Storage Locations MDLW - MRP Areas - Plants

MDLL - MRP Areas - Subcontractor T023 - Material Groups T024 - Purchasing groups

T030 - Standard Accounts Table (Automatic Account Determination) T156 - Movement Type

T156T - Movement Type: Text

AUSP - Release Procedure: Strategy values (cl20n, cl24n) AGR_USERS - Assignment of roles to users

CDHDR & CDPOS - Change history of master data and documents EDID4 - EDI information

TSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93 TSTCT - Transaction codes TEXT

NAST - Message status