Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

field linkage

Former Member

‎2009 Apr 27 1:29 PM

0 Likes
541

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.

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.

Reply
3 REPLIES 3
Read only

Former Member

‎2009 Apr 27 1:37 PM

0 Likes
511

anybody pls reply

Read only

Former Member

‎2009 Apr 27 1:38 PM

0 Likes
511

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

Read only

Former Member

‎2009 Apr 27 1:43 PM

0 Likes
511

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!