Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

R/3 special ledger to BPC Data load

We are pulling data out of an R/3 special ledger for import into a BPC 5.1 application. We are pulling YTD values out of R/3 for both the IS and BS, however, the IS is not calculating the periodic values.

(i.e. for Jan we load 100, for Feb we load 200, the periodic value should be 100 we are getting 200).

Since the periodic and YTD values reside in 2 separate fields in the special ledger, how do we get BPC to calculate the periodic value so we don't have to load 2 separate files?

Former Member
Former Member replied

Hi,

An alternate way Please see the posting [Input YTD data]

Taken from the above post please use the below mentioned code

1. As one time for loading the historical data

2. Modify it to and make it a step to run it once u open the period for data load - just like carry forwarding the balances to sum up the data for the whole year (YTD number) and post it to the new period.

WHEN account.acctype
*IS "INC","EXP"
*when Time.monthnum
*is "1"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*REC(FACTOR=-1,TIME=next(6))
*REC(FACTOR=-1,TIME=next(7))
*REC(FACTOR=-1,TIME=next(8))
*REC(FACTOR=-1,TIME=next(9))
*REC(FACTOR=-1,TIME=next(10))
*REC(FACTOR=-1,TIME=next(11))
*is "2"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*REC(FACTOR=-1,TIME=next(6))
*REC(FACTOR=-1,TIME=next(7))
*REC(FACTOR=-1,TIME=next(8))
*REC(FACTOR=-1,TIME=next(9))
*REC(FACTOR=-1,TIME=next(10))
*is "3"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*REC(FACTOR=-1,TIME=next(6))
*REC(FACTOR=-1,TIME=next(7))
*REC(FACTOR=-1,TIME=next(8))
*REC(FACTOR=-1,TIME=next(9))
*is "4"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*REC(FACTOR=-1,TIME=next(6))
*REC(FACTOR=-1,TIME=next(7))
*REC(FACTOR=-1,TIME=next(8))
*is "5"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*REC(FACTOR=-1,TIME=next(6))
*REC(FACTOR=-1,TIME=next(7))
*is "6"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*REC(FACTOR=-1,TIME=next(6))
*is "7"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*REC(FACTOR=-1,TIME=next(5))
*is "8"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*REC(FACTOR=-1,TIME=next(4))
*is "9"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*REC(FACTOR=-1,TIME=next(3))
*is "10"
*REC(FACTOR=-1,TIME=next(1))
*REC(FACTOR=-1,TIME=next(2))
*is "11"
*REC(FACTOR=-1,TIME=next(1))
*endwhen
*endwhen

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question