MM常用后台表(二)

Table Description Table Description
物料主数据 MARA 常规物料数据 PR EBAN 采购申请
MARC 物料的工厂数据 EBKN 采购申请帐户设置
MARD 物料的仓储位置数据 PO EKBE 采购凭证历史
MARM 物料的计量单位 EKBEH 删除的PO历史记录
MARV 物料控制记录 EKBZ 每个采购凭证的历史:交货费用
MBEW 物料评估 EKBZH 每个采购凭证的历史:交货费用
MAKT 物料说明 EKKI 采购条件索引
MAST BOM连接物料 EKKN 采购凭证中的帐户设置
MVKE 物料销售数据 EKKO 采购凭证抬头
MAPR 有关预测的物料索引 EKPA 采购中的合伙人规则
MSTA 物料主记录状态 EKPB 采购凭证中的已供物料项
供应商主数据 LFA1 供应商主数据(一般地区) EKPO 采购凭证项目
LFAS 供应商主数据(增值税登记号的一般部分) EKPV 采购凭证项目的库存转储装运数据
LFAT 供应商主数据(税务分组) EKRS ERS过程:将被开票的货物(商品)移动
LFB1 供应商主数据(公司代码) MIGO MKPF 抬头:物料凭证
LFB5 供应商主数据(催款数据) MSEG 凭证段:物料
LFBK 供应商主数据(银行细目) MIRO RBKP 凭证表头:发票收据
LFBW 供应商主记录(预扣税类型)X RSEG 凭证项目:收款发票
LFC1 供应商主数据(业务额) 配额 EQUK 配额文件:标题
LFC3 主供应商(特殊总分类帐交易图表) EQUP 配额文件:项目
LFCPR 每一步骤的功能代码参数文件 装运 T027A 装运须知,采购
LFM1 供应商主记录购买组织数据 T027B 文本:装运须知
LFM2 供应商主文件记录:采购数据 T027C 与装运须知相符的码
信息记录 EINA 采购信息记录 - 一般数据 T027D 与装运须知相符的码
EINE 采购信息记录 - 采购组织数据 盘点 IKPF 抬头:实地盘存凭证
EIPA 订购价格历史:信息记录 ISEG 盘点库存凭证项目
货源清单 EORD 采购货源清单 批次 MCHA 批次
EKUB 有关物料的库存运输单的索引 MCHB 批量库存
ESKN 服务包中的帐户分配 EKAB 批准凭证
MBPR 生产仓位库存 EKAN 供应商地址:采购凭证
MLAN 物料的税分类 计划协议 EKEH 计划协议批准凭证
MLGN 每一仓库号物料数据 EKEK 计划协议批准的标题数据
MLGT 每一存储类型的物料数据 EKES 供应商确认
MVER 物料消耗量 EKET 计划协议计划行
MVKE 物料销售数据 EKETH 计划协议计划:历史表
T001L 仓储地点 转储 LTBK 转储请求抬头
T001W 工厂/分支机构 LTBP 转储请求项目
NRIV 号码范围间隔 LTAK WM转储单抬头
RKPF 凭证头:预定 LTAP 转储单项目
RESB 预定/相关需求 库存 MARD 查主库存
T024 采购组 MARDH 主库存历史记录
T024E 采购组织 MSLB 特殊库存 O
T024W 工厂的有效采购组织 MKOL 批次库存 K/M
T024Z 采购组织 MSKA 批次库存 E
T023 物料组 MSKU 批次库存 V/M
T156 移动类型 MCHA 批次库存
T157H 移动类型的帮助文本 MCHB 批次库存
KONP 条件(项目)
T16FC 批准代码
客户主数据 KNA1 基本数据 物料主数据 MARA 基本数据
KNVV 销售试图 MAKT 文本
KNB1 公司代码 MARC 工厂视图
KNVP 合作伙伴 MVKB 销售视图
信用主数据 KNKK 信贷限额、应收总额、特别往来 MARM 物料的计量单位
S066 未清订单值
S067 未清5交货值
KNKK 应收值(要与BSID表比较) 自动确定的科目 CXXX XXX表示三个数字
价格数据 AXXX 主数据表XXX表示三个数字
KNOH 抬头 交货 LIKP 抬头
KNOP 行项 LIPS 行项
KNOV 单据的价格 VTTK 装运抬头
VTTP 装运行项
销售订单 VBKA 抬头 物料凭证 MKPF 抬头
VBAP 行项 MSEG 行项
VBKD 业务数据
VBPA 合作伙伴 发票 VBRK 抬头
VBEP 计划行数据 VBRP 行项
VBFA 单据流
VBUK 抬头状态
VBUP 行项状态
文本 STXH 抬头
最新的单据中的地址信息在ADRC里,不能取主数据的 STXL 行项
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 
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 <Plant>
DVER - Material Master: Consumption <MRP Area>
MVKE - Material Master: Sales <Sales Org, Distr Ch>
MLAN - Material Master: Tax indicator
MAPR - Material Master: Forecast
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)

The history tables below are related to ECC / ERP only – not S4/HANA.
For S/4HANA these are CDS Database views, not actual tables.
The CDS views are on MATDOC and MATDOC_EXTRACT .

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

BOM

STKO - BOM Header Details
STPO - BOM Item Details
MAST - Material to BOM Link

Business Partners

BUT000 - General info
BUT100 - BP Roles

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

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 - "Material to be provided" item in purchasing document 

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
RKPF - Reservation: Header
RESB - Reservation: Item

MATDOC - Material document in S4/HANA  
MATDOC_EXTRACT - Material document summary in S4/HANA 

MKPF - Material document: Header    (table in ECC, CDS View in S4/HANA)
MSEG - Material document: item      (table in ECC, CDS View in S4/HANA)

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

T001 - Company Codes
T001W - Plants/branches
T001L - Storage Locations
T024E - Purchasing Organizations
T024W - Valid Purchasing Organizations for Plant

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
T16FS - Release Strategies
T16FT - Descriptions of Release Strategies
T16FV - Release Prerequisites
T16FD - Description of Release Codes
T16FK - Release Statuses
T16FC - Release Codes
T161 - Purchasing Document Types

T052 - Terms of Payment & FM FI_TEXT_ZTERM for long 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