`
Jack Wu
  • 浏览: 870883 次
  • 来自: ...
社区版块
存档分类
最新评论

MM--移动类型的配置相关的系统表,举例说明SAP是如何根据配置抛帐的

阅读更多

一、移动类型相关的表

Customizable  

Table Name Descriptioin
T156 Movement Type - BWART
T156B Movement Types: Screen Selection (BWART+SOBKZ) Batch determination
T156SC Mvt Type: Qty/Value Posting: Customer Table; as of Rel. 4.6A ;QM.Inspection
T156Q Movement Type: Material-Independent Control
T156X Trans./Event Key Modification
T156T Movement Type Text
T158B Check Table: Movement Type for Transaction Code
T157H Help Texts for Movement Types
T157D Reason for Movement
T156N Next Movement Type
TMCA Evaluating movement types for LIS update
System   
Table Name Descriptioin
<p:colorscheme colors="#ffffff,#000000,#808080,#000000,#bbe0e3,#333399,#009999,#99cc00">T156SY</p:colorscheme> Mvt Type: Qty/Value Update: System Table; Rel. 4.6A;(<4.6,T156S)
T156W Posting string values(BUSTW)
T156M Posting String: Quantity(BUSTM)
T156F Fields in Quantity String
T156C Stock Types and Their Values

二、一些的作用说明

T163K
The 'Consumption posting' indicator and the account grouping code for the automatic account determination are read from table T163K for the account assignment category from the purchase order.
The consumption posting is empty for goods receipts that are not assigned.
The value from T163K is not always used for goods issues.
During goods issues with movement type 601, the 'Consumption posting' indicator originates from the delivery.
You can maintain the table with transaction OME9.

T156S
This table must contain an entry for the following key fields, because otherwise error message M7001 'Entry & & & not in table T156S (system error)' is displayed.
The movement type is entered in the goods receipt transactions.
The value update is stored in the detail screen for the material type, transaction OMS2.
The quantity update is stored in the detail screen for the material type, transaction OMS2.
The special stock indicator is entered in the goods receipt transaction.
The movement indicator is derived from the transaction.
Consumption posting indicator for stock transfer.
The consumption posting is selected from T163K.
For this key, important economical data such as value string and quantity string is read from T156S during a goods movement. If a value string is maintained for an entry for a material with value update, this must not be deleted because otherwise inconsistencies may occur.

T156X
If you add an entry in T156S, you must also maintain T156X. T156X has the same key fields as T156S plus value string plus numerator. The account grouping code for every entry is stored here. It is used in the automatic account determination.

T156W
The respective transaction/event keys (GBB, WRX) for the value string are maintained here. For these transaction/event keys, you must store a G/L account for the automatic account determination considering the valuation grouping code and the account grouping code (from T163K and T156X).

 关于T156S T156X T156K T156W参见:Note 34913 - The handling of tables T156S, T156X, T156W, T163K

三、举例说明SAP是如何根据配置抛帐的(以101移动类型为例)
In the test case that you propose, in the goods receipt for a purchase order with the movement type 101, normally:

.- We expect an invoice to arrive, so we post to the key WRX for the GR/IR clearing account.
.- We increase the value of our stock, so we post to the key BSX for the stock account.
第一步:
In the table T156 for the Movement Type you are posting (101 in this case) you have the Posting String Reference (T156-BUSTR, in this case it is also 101).
第二步:
With this posting string reference you can have a look at the table T156SY. Here, as mentioned before, depending on:
If you are posting into the special stock.
If value update and quantity update are made (see the material type for the material in the table MARA and then check OMS2 for the Plant).
If you post with reference to a document (purchase order, etc).
If you post with reference to a special procedure (stock transport order, for example).
If you update consumption.
第三步:
You locate the Value String T156SY-BUSTW. For example, WE01.
第四步:
With this value string, in T156W, you can see all the possible posting keys which can be used:

BUSTW CNT02 VORSL
WE01 01 BSX
WE01 02 WRX
WE01 03 PRD
WE01 04 KDM
WE01 05 EIN
WE01 06 EKG
WE01 07 BSV
WE01 08 FRL
WE01 09 FRN
WE01 10 BSX
WE01 11 UMB
第五步:
The program coding reads this table, and determine all these possible posting keys. Then it goes into the valuation program and tries to determine a value for all of them.
第六步:
Those keys which finally get a value of zero (for example, if BSX and WRX match, no price differences are generated, so PRD gets a value of zero) are not posted, and not included in the final accounting document.

四、相关的函数
 MR_ACCOUNT_ASSIGNMENT
account from the table T030 according to:

SELECT SINGLE * FROM T030 WHERE KTOPL = KONTENPLAN
AND KTOSL = VORGANGSSCHLUESSEL
AND BWMOD = BEWERTUNG_MODIF
AND KOMOK = KONTO_MODIF
AND BKLAS = BEWERTUNGSKLASSE.

the chart of accounts (KONTENPLAN), the posting key (VORGANGSSCHLUESSEL), the valuation grouping code (BEWERTUNG_MODIF), the account modifier (KONTO_MODIF) and the valuation class in the material master (BEWERTUNGSKLASSE).

This table T030 is customized in OBYC.
account from the table T030 according to:

五、配置路径说明
1) You are posting in a Plant. The Plant is assigned in OX18 to a Company Code. The Company Code is assigned in OB62 to a Chart of Accounts.
You take here the Chart of Accounts for your Company Code.

2) Under the IMG:
Materials Management -> Valuation and Account Assignment -> Account Determination -> Account Determination Without Wizard -> Define Valuation Control
You define whether you want your Plants to be grouped together or treated individually.
Then, in the next customizing step to "Group Together Valuation Areas", you can see to which group you have assigned the Plant.
This is the Valuation Grouping Code.

3) The Valuation class is defined in the Accounting 1 view of your Material Maser.

4) The account modifier is used in some posting keys like GBB, PRD or KON to subdivide the account determination.
You can see in the activity "Define Account Grouping for Movement Types" the different account modifiers to be used in these posting keys.
You need to know:
The movement type.
If you are posting into the special stock.
If value update and quantity update are made (see the material type for the material in the table MARA and then check OMS2 for the Plant).
If you post with reference to a document (purchase order, etc).
If you update consumption.

Once you have all this info, you can find the account in OBYC.
相关连接:
http://blog.csdn.net/CompassButton/archive/2008/02/01/2076149.aspx
http://blog.csdn.net/CompassButton/archive/2008/01/31/2075983.aspx

分享到:
评论

相关推荐

    SAP移动类型详细说明

    SAP移动类型详细说明 101 Goods receipt for purchase order or order 101有关采购订单或生产订单的收货 103 Goods receipt for purchase order into GR blocked stock103有关采购订单的收货到GR冻结区

    SAP_MM-SAP物料批次管理配置及操作手册.doc

    SAP_MM-SAP物料批次管理配置及操作手册 SAP 物料批次管理配置及操作手册是 SAP_MM 模块中的一个重要组件,主要用于管理物料的批次信息,跟踪物料的质量和batch信息。该手册旨在指导用户如何配置和操作 SAP 物料批次...

    SAP MM自动记账科目配置

    sap 为仓库移动类型定义科目分组,实现系统自动记账, 是MM也FI集成的精华。

    SAP系统MM后台配置

    SAP系统MM模块后台配置介绍,一步一步很清晰的介绍,帮助你完成复杂的SAP系统MM的配置

    sap移动类型详解

    sap移动类型应用1、101/102(凭证方向互为相反) 借:半成品/产成品/库存商品 贷:生产成本-转出 2、105/106(凭证方向互为相反) 直采收货: 借:材料/库存商品等(按标准成本计) 贷:GR/IR(材料采购)(按采购...

    SAP-FI-FM基金管理-系统配置(1).doc

    SAP-FI-FM基金管理系统配置 SAP-FI-FM基金管理系统配置是SAP系统中的一种功能模块,主要用于基金管理和预算控制。该模块提供了一个综合的基金管理解决方案,涵盖了基金的创建、管理、预算控制等方面。 一、激活...

    图解SAP移动类型

    SAP MM移动类型图解大全 适合SAP顾问 适合AP用户

    SAP MM物料移动类型type

    ERP的基础是物流 那么 怎样在系统中控制物流? 最基础的需求是控制进/出/消耗 包括1/从哪里进来(采购订单/生产订单/其他...3/这种移动的数量和金额 对库房帐和财务帐带来的影响 以及这种影响能否自动实现(MM-FI的接口)

    SAP_MM-SAP委托加工(外协)业务配置及操作手册.doc

    SAP_MM-SAP 委托加工(外协)业务配置及操作手册 本手册详细介绍了 SAP 中的委托加工(外协)业务配置及操作手册,涵盖了业务配置、操作流程、会计科目设置、物料设置、采购订单设置、外协发料、外协入库、发票处理...

    (SAP MM移动类型

    ( SAP MM移动类型( SAP MM移动类型

    SAP-按销售订单采购生产系统实现之配置及操作.doc

    SAP按销售订单采购生产系统实现之配置及操作 SAP是当前最流行的企业资源计划系统之一,本文档旨在介绍SAP按销售订单采购生产系统的实现和操作配置。该系统主要针对制造业和流通业的企业,旨在提高生产效率、降低...

    SAP-MM后台配置

    SAP-MM后台配置,将SAP/MM模块基本的配置全部讲了一遍,合适初学者观看!版权归作者所有!

    SAP-MM-供应商配置.docx

    sap-mm模块中的供应商配置,包括创建供应商账户组,定义带有屏幕格式的账户组,创建供应商的编号范围,可以创建自定义的编号范围,也可以用系统标准的编号范围,创建号段,将号段分配给供应商,等操作

    SAP常用后台数据表大全(FI-CO-MM-SD-PP等).pdf

    SAP常用后台数据表大全(FI-CO-MM-SD-PP等).pdf

    SAP库存管理,移动类型配置及使用场景

    SAP库存管理,移动类型配置及使用场景大全 库存管理系统就是管理物资的各类移动。SAP通过“移动类型”来控制各种检验、入库、货架、调拨、出库、报废和盘点等库存事务,控制物料移动中相应会计科目的更新。移动类型...

    SAP 完全配置方案-MM.pdf

    MM配置资料

    SAP方丈-MM-标准价与移动平均价

    SAP方丈-MM-标准价与移动平均价 S和V的最主要区别就是S一直以标准价计算.V则是实时的更新的.

    SAP移动类型说明

    SAP 移动类型 说明 例如:101 采购订单收货

    SAP MM模块配置

    sap mm配置

    SAP-MM-代码大全

    SAP-MM-代码大全SAP-MM-代码大全

Global site tag (gtag.js) - Google Analytics