Skip to Content
0
Former Member
Aug 02, 2008 at 01:38 AM

Tables PA0001 and HRP1001

81 Views

Hi,

I want fetch data from hrp1001 using pernr

Present I am mapping as

HRP1001 where OTYPE = "C" and OBJID = pa0001.PLANS AND SUBYP = "B007".

I am facing problem when fetching if different pernrs have same plans in pa0001 (i,e pa0001.PLANS ).

pa0001 hrp1001

pernr plans plans sobis

1 80 80 1

2 80 80 2

3 80

present output as

getting as

1 80 1

1 80 2

expecting output as

1 80 1

1 80 2

2 80 1

2 80 2

Thanks,

Asha