Skip to Content
Author's profile photo Suresh Ramajeyam

SAP NEW GL – BW Reconciliation Quick Steps

Quick steps to reconcile the data between ECC and BW for General Ledger accounting – Leading Ledger(0L).

Snapshot below taken for one GL Account & for one company code for the year 2013 from the summary table in ECC Side. This is for the DS – 0FI_GL_10.

We can do the same reconciliation steps for the line item level data using the table FAGLFLEXA which is used by the DS 0FI_GL_14,however is should match with the totals tables and since the volume of the posting would be more for an account, total table level reconciliation is suffice. If needed we can do the reconciliation between the line item and the summary level cubes in BW side.

Authorization required :

SE16N (ECC),

FS10n(ECC),

Listcube (BW)

Tables Used

FAGLFLEXT

ECC

Go to Transaction FS10N,

Balance 2013.PNG

Now check the data in  table FAGLFLEXT for the period 12 – 2013 , with the filter on Debit Credit Indicator.

Debit,

FLEXT2013_Debit.PNG

Credit,

FLEXT2013_Credit.PNG

Balance as of Period 11 =  192,966,991.54 , Balance  for period 12  = 62,440,065.16

Total Cumulative balance for 2013 = Cumulative  Balance as of period 11  + period 12 balance ; 255,407,056.70

Which will be reflected as the opening balance for the year 2014.


2014 Balance.PNG


BW,

After the data loads, go to Listcube transaction and give the relevant company code ,account numbers in the selection screen what you gave  in ECC,

Note : Select Currency type 10 and Value type = 10.

The Ledger 0L denotes here is the leading ledger.

Cube+Output_2013.PNG

Assigned Tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Suresh,

      Nice one with explations.... 🙂

      Thanks,

      Purushotham.

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      Thanks Purushothama!

      Author's profile photo Former Member
      Former Member

      Good explanation Suresh . It will help us in reconcillation of new GL between ECC and BW.

      Thanks for sharing 🙂

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      You welcome .

      Author's profile photo Former Member
      Former Member

      Blog is very informative..It cleared my doubts on Reconcillation process...Thanks for sharing

      Author's profile photo Former Member
      Former Member

      Very good explanation. Thanks for sharing 🙂

      Author's profile photo Suresh Ramajeyam
      Suresh Ramajeyam
      Blog Post Author

      You Welcome 🙂

      Author's profile photo RamS A
      RamS A

      Please explain the same in SD,

      Its helpful with the same.

      Thanks,
      Rama.

      Author's profile photo Former Member
      Former Member

      Very Good Document

      Regards

      Sudha Yadav

      Author's profile photo Former Member
      Former Member

      thanks , nice one

      Author's profile photo Atul Kumar
      Atul Kumar

      super.. thanks for sharing this.