topic Re: Regarding Table in Application Development and Automation Discussions

Regarding Table

sreeramkumar_madisetty — Thu, 12 Apr 2007 05:29:55 GMT

Hi Dudes

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

Regards,

Sreeram

Re: Regarding Table

Former Member — Thu, 12 Apr 2007 05:33:15 GMT

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

Re: Regarding Table

Former Member — Thu, 12 Apr 2007 05:38:29 GMT

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

Re: Regarding Table

Former Member — Thu, 12 Apr 2007 05:38:45 GMT

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

Re: Regarding Table

sreeramkumar_madisetty — Wed, 23 May 2007 07:49:56 GMT

It's Answered.