field linkage

[Former Member]

Hi Friends,

Pls inform me which field/fields link between tables HRP1222 & PA0001(HR).Can we link pa0001-pernr

in HRP1222 table?.

Thanks in advance.

[Former Member]

anybody pls reply

[Former Member]

Hi,

OTYPE in these two tables matches so you can get the records from otype and get the pernr from pa0001...

and even subty field matches

The main field which can help you is SEQNR which is there in both the tables,...

use inner join and on these fields given above and you can get the pernr.

Regards,

Siddarth

[Former Member]

Hi Hosmath,

Check below

HRP12220-OTYPE = PA0001-OTYPE

HRP12220-SEQNR = PA0001-SEQNR

HRP12220-BEGDA = PA0001-BEGDA

HRP12220-ENDDA = PA0001-ENDDA

hope it helps you.

thanks!