I'm trying to figure out what is the best way to represent the hierarchy of the organization in my employees data table that will make it easy to build reports.
I saw some examples where we only see the employee number related to their manager number, which i don't find it useful when trying to make reports to all organizational levels (Vice-presidencies; Directions, Departments; Groups of employees...)
So, as i know that SAP can generate reports for all levels as shown below, I thought it would be more simple to enter every organizational level (name and number) for each employee record. What do you think would be the best practice?
|Employee first name||Level1name||Level1number||Level2name||Level2number||Level3name||Level3number||Structural Group Number||Work title|
|Carl||Presidency||1000||Vice-Presidency Finance||2000||Direction of commercial accounts||3000||3||Director|
|Sophia||1000||Vice-Presidency Finance||2000||Direction of commercial accounts||3000||3||Secretary|