Skip to Content
avatar image
Former Member

Extractor for Financial Statements

Dear experts,

I'm trying to find out which extractor, ODS and cube do I have to use in order to show in a standard BW query the data for Financial Statements as they are shown in R3 with report RFBILA00.

I've been reading a lot, and I have tryed with several:

- 0FI_GL_4 updating cubes 0FIGL_C01 and 0FIGL_VC1. We used 0FI_GL_4 because tables GLT0 were empty in R3. This didn't give a very bad result, except for the account 129000 which represents the profit and loss for the year before. It doesn't appear the real ammount since it is just a flow of amounts without no document behing. For this we tryed with the standard query "0FIGL_VC1_Q0001".

Afterwards we were told that these tables (GLT0) were empty because they were using the New General Ledger, thus I updated the following flow:

- Extractor 0FI_GL_10 updating ODS 0FIGL_O10 which updated cubes 0FIGL_C10 and 0FIGL_V10. This doesn't work at all, very strange results are returned. We tryed with the standard query "0FIGL_V10_Q0001".

I have seen now that there is as well extractor 0FI_GL_14 but since I have tryed with so many and they haven't worked I am not sure to implement this one.

Does anybody know which standard extractor, ODS, cube and queries should I use in order to see Financial statements as in R3 report RFBILA00???

Thanks in advance to everyone, I really don't know how to continue or which is the issue....

Best regards,

Cecilia

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 21, 2009 at 02:02 PM

    Hi

    You should use this standard business content query 0FIGL_V10_Q0001 based on virtual infocube 0FIGL_V10

    install them from business content

    Hope it helps

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Dennis,

      I've been searching everywhere in BW this ammount but it doesn't appear. Nevertheless I believe it is normal since the ammount that I want to show is an ammount which doesn't appear in table BSEG because it doesn't has a document associated.

      This ammount is a carry forwards from the year before into period 001.2009, but without document. Is not until period 006.2009 that a document is posted to the account 129000 with the ammount I would need to see in period 001.2009.

      Let me explain again the issue in order to see if you or somebody else can help me.

      We have in the balance sheet of R3 an ammount of 100 (for example) in the calculated node which represents the total result of the company for year 2008. This calculated node is part of the Balance Sheet and P&L hierarchy (0GLACCEXT infoobject). This is, in period 016.2008 we had an accu

      At the beginning of the new year (2009) the ammount of 100 (amount of the calculated node) is carried forward to period 001.2009 without having a document behind since it hasn't been assigned yet. It is not until 006.2009 that the company assigns this ammount of 100 to a certain document and appears then in table BSEG.

      What they see in R3 and what they need to see in BW is this carry forward of 100 from the calculated node of the hierarchy at the end of 2008 to the account node 129000 in period 001.2009 (although no document has been assigned to yet).

      Is there any way to show this, this is a standard function in R3 and thus I believe in BW should be a way to show it the same way.

      This is a reason why I believe extractor 0FI_GL_4 is not going to work, because this extractor extracts line items with a document behing (BSEG).

      Any idea????

      Thanks in advance for any advice, idea or help!!!!!!

      Best regards,

      Cecilia

  • avatar image
    Former Member
    Jul 21, 2009 at 11:11 AM

    Cecilia

    I wasn't familiar with report RFBILA00 but, when I ran the program RFBILA00 via (SE38) the resulting screen was a Financial Statement standard transaction. When I input restrictions on this transaction for COA, GL Account, Company Code and Financial Statement Version the results (for us) were nonsense. However, instead of accessing the transaction through (SE38) why not access directly using S_ALR_87012284; using the same restrictions here returns a result set that can be reconciled back to a number of other transactions including (FBL3N) and (FBL5N)? Or am I misunderstanding your question?

    You may then use standard out of the box extractor 0FI_GL_4 , ODS 0FI_GL_O02 and cube 0FI_GL_C02 to ectract and load your data into BW.

    I hope this helps

    Regards

    Helen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Helen,

      Yes, program RFBILA00 is the same as the Information System S_ALR_87012284. My issue is that in this program in R3 I am able to see the Financial Statements with the correct hierarchy and the correct amounts. I would like to see the same in BW.

      I already updated 0FI_GL_4 into cube 0FIGL_C10 and thus 0FIGL_V10. But the issue is that there is an account 129000 (profit & loss for the year before) which the amount that appears in R3 in the S_ALR_87012284 for 2009 does not appear in BW since there is no journal for this in R3 until year end processign happens - and even then the posting is made to period 001 of the new year 2009.

      BW is not dragging the amount from 2008 to 2009, and I don't know if this is due because we are using 0FI_GL_4 extractor and it is a line item extractor (the amount dragged to this account doesn't have a document associated with it).

      Thanks again!!

      Cecilia

  • avatar image
    Former Member
    Jul 21, 2009 at 03:02 PM

    Hi Cecilia

    Try Dennis' suggestions if you're on ECC 6 ( we're currently on ECC 5 ) there's obviously a few changes to FI with the available EHP3 plug in.

    I guess you could try creating a view via (SE11) as a datasource, using the identified source fileds fields you have.

    Good luck

    Helen

    Add comment
    10|10000 characters needed characters exceeded