How does account determination take place ??

[Former Member]

dear experts

pls enlighten me on how excatly account determination take place .

what is an account grping code

what is transaction event key

what is the technical name for keys used in OBYC like BSX , WRX GBB etc

what is the other keys like VAX ,INV used within GBB called

what are WE,WR etc

How are movement types linked to valuation

Is it possible to create/change all of the above ??

Regards

Anis

[Former Member · Accepted solution]

HI

Account modification Key has a different meaning depending on the procedure. It is used to differentiate account determination. This is fixed and cannot be changed.

You can say different offset posting keys are nothing but account modifiers and are used for posting to different G/L accounts during debit and credit.

For example as below you will find each key has its own identification and used for unique process.

AUF: for goods receipts for production orders with account assignment

BSA: for intial entries of stock balances

INV: for expense/revenue from inventory differences

VAX: for goods issues for sales orders without account assignment object

VAY: for goods issues for sales orders with account assignment object

VBO: for consumptiom from stock of material provided to vendor

VBR: for internal goods issues (e.g., for cost center)

VKA: for consumption for sales order without SD

VNG: for scapping/destruction

VQP: for sampling

ZOB: for goods receipts without purchase orders

ZOF: for goods receipts without production orders

all the abobe are under GBB

Similarly you have for PRD also

none for goods receipts and invoice receipts for purchase orders

PRF: for goods receipts for production orders

PRA: for goods issues and other goods movements

You can also define your own account groupings for the transaction/event GBB.

Example:

If you wish to post goods issues for cost centers (movement type 201) and goods issues for orders (movement type 261) on separate consumption accounts, you could assign account grouping ZZZ to movement type 201 and account grouping YYY to movement type 261, for example. In the step "Automatic postings", you can then assign different accounts to the individual account groupings.

Hope it helps you

Regards

Vivek

[former_member197616]

Hi,

In the second question you have asked about the account pstings for various moment types which you are doing.

Apart from the above answers , you can find for that combination of material, material type,valuation class and moment type you can check what postings are taking place for that moment type with its transaction keys and the assigned GL account.

sprommvaluation and account assignmentaccount determinationwith out wizardconfigure automatic postings-simulationhere you provide the material,plant,moment typeand select the transaction and choose account assignments , system will give you the all possible posting keys and thier assigned GL accounts.

Hope this will serves your purpose.If not please reply.

Regards,

[Former Member]

Hi

If you do any transaction, system will search for G/L account to post This is called account determination.

It searches G/L in combination of Client + Chart of accounts + Transaction key + Valuation modifier + Account Group code + Valuation class

For example you are doing migo wrt PO using movet type 101

1. While login into the system we enter client

2. while creating PO we enter company code in Org data tab, so based on this it identifies Chart of Accounts ( In SPRO we link company code and chart of accounts)

3. While creating material code we use material type, based on material type it identifies Quantity or value updation (Maintains in SPRO) & Based on business transaction (goods movement/invoice verification) it identifies Values string (WE01). Combination of these two (Qty/value updation & Value string) it identifies Transaction key.(BSX)

4. While creating PO we enter plant, so based on this it identifies valuation modifier/valuation grouping code (In SPRO we define valuation grouping code, it is groping of valuation areas/plants)

5. Since you use the posting transaction Offsetting entry for inventory posting for various transactions (such as goods issue, scrap, physical inventory), and these transactions should be assigned to different accounts (such as consumption accounts, scrap accounts, expense/revenue from physical inventory differences), it is essential to subdivide the posting transaction according to another key - the account grouping. It is already defined in standard SAP, we need not to define any thing.

6. While crearting material, use take material type & material type assigned to valuation class

(in SPRO material type assigned to valuation classes through account category reference.

Raju

[Former Member]

Hello Experts

If I have to find out what transaction key has hit a particular activity , can i find the same through the saved material /accounting documents .

Regards,

Anis

[raghavendra_praveen]

Hi

Open the accounting document generated through GR or IV (accounting entry), there you can see two (or more) entries (say inventory debit and GR/IR credit). Above these entries you can choose TRANSACTION option from edit layout which gives you the transaction type hit during the posting.

Thanks

[raghavendra_praveen]

Hi Anis

You can go through SAP help on account determination & some of the thread already posted in this forum.

VAX account is cost of goods sold account. When you do PGI then this account will be hit as credit entry (GBB-VAX).

INV is the initial inventory upload account, when you upload inventory through 561mvt type then this account will be hit.

WE and WR are transaction types for which MM transactions are attached (they define the postings).

Mvt types (OMJJ) with value string and quantity string under account grouping will define the transaction keys for posting.

You cannot change value string and quantity string for mvt types in OMJJ.

Thanks

[Former Member]

well all the terms are quite confusing ...

Given that i have a valuation area 0001

Valuation Grouping Code as 0001

Material Type ROH & ERSA

Acct cat reference 001, 002

Val Classes 3000,3001, 4000,4001

ROH , 3000 & 3001 assigned to 001

ERSA ,4000 & 4001 assigned to 002

NOW i do the following with both ROH & ERSA materials :

1. Initial entry (561)

2.GR against PO(101)

3.issue to Cost Center (201)

4.Issue against Prod Order(261)

5.Sale (601)

7.Subcontracting ( material sent as component & consumed against 543)

8.Sucontracting ( material procured )

9. Invoice Verification done where applicable.

Pls tell me how wud the accounts be determined in each case :

Regards

[Former Member]

pls revert bk !!

[raghavendra_praveen]

Hi

Check in OMJJ -Mvt type - update control - with your parameters (purchase order/production order, stock type (Q or E etc)..Otherwise you can use OMWN directly.

1. Initial entry (561)

For this entry BSX and GBB-INV

2.GR against PO(101)

BSX and GR/IR ( -)

3.issue to Cost Center (201)

GBB-VBR and WRX

4.Issue against Prod Order(261)

BSX and GBB-VBR

5.Sale (601)

BSX and GBB-VAX(-)

7.Subcontracting ( material sent as component & consumed against 543)

BSX(+) and GBB-VBO(-)

8.Sucontracting ( material procured )

9. Invoice Verification done where applicable.

This is similar to material revaluation (if you are performing revaluation in MIRO)

then BSX(+) Vendor

otherwise WRX and Vendor (-).

These are the standard postings keeping aside other differences like PRD, PRA etc. You can check mvt types for postings.

If you want to know how valuation groping code, transaction key, account cat.reference alters the account determination then use OMWB Tcode and enter material, plant, choose movement type and click simulation.

Thanks

Edited by: Praveen Raghavendra on May 4, 2009 12:08 PM