Skip to Content
avatar image
Vijay Matlani

0FI_GL_4 Cumulative balance and period 00 data

Sep 19, 2017 at 10:50 AM | 152 Views

Hi Experts,

We are implementing the BPC 10.1 and source of the data is ECC 6.0 (Classic).

As there is no trading partner field in GLT0 we opted for 0FI_GL_4 extractor to pull the data from BSEG table.

Now the issue is in BPC we need cumulative balance for Trial Balance and that should include carry forward balance also.

From Totals extractor(0FI_GL_6 or 1 ) we would have got that information but due to VBUND field not available we opted for line item extractor.

Can you please provide the suggestions as to how to overcome this issue?

Thanks and Regards,

VM

BW (SAP Business Warehouse)
SAP Business Planning and Consolidation, version for SAP NetWeaver
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Vadim Kalinin
    Sep 19, 2017 at 11:18 AM

    0FI_GL_10?

    Add comment
    10|10000 characters needed characters exceeded

    • Vijay Matlani
      Sep 21, 2017 at 08:57 AM

      Hi Vadim,

      We are taking 0FI_GL_4 for extracting the data but the problem is balance carry forward data and cumulative balance.

      We have written a ABAP code for cumulative balance and it seems it is working but the problem is Period 00 data.

      As we are pulling the data for last 5 years into system there has to be some data in Period 00 to have the correct data in Period 1 and so on.

      Thanks and Regards,

      Vijay