cancel
Showing results for 
Search instead for 
Did you mean: 

Charts of accounts. Accounts not created at Company Code Level

Former Member
0 Kudos

Our client has several company codes. Every Company Code uses the same Chart of Accounts.

Our client wants a report which inform them, which accounts created at Chart of Accounts level (SKA1) has not been at company code Level (SKB1).

I have tried standards reports and I have tried to create Querys, but I didn't have any success.

There is any way to find out this information?

I wolud appreciate any help-

Thanks in advanced

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I would do it through vlookups in excel

1. Get the Accounts in Chart of Accounts using SKA1

2. Get the Accounts info of each and every Co Cd from SKB1 - Once you get this info i,e Co Cd and Account info, Sort it by Co Cd.

A Column - Info derived from 1 with title of Chart of Accounts

B1-Z1 - Multiple Co Cds found under step 2

B2 - Z2 Columns - Data found under step 2

Former Member
0 Kudos

Thank you for your answer.

This will be an easy way to solve the problem.

I wonder if there is any report or a query, which will give me this information without using MS-Excel or any external application.

Thanks in advance