The logical process of account assignment determination

 

The logical process of account assignment determination

It’s very easy if you are strong in IMG. I can guide you go to OMJJ Create a movement type by copying 601 to say 901 (or Z01) Now:

1)      Table T156 will have something called posting reference.

2)      Taking the posting reference to the table T156SY, for the Posting Reference     determined in the step# 1, SAP finds two things called: Value Reference Key and   Quantity Reference Key  

3)      Value Reference Key is verified in table T156W and Qty ref in T156M Earlier T156S used to be there before 4.6 B. It is divided into T156SY (Client independent System table) and T156SM (Client Dependent - customized). For our context, T156SY is important.

 

With the above knowledge, let's now see how movement type determines Quantity and value reference keys in any transaction:

1)      Your movement type says 601: from this, (T156), it finds Posting reference: 601

2)       Transaction that you are using: say VL02N, using this value, it goes to T158, it finds movement indicator, KZBEW (L Goods movement for delivery note)

            If the transaction involves any special stock, (say consignment W). For simple

            case, say no special stock so...blank for SOBKZ

3)      Plant is supplied by the transaction that you do Material# you will supply. For Plant and material# you supplied, it goes to T134M (material type config) to see if value update (WERTU) and Quantity Update (MENGU) are active or not. It selects this combination and passes back to code in its search Receipt Indicator ( If it is stock transfer, say T etc)...in your case, it is Blank Consumption Indicator (Blank for you) (Consumption posting specifies that the consumption is to be posted to a consumption account (V) or an asset account (A). The indicator is used in the case of goods receipts for purchase orders and is derived from the account assignment category of the purchase order....Used by SD and QM to determine if an assignment to CO object is necessary). Just don't worry about this very much

4)      Now SAP found all the values it requires (above listed), to go to T156SY to find what are the values of Value String and Quantity String. So, while narrating this, I ran the entries suitable for the above scenario in T156SY and go the below values:

Pstng strng ref   601

Value updating X

Qty updating X

Special Stock

Movement ind. L

Receipt ind.

Consumption

Value string WA01

Quantity string MA01

SLoc. necessary    X

W/o value strg.

InspLotOrigin D    05

InspLotOrigin C   02

Bus. trans D PMS1

Bus. trans. C PMS5

For you, just important ones are:

Value string WA01

Quantity string MA01

5)      Now, it turns out to be more interesting:

Let's talk about Value String first: WA01

Go to T156W with WA01 You will have the value of ‘Trans./ev. Key’ as below:

BSX

GBB

PRD

BSX

UMB

GBB

GBB

BSX

This content derived from T156W and earlier determined content of T156SY together gets into a valuation program SAPLMBGB (FORM WA01).

In this program, it loops an internal table X156W and extracts values: Transaction/Event Key and its corresponding value simultaneously.

From T030 (OBYC configuration for account determination) will be looped to pass the determined G/Ls back to code (for the above transaction/event keys)

From T156W, counter (say 02) for corresponding processing key (Ex: GBB) is used to determine matching Keys (02) in T156X

Of course, passes the account modifier to T030:

Movement Type 601

Value updating X

Qty updating X

Special Stock

Movement ind. L

Consumption

Value string WA01

Consec. counter 2

Acct modif VAX

Check acct.ass. X (again VAX and VAY are determined based on cost object requirement, ignore it for your basic understand now) depends upon consumption posting .The result goes to an internal table XACCIT to provide us the final accounting document results.

 

T156B can be used for copying CO object (say Project or WBSE) to PRD account if customer wants. Second episode continues tomorrow

 

Note 34913 – The handling of tables T156S, T156X, T156W, T163K

Summary

Symptom

Entries are missing or available entries are to be modified in table T156S. Error message M7001 'Entry & & & not in table T156S (system error)' is displayed when posting a goods movement.

Additional key words

T156S, T156X, T156W, T163K, OME9, M7001

Cause and prerequisites

Solution

The above tables are read as follows during a goods movement:

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-Table T158.
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).