Skip to Content
h k

Difference in Data between FS10N and FAGLFLEXT Table.

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

FAGLFLEXT.png (33.5 kB)
FS10N.png (25.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 22, 2014 at 05:43 PM

    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


    123.jpg (126.0 kB)
    456.jpg (257.4 kB)
    789.jpg (205.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • 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.

      FAGLFLEXT.png (48.4 kB)
  • Dec 24, 2014 at 01:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded