SAP各模块常用TABLE
MM Tables, Page 1
MSCS MSLB MSTA MVER MVKE RSEG S039 S011 S012 T001L T001W TRANSP TRANSP TRANSP MG MG MG Master Master Master
Customer stock with vendor - Total Special Stocks with Vendor Material Master Status Material consumption Material Master: Sales Data Document Item: Incoming Invoice Statistics: Inventory Controlling/ 统计: 存货控制 PURCHIS: 采购组统计 采购 MSM Sales Data (for each Sales Org and Distribution Channel) WRBRT
Description Purchase Requisition Purchase Requisition Account Assignment Index for Stock Transport Requisitions for Material Purchasing Info Record - General Data Purchasing Info Record - Purchasing Organization Data Order Price History: Info Record Release Documentation Vendor Address: Purchasing Document History of Purchasing Document History of Purchasing Document - Delivery Costs Delivery Schedules Account Assignment in Purchasing Document Purchasing Document Header Material Provided Item in Purchasing Document Purchasing Document Item Index for Stock Transport Orders for Material Account Assignment in Service Package Header: Physical Inventory Document Physical Inventory Document Items
TRANSP TRANSP
MG MG
Organizational Organizational
AUFM 发票:
生产订单相关的货物移动(比查MSEG快100倍) RBKP RSEG HEADER ITEM
resb
外协订单中的组件 也存在这
对像更改表
CDPOS CDHDR
item header
条件表
konv
Pointer for forecast data MSM MSM MSM MSM MSM LBKUM:last month
MSM MSM MSM LMM LMM Sales Data (for each country) Warehouse management inventory data Warehouse management inventory type data
Logical Database/s EBM EBM IFM IFM IFM
Notes
EBM EBM EBM EBM EBM
INM INM EKKO-KNUMV & KONVKNUMV,condition types
TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP
MG MG MG MG MG MG MB MB
Master Master Master Master Master Master Transaction Transaction
Conditions (Transaction Data) 地址 (业务地址服务) 供应商主数据 (一般地区) 地址中的EMAIL表 Vendor master record purchasing organization data Material Descriptions Material Index for Forecast General Material Data Plant Data for Material Storage Location Data for Material Material Master Storage Location Segment: History Units of Measure for Material Material Control Record Material Valuation普通库存评估 Material Valuation:History 项目库存评估 销售订单库存评估 Stock at Production Storage Bin Batches Batch Stocks Tax Classification: Material Material Data per Warehouse Number Material Data per Storage Type Header: Material Document Document Segment: Material Special Stocks with Customer Project Stock Project Stock Total Total Special Stocks with Vendor Customer stock with vendor
ME MG MG MG MG MG MG MG MG MG
Transaction Master Master Master Master Master Master Master Master Master
TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP
存有SO,PO等具体单据的各项目条件行,EKKO中该订单中链接到KONV的号,KONV中是分订单行项目的
A018,A017 konh konp konm know
条件记录表,内的KNUMH连到KONP等表中。 条件记录抬头表 存的是条件记录 quantity scale value scales
物料主数据中的分类视图取值 AUSP:Characteristic Values
Table Application Data Table Class Class Class EBAN TRANSP ME Transaction EBKN TRANSP ME Transaction EBUB TRANSP ME Transaction EINA TRANSP ME Transaction EINE TRANSP ME Transaction EIPA TRANSP ME Transaction EKAB TRANSP ME Transaction EKAN TRANSP ME Transaction EKBE TRANSP ME Transaction EKBZ TRANSP ME Transaction EKET TRANSP ME Transaction EKKN TRANSP ME Transaction EKKO TRANSP ME Transaction EKPB TRANSP ME Transaction EKPO TRANSP ME Transaction EKUB TRANSP ME Transaction ESKN TRANSP ME Transaction IKPF TRANSP MB Transaction ISEG TRANSP MB Transaction 如果删除盘点凭证的话,会从数据库中物理删除,如果设删除标识则不会物料删除 KONV ADRC LFA1 ADR6 LFM1 MAKT MAPR MARA MARC MARD MARDH MARM MARV MBEW MBEWH QBEW EBEW MBPR MCHA MCHB MLAN MLGN MLGT MKPF MSEG MSKU MSPR MSSQ MSSL MSCD 275431759.xls
object是物料号 Internal characteristic Internal characteristic Int counter
是特性内部号 需要有表匹配,这个表是CAWN:Characteristic values
CAWN:Value Texts
275431759.xls
MM Tables, Page 2