Modifiying the Drill Down Reports !!

By Suren

This post is to simply list down some basic steps on how to modify the drill down reports that are built in SAP to reflect the Vendor and Customer balances. The report shows balances in a vertical format, but most often the clients want them in a horizontal format with the balances shown separately under each day range.

For this you simply need to do the following, however I would recommend that you first do this in a sandbox client and then try this in the production client, remember however that once the form is changed, all users would see the new horizontal form.

- Go to FKI2 if you want to change the report parameters. This is how the form would initially look like:

- Go to FKI5 to change the form. These changes can be done in the path in SPRO, under Info System under the AP/AR main node.

- Go to the “Define Form” and choose to “Change. If the client don’t want to see the Not Due and Total OI column in every time intervals then select the “Not Due” column and the “Total OI” column and go to extras “Drill down Display -> Undo Selection”. Then delete these columns from the form.

- After this just rename the date ranges to calculate the balance different for the day ranges that the clients wants to see. Finally the form would look like this:

And voila the report when generated would look like this :

That's about it. Just a few simple steps to change the form in SAP to a more readable format, and in case you want to bring back the old report format then you can overwrite this report by selecting the Environment -> Import Report, option in FKI5.

All the best !!