SAP MM常用表及表关系

简介: SAP MM常用表及表关系   转自:http://blog.csdn.net/qptufly/article/details/8014549   SAP MM常用表及表关系: ...

SAP MM常用表及表关系

 

转自:http://blog.csdn.net/qptufly/article/details/8014549

 

SAP MM常用表及表关系:

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

DVER – Material Master: Consumption <MRP Area>

MVKE – Material Master: Sales <Sales Org, Distr Ch>

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

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

 

 

 

 

 

De.ion: http://img.my.csdn.net/uploads/201209/24/1348492638_4819.gif

 

 

 

 

De.ion: http://img.my.csdn.net/uploads/201209/24/1348493444_9624.gif

 

 

De.ion: http://img.my.csdn.net/uploads/201209/24/1348493573_4656.gif

 

 

 

De.ion: http://img.my.csdn.net/uploads/201209/24/1348493589_4824.gif

 

 

 

De.ion: http://img.my.csdn.net/uploads/201209/24/1348493608_6758.gif

 

 

目录
相关文章
SAP MM/FI_运费处理方式
常见的采购运费处理方式
SAP MM 途损处理方式
通常客户采购业务需求提到货物运输有损耗,需要针对此业务给出合理方案输出,下面笔者针对此类业务分析下各种实现方案的可行性!
SAP MM初阶之事务代码MIGO界面批次拆分最多输入15行?
SAP MM初阶之事务代码MIGO界面批次拆分最多输入15行?
SAP MM初阶之事务代码MIGO界面批次拆分最多输入15行?
SAP MM不常用移动类型之325
SAP MM不常用移动类型之325
SAP MM不常用移动类型之325
SAP MM初阶之采购信息记录里的Prior Supplier栏位
SAP MM初阶之采购信息记录里的Prior Supplier栏位
SAP MM初阶之采购信息记录里的Prior Supplier栏位
SAP MM初阶之ME12里为啥只能维护少量条件类型的价格?
SAP MM初阶之ME12里为啥只能维护少量条件类型的价格?
SAP MM初阶之ME12里为啥只能维护少量条件类型的价格?
SAP MM 采购信息记录里的Automatic Sourcing 之二
SAP MM 采购信息记录里的Automatic Sourcing 之二
SAP MM 采购信息记录里的Automatic Sourcing 之二
SAP MM初阶之没有定义Access Sequence的条件类型不能使用MEK1维护条件记录
SAP MM初阶之没有定义Access Sequence的条件类型不能使用MEK1维护条件记录
SAP MM初阶之没有定义Access Sequence的条件类型不能使用MEK1维护条件记录
SAP MM 采购信息记录里的Automatic Sourcing
SAP MM 采购信息记录里的Automatic Sourcing
SAP MM 采购信息记录里的Automatic Sourcing