Regarding Table

[sreeramkumar_madisetty]

Hi Dudes

In which table I can get the fields Employee Id and Supervisor etc.

Regards,

Sreeram

[Former Member]

Hi,

You search in the table HRP1001 (orgn related)

for the employee and his supervisor.

Basicallly based on the relationship between these two you have to fecth using the relationship.

reward if useful

regards,

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

hi,

use HRP1001 table to get supervisor position for a given employee id.

Get Supervisor Positionin the field HRP1001-SOBID, for given employee positionin the field HRP1001-OBJID through the relation HRP1001-RSIGN eq 'A' and Relationship HRP1001-RELAT eq '002'

Reward points if useful

[Former Member]

Hi..,

HRP1000... is the Master table for each JOB and Position...

PA0000 is the master table for employees..

In PA0000 u can get the employee id with active status ...

With this find the superior's position from PA0001 table,by giving the relation Bottom Up...

HRP1001 is the table for Relation between different positions and employees...

Now with the position you got from PA0001 find the Holder of this Position from HRP1001 table.. by maintaining the relation Top to Bottom...

reward all helpful answers,

sai ramesh

[sreeramkumar_madisetty]

Hi

It's Answered.