ITPub博客

首页 > Linux操作系统 > Linux操作系统 > MM ACCOUNT DETERMINATION/自动过账解释

MM ACCOUNT DETERMINATION/自动过账解释

原创 Linux操作系统 作者:ajiang11 时间:2009-10-10 15:32:06 0 删除 编辑

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

 

如果你要得到一个G/L Account的话. 是需要具体几个条件的.

 

一是,你要知道是那个CLIENT (这个基本上是属于废话,是一定知道的)

 

第二个条件:你可以用以下方法去记录. 你们集团,有两个公司,1000,2000.而在这两个公司中,公司1000下面有工厂1001,1002. 1000是在美国,2000是在中国. 因此,这两家在会计上的分类帐是不同的.  因为这个公司肯定就会是一个KEY,要通过这个KEY值来找到G/L Account.(KEY就叫Chart of Account ,IDES中使用INT)

 

然后呢,在1000下面不是有两个工厂吗,美国公司听说一般都比较BT,有可能在相同的公司下面,不同的工厂,都有一些不同的设定。所以为了满足这种BT要求,SAP就让你自己选择,把PLANT也做为一个KEY(这个PLANT对应的名字就是valuation grouping code—评估分组). 所以到这里就有三个KEY, clint + chart of account + plant.

 

另外,针对发料,你们公司用GI TO Cost Center. 但是你GI 工程部与GI 到采购部,这两个需要划分到不同的G/L Account ,比如说,GI TO 工程部叫设计方面的ACCOUNT,而采购,你可以划分到 生产方面的ACCOUNT. 而为了区别这种需求,SAP就多了一个叫 Account Grouping的玩意。但这个玩意一般是针对GBB来说的所以到现在为此有四个KEY。比如说,你发物料A到工程部。这个消耗的科目可能是 10001科目. 而你发料到 采购 你们总经理,可能是管理科目。就是消耗的类别 对应的帐户因此,到现在为此有几个KEY值了。

 

 

还有一个就是valuation class. 因为不同的物料可能有不同的分类科目,使用Material Type 来和Account Category Reference 连接(M-1);

 

使用Account Category Reference来和Valuation Class连接(1-N);

 

你只要记住这个条件:clint + company code + plant + material + account grouping = Clint + Chart of Account + Valuation Grouping Code + Valuation Class + Account Grouping  (这只是最齐全的,当然你可以选择其中的某些组合,)

 

除了这个外,还有一个,就是叫做Value String , 价值串. 就是看得人头疼的VBXGBBPRD之类的。那这个TRANSACTION又是如何得到的呢,就是从你的movement type中来的。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7180441/viewspace-616225/,如需转载,请注明出处,否则将追究法律责任。

下一篇: SD定价过程
请登录后发表评论 登录
全部评论

注册时间:2008-03-21

  • 博文量
    5
  • 访问量
    10771