relation between these two

[Former Member]

Hi,

How to link these two tables in HRP1000-SOBID and pa0001 which field is related to pa0001 field.

Regards,

Raj.

[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]

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'

Regards,

Raj.

[Former Member]

Hi rac,

use SQVI with a join of these two tables an you see the related fields.

i think it', endda, begda, seqnr and otype.

But the field HRP1000-SOBID doesn't exists in bothe tables.

Regards, Dieter

[Former Member]

Hi

Link

HRP1000-OBJID with PA0001-ORGEH if HRP1000-OTYPE = 'O'

HRP1000-OBJID with PA0001-PLANS if HRP1000-OTYPE = 'S'

so based on OTYPE field of HRP1000 it is linked

Regards

Anji

[Former Member]

hi,

PA0001-SEQNR = HRP100-SEQNR

PA0001-BEGDA = HRP100-BEGDA

PA0001-ENDDA = HRP100-ENDDA

PA0001-SPRAS = HRP100-SPRAS

[amit_khare]

It depends what Object type you are loking for.If S then POSITION.

If P then PERNR.

Regards,

Amit

Reward all helpful replies.

[Former Member]

plans = position

stell = job

use these relations

plans,stell in pa0001

position and job from hrp tables

hope u got it....

to get a clear picture....

select sobid from hrp1001 into v_position where objid = p_objid and sclas = 'S' and relat = '008'.

if sy-subrc = 0.

select pernr from pa0001 into v_pernr where plans = v_position.

endif.

Message was edited by:

Vasu G