AnsweredAssumed Answered

Need some advice for organizational hierarchy.

Question asked by gilbro on Mar 31, 2015
Latest reply on Apr 1, 2015 by bigtom

Hi all,

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 nameLevel1nameLevel1numberLevel2nameLevel2numberLevel3nameLevel3numberStructural Group NumberWork title
PaulPresidency10001President
MaryPresidency1000Vice-Presidency Finance20002V-P
CarlPresidency1000Vice-Presidency Finance2000Direction of commercial accounts30003Director
Sophia
Presidency
1000Vice-Presidency Finance2000Direction of commercial accounts30003Secretary

Outcomes