topic Re: getting pernr in Application Development and Automation Discussions

getting pernr

Former Member — Tue, 15 Jul 2008 14:17:26 GMT

I have a internal table containg ssn number only,now i want to select pernr from pa0002 into an internal table comparing each ssn number from the previous internal table.Can anybody tell me the detail code.

Re: getting pernr

Former Member — Tue, 15 Jul 2008 14:27:17 GMT

use this..

select pernr

perid

from pa0002

into table itab1

for all entries in itab

where perid = itab-perid.

Re: getting pernr

Former Member — Tue, 15 Jul 2008 14:30:51 GMT



  DATA: itab2 LIKE pa0002 OCCURS 0 WITH HEADER LINE.

  SELECT * FROM pa0002 INTO TABLE itab2 FOR ALL ENTRIES IN itab1
                          WHERE  perid = itab1-ssn.

Re: getting pernr

Former Member — Tue, 15 Jul 2008 14:36:20 GMT

hi,

You can try this.

select distinct Pernr
                     perid
for all entries in itab1
into table itab2
where perid EQ itab1-ssn.

This will help you to get Distinct Pernr.

Regards

Sumit Agarwal