Hello All.
In my application, while storing the employee details, I am storing the Approver ID which again come from the same employee table. So for displaying the data I am creating a view in ABAP Data Dictionary. But I am not able to map a table twice. How to achieve this?
Employee Table has the following fields.
EmpID, DesgID, ApprID( which inturn is a the employee id of the approver).
So now while creating the view I have to join the table with itself.
How to do that.