Skip to Content
0

0FI_GL_4 Cumulative balance and period 00 data

Sep 19, 2017 at 10:50 AM

124

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Sep 19, 2017 at 11:18 AM
0

0FI_GL_10?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

Thanks for your response.

0FI_GL_10 I think is for new GL and it pulls data from FAGLFLEXT and ours is a classic ledger which pulls data from GLT0.

Thanks and Regards,

Vijay

0

Yes, I was talking about new GL...

Looks like you have to perform transformations to some intermidiate cube...

0

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

0