Relation between these two

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

OBJID of PA001 is related to HRP1001-SOBID

<b>reward if usefull</b>