Comparative report between two ledgers, FI

[Former Member]

Hi Gurus,

We have maintained two ledgers

1) IFRS- 0L

2) US GAAP- L1

We need a comparative report for L1 and 0L Books in following breakdown format

Level 1. Company code                   L1     0L  Difference              

     Level 2. Company code & GL Level

          Level 3. Company Code, GL Code & Transaction level

How can we accomplish this??

[ajaycwa1981 · Accepted solution]

Hi

Std SAP offers TFC_COMPARE_VZ (New GL) and SAPF190 (Classic GL) to compare ledgers

Not sure of the format, but they do compare ledgers

Rgds

Ajay M

[Former Member · Accepted solution]

Hi Ajay,

Thank you so much for the response.

I checked, but didn't understand what went wrong with my report.

Anyhow, I also tested TCode- GCAC, I can have the difference between ledgers and can view the breakdown of line items to the document line item wise.

But, the problem is, I need to have this report extracted to excel and SAP wouldn't allow us to get the breakdown of GL accounts document wise.

Please suggest mentors???

[Former Member · Accepted solution]

Hi.

In FGI0 there is a report for comparing, and you could upload it to excel

[Former Member · Accepted solution]

Hi Aleksey,

I tried running this report. This report is helpful in comparing different years within a ledger.

Please help me with a drop down report for comparing different ledgers?? Please suggest, should i opt for a report painter?

We need a comparative report for L1 and 0L Books in following breakdown format

Level 1. Company code                   L1     0L       Differences             

     Level 2. Company code & GL Level

          Level 3. Company Code, GL Code & Transaction/Document level

[Former Member · Accepted solution]

Hi, I'm afraid that there is no such report with drill down. You can create your own in sq01/sq02

[Former Member · Accepted solution]

Thank you so much, all.