SAP MM/SD常用表

 

SAP标准用途,给User用的

No
Broad level Report Options available for report execution Tcode in SAP Remarks Used by Report area
1 Purhase order analysis By delivey schedule ME80FN This report can be used for displaying the information of purchase orders created and the transactions that has taken place. Purchase Purchase
By purchase order details
By purchase order hostory
2 Purchase order display By supplier ME2L Facility available to restrict the viewing based on the status of PO viz. Partly received, Purchase Purchase
By material ME2M Closed, No GR made
By buyer   Bill passing not done , etc.
By plant    
3 Anlysis of order values By Material ME81N Totals analysis Purchase & Finance Purchase
By buyer ABC analysis
By supplier Analysis using comparison period
  Frequency analysis
4 Goods receipt forecast By purchase order ME2V Number of anticipated deliveries Pruchase & Stores Purchase
By vendorwise
By material wise
5 Stock lying with subcontractors By Supplier ME2O Can be useful in deciding which component is to be given to supplier if the procurement is on subcontracting basis. It also helps in giving the visibility of stocks lying at subcontractor. Pruchase & Stores Purchase
By material
6 Monitor supplier confirmation By Supplier ME2A This program is useful especially for imported purchase orders or such cases where the lead time of procurement is very high. Purchase & planning Purchase
By buyer
7 Purchase analysis By buyer MCE1 This program will give you information on purchase value, invoice value during a selected period. However for these reports it is necessary to update the relevant LIS structure. Purchase Executives Purchase
By Material MCE3
By commodity type MCE5
By supplier MCE7
  MCE8
8 Long term planning analysis By supplier MCEA This report can be used for Purchase budget requirement. However for this report to work, long term planning functionality should be put in use. Purchase Executives Purchase
By material MCEB
By commodity type MCEC
9 Material document listing By Material MB51 This report provides you with a list of the material documents which  were posted for one or more materials. Stores / Finance Inventory
By movement wise
By supplier
10 Account document listing By material MR51 The report Accounting documents for material produces a list containing all accounting documents available for a selected material. Finance Inventory
By date
11 Stock Overview By material MMBE The stock overview provides you with an overview of the current stocks of a material at all places within plant        All Inventory
By Plant
By batch
12 Stock requirement list By material MD04 This report will help you to analyse material requirement plan considering stocks and future requirements. Planning
SAP S/4HANA 中的物料管理(MM)模块是企业资源计划(ERP)系统的重要组成部分,主要用于管理采购、库存、物料主数据等核心业务流程。在该模块中,存在多个关键数据库,用于存储和管理与物料管理相关的数据。 以下是一些常用SAP S/4HANA MM 模块数据库: ### 常用 MM 模块数据库及其用途 1. **MARA** - 用途:存储物料主数据的一般数据,包括物料类型、行业部门、创建日期等信息。 - 此是所有物料管理流程的基础,几乎所有的物料查询和操作都会涉及该。 2. **MARC** - 用途:存储物料的工厂级数据,例如工厂状态、冻结标志、物料组等。 - 该与 MARA 通过 `MATNR`(物料编号)关联,提供工厂特定的物料属性[^1]。 3. **MARD** - 用途:存储物料的库存地点级数据,包括库存地点、库存状态等。 - 该也与 MARA 通过 `MATNR` 关联,并与 MARC 通过 `WERKS`(工厂)关联。 4. **MSEG** - 用途:记录物料凭证的项目数据,包括移动类型、数量、库存地点等。 - 该用于追踪物料的移动情况,例如收货、发货、转储等操作。 5. **EKPO** - 用途:存储采购订单的项目数据,包括物料编号、数量、价格、交货日期等。 - 该是采购流程中的核心之一,用于记录采购订单的具体内容。 6. **EKET** - 用途:存储采购订单的计划交货数据,包括计划交货数量和日期。 - 该与 EKPO 通过 `EBELN`(采购订单号)和 `EBELP`(采购订单项目号)关联。 7. **LIPS** - 用途:存储交货单的项目数据,包括交货单号、物料编号、数量、交货日期等。 - 该在销售与分销(SD)模块中使用较多,但也与物料管理模块的交货流程密切相关[^1]。 8. **RESB** - 用途:存储预留/独立需求数据,包括预留数量、预留日期、用途等。 - 该用于管理物料的需求计划,支持生产计划和库存控制。 9. **MCHB** - 用途:存储库存批次数据,包括批次编号、库存数量、库存地点等。 - 该用于管理具有批次管理要求的物料库存。 10. **T023T** - 用途:存储物料组的描述信息,包括物料组名称、语言等。 - 该用于提供物料组的文本信息,支持物料分类和报分析。 这些数据库构成了 SAP S/4HANA MM 模块的核心数据结构,支持企业实现高效的物料管理与供应链运作。在实际应用中,通常需要结合多个进行联合查询,以满足复杂的业务需求。 ```sql -- 示例:查询某个工厂中所有物料的基本信息和库存地点数据 SELECT MARA.MATNR AS MaterialNumber, MARA.MTART AS MaterialType, MARC.WERKS AS Plant, MARD.LGORT AS StorageLocation, MARD.LABST AS StockQuantity FROM MARA INNER JOIN MARC ON MARA.MATNR = MARC.MATNR INNER JOIN MARD ON MARA.MATNR = MARD.MATNR AND MARC.WERKS = MARD.WERKS; ```
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值