Skip to Content
author's profile photo Former Member
Former Member

0FI_GL_1 and 0FI_GL_4

Hi Everyone,

We are currently loading with 0FI_GL_1. We now realize we need the cumulated balance at a plant level for specific GL Accounts. 0FI_GL_1 does not have plant, but 0FI_FL_4 does. Problem is GL_1 has cumulated balance and GL_4 does not. I noticed that GL_1 reads from table GLT0 while GL_4 reads from BSEG. The documentation states GL_1 is for transaction while GL_4 is direct line items.

Comparing extracted data from GL_1 and GL_4...none of the data matches.

Any ideas on the above?

Thanks, Mark.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2007 at 06:32 PM

    it doesnt match because in GLT0 you do have a cumulated balance and B_SEG has period end balance. If you add up the numbers from the opening balance to the current period end balance numbers would match.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      yeah thats correct - get the opening balance from GLT0 and going forward get the period end balances from GL4. And on the reporting stand point you can always cumulate the balance just the way Anil has told you ... restrict it with # to posting period.. that would give u the cumulative balance.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2007 at 06:28 PM

    Hi,

    Check the cube 0PCA_C01 is helpful to you here.

    http://help.sap.com/saphelp_nw2004s/helpdata/en/ff/686a373638445ce10000009b38f842/frameset.htm

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 06:01 PM

    Hi Anil and Voodi,

    A follow up:

    First, when I load FIGL_C01 by period 2006000 it brings 0 records?

    Second, having FIGL_C01 loaded (which has cumulative balance) and having FIGL_O02 loaded (line item), my debit's and credit's match perfect in both targets, but if I perform debit - credit in my ODS it doesn't match the balance in my Cube. debit - credit in my ods matches my debit/credit amount in my ods.

    How is the cumulative balance calculated in the cube FIGL_C01?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.