Difference in Data between FS10N and FAGLFLEXT Table.

[former_member466150]

Hi All,

I am trying load data from 0FI_GL_10 Data source from ECC into BW then into BPC.

In ECC while Reconciling Data in FS10N and table FAGLFLEXT I found Difference in Monthly Data for a specific account in 2013 and remaining entire Data is Matching for other periods.

For example in FS10N there are only Postings made for the Month 04/2013 and 05/2013.

While in table FAGLFLEXT it is showing values for 1,2,3,6,7,8,9,10,11,12 months as 100 where there are no postings (images).

Please suggest me if I am comparing correctly.

If there is some error, then please suggest any solutions.

Thanks and Regards,

Hemanth

[former_member184878 · Accepted solution]

Hello,

TCd. FS10n also uses FAGLFLEXT

so we should come to the same result.

I will make a small example which should help you.

1. TCd. FS10n

Query for ledger 0L

Result

Finding values in FAGLFLEXT using SE16n

we enter: RYEAR RLDNR RACCT RBUKRS (The same parameters as I have selected in FS10n)

You will also have to include  value TSLVT because you have carry forward 1.000

I have no balance carry forward in my example

Something interesting in your case:

See 1.000 carry forward we have prctr as I marked, then prctr is blank, I also marked it

I would take a closer look on this.

I hope I was helpful to you.

all the best erwin

[former_member466150 · Accepted solution]

Thanks for your reply Erwin.

Problem is solved.
The table FAGLFLEXT is holding both ACTUAL and Plan Data.

The record with PRCTR=null is related to planning and it has postings for 1,2,3,6,7,8,9,10,11,12 months as 100.

Now if we apply Filter on RRCTY=0(Actuals) and compare FS10N and FAGLFLEXT both the values are matching.

So I skipped those records (Planning=1) and loaded Data into BPC.

[João_FI_FIN-CS]

Hi,

When you want to find the difference between tables or documents, you can run (with careful) the FAGL_SUPPORT tcode. This tocde compares many tables lines items and with the balances.

JPA