Skip to Content

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

HCI DS - Data loading for Forecast / Future period


How do we load data for future periods using HCI?


We get data for KF1 @ Prod Loc Level for Current Month

P1 L1 100 2015-08-01 00:00:00

How do we populate this data for next 12 months.

I need 11 more records.

I don't want to create 11 new dataflows where I keep changing the month.

I was going through some of the predefined templates of Inventory / Demand data where I do see we get variable value for future period in preload script.

But how do we use it in postload script.



Former Member
Former Member replied

Couple of Solution for above problem:

1) As mentioned by Alecsandra, get and additional column.

     a) If data source is using FF, then create additional file with numbers from 0 to N(Forecast period)

      b) If data source is SAP system (APO / BI), we have 2 options.


          i)  Create Z table with 1 column and specify 0 to N

          ii)  Use 0CalMonth or 0CALDAY object to get 1 to 12 or 1 to 31 as a unique entry by developing split logic to get month / date. This is not the cleanest way / good design, but this also works if we dont have to develop any new Z table.

2) Enhance ABAP prog which is transported from D to Q to P for each ABAP DF.

Add logic of generating records for future. Strong documentation should be kept with project owner / stakeholder so that in case of enhancement in ABAP DF during support activities, prog is always appended with a prog which enables generating records for future months.



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