Question:
Hello Everyone,
I am hoping someone can share their code logic on this.
I am getting budget data at Fiscal Period level and for analysis purposes we would like to explode it to calendar date level. Well, I know there is a function module that can get me the first and last date of a particular period but since I haven't done a whole lot of ABAP, I am having a hard time trying to figure out how to explode the data into fiscal period in the start routine. Knowing I have very little time to get this working, I would appreciate any help possible.
Kind regards,
Abaper lite.
Answer:
I recommend looking up documentation on return table. That should help you with splitting one record into multiple records. I am not sure whether this would allow you with introducing new characteristics though. Good luck and let us know which approach you took
ASQ
Answer:
check
T009B : TABLE
Answer:
CHECK" LAST_DAY_IN_PERIOD_GET"
LAST_DAY_IN_YEAR_GET
Answer:
Hey Guys,
Thanks for the info. I know how to get the first and last date of the Fiscal Period. The problem I am having is coming up with the logic of expanding the data in transfer structure to populate with this data. I'm told this can be achieved using Return table but I've never used this. Could someone provide an example with how to use Return table? Appreciate your response.
Basically this is what I was thinking:
Loop at dataset.
For each key and fiscal period.
-Get first and last date of fiscal period (using function modules)
get number of days for the date range and divide it by the key figure (budget data for instance) which should give you the value for the day
Populate the dataset with this specific value for each date
endloop.
Answer:
OK with some playing around I have been able to figure out the ABAP logic. My question now is, can I split one record into multiple records using Start routine (on the datapack) in the Update Rules or do I have to use the Return table for each Key Figure? I will also be introducing Calendar day as a new characteristics.
Appreciate your response.
Answer:
There is how to paper on this topic I don't remember the exact name but some thing like "How to Disaggregate while loading using master data" . Look in services. It is in similar lines and we did it in our earlier project in a different scenario.
Thanks.
Answer:
Hye,
What you can do is just to duplicate your update rules as many times you will neet them. If that 'many times' is fix, imagine 6 times, no problem, just click on the Icon 'Copy Rule' when creating updates rules.
If this 'many times' is variable, you have to :
- use return table for business characteristic (figure by figure on tabstrip Characteristic)
- or use time distribution for time characteristic (figure by figure on tabstrip Time ref.)
Good luck
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
Hello all,
I am told rather then using return table, I can use the start routines to split one record into multiple records. Can someone show a simple example of splitting records in Update Rule start routine?
Appreciate your response.
Answer:
Hello again everyone,
Initally the data_package had 4 records. After going through the start routine modification (to split one record into approx. 30 records) I see the data_package being updated but it doesn't exceed 4 records. Is there something I'm missing? Is the data_package table limited to the initial size of the data records?
Appreciate your response.
Answer:
did you append the "new" entries?
Answer:
Hello again everyone,
The reason why my code wasn't exceeding the 4 record limit is because I was moving the data into the wrong table. Thank you for all your help though.