topic Relation between these two in Application Development and Automation Discussions

Relation between these two

Former Member — Wed, 17 Oct 2007 11:12:27 GMT

Hi,

How to link these two tables in HRP1001-SOBID and pa0001 which field is related to pa0001 field.Can yo plz give me what is the field name in pa0001. but the Otype is 'O'.Can you please let me know

Regards,

Raj.

Re: Relation between these two

Former Member — Wed, 17 Oct 2007 11:14:02 GMT

orgeh in pa0001

and objid in hrp1000/hrp1001 with otype = 'O'

select single sobid from hrp1001 into v_orgeh where objid = p_objid and sclas = 'O' and relat = '003'.

if sy-subrc = 0.

select single pernr from pa0001 into v_pernr

where orgeh = v_orgeh.

endif.

Re: Relation between these two

Former Member — Wed, 17 Oct 2007 11:19:45 GMT

Hi raj,

look here:

Regards, Dieter

the simplest way is to use SQVI wit both tables.

Regards, Dieter

Message was edited by:

Dieter Gröhn

Re: Relation between these two

Former Member — Wed, 17 Oct 2007 11:20:32 GMT

OBJID of PA001 is related to HRP1001-SOBID

<b>reward if usefull</b>