Aging Structure of Receivables
At the time of the financial crisis in 2008 business had a very strong focus on monitoring working capital development. With the project team I have created several reports based on FI and MM data to monitor the relevant KPIs. The most challenging task was to create a time series report of the aging of customer receivables. I solved this challenge by creating a virtual cube with ABAP code in behind that can calculate the aging structure of the receivables for any key date. It calculates on the lowest possible level, so a drill-down e.g. on customer number can be added seamlessly.