Create a report to export an excel table of the generic roles

Hello everybody,

We are building a process repository designed to maintain generic roles for SAP. The structure is simple :

• In each EPC we have linked each SAP fonction to a person type ;
• Assigned to the SAP fonctions, we have a function allocation diagram with the transactions linked to the related SAP fonction.
• In the organization view, we have in an organizational chart, the map of the different generic roles : position type linked to the different person types.

I tried to create a WYSIWYG report to export in a single excel spreadsheet the tree of the generic roles :

Position type - person type - SAP fonction - transactions.



It seems that it is not possible with a WYSIWYG report. In the other hand, i did not found any report giving to me this type of report.



Could you please show me the good way to prepare the correct script (I am still a beginner in java scripting..)



In advance thank you very much,

Bruno