LIST OF ALL CONSUMPTION AND STOCK GL ACCOUNTS

[Former Member]

Dear experts,

Can you please tell me what is the tcode for checking all consumption n stock related GL accounts.

Thanks & Regards

Sreelatha.

[former_member184878 · Accepted solution]

Hello,

I think meaning of consumption account is revenue and cost account

Use Tcd. SE16n and table SKA1 and check field GVTYP.

IF gvtyyp = X then you select all revenue and cost accounts.

For stock accounts:

For a quick check you can use SKA1-txt50 and select by description.

Like *stock*.

second option is, taking a look on customizing tables. here i would need the information  what you have customized then I can tell you tables.

br erwin

[Former Member]

Dear All,

Thanks for the reply.... guess this will help me out to get the list of GL accounts.

Regards

Sreelatha

[former_member186576]

Also sreelatha, a bit more sophsticated way will be

please go to tcode -se16

table-T030

In Chart of Account field KTOPL input your CoA

In transaction field ( KTOSL) input -GBB

In account modifier (KOMOK) field input -VBR

Executes and and system will display all the consumption accounts.

Thanks and regards,

Sam

[former_member186576]

Hi Sreelatha,

Please go to tcode S_ALR_87012328, input the co.code only and execute.  Result will display all g/l accounts. Click the find icon or (ctl+f). Then input a search parameter like 'Sales' or ' Revenue' or Stock and all the accounts with that description will appear together. Hope this helps. Thanks

Regards,

Sam