Hello Experts,
I need some advice from an expert or anyone with BADI experience.
I have to run a report that calculates an accrual value based on a future date. This requires me to use a virtual key figure and calculate it dynamically when the query is executed. The query needs to pull information from an InfoCube and DSO based on a specific Input value.
The virtual key figure lies in the DSO but relies on information queried from the infocube for the calculation below:
Given a calendar date, the program would query DSO and pull accrual information. Then, the program needs to take the date and query the Infocube (Headcount/actions) and pull all actions within the calendar year and their respective dates.
Do I need to create a FM that queries both the Infocube and DSO or could I do this in the Compute Method itself?
The part of the code I'm confused about is bringing in the Variable Input Parameters and utilizing this as a filter criteria when retrieving data from the infocube, then storing this information to be used in the KF calculation.
Does anyone have BADI code that is similar they could provide? Or provide some insight on how to implement the above criteria?
Points will be awarded for any relevant responses. Thanks in Advance!
-DC