07-15-2008 3:17 PM
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.
07-15-2008 3:27 PM
use this..
select pernr
perid
from pa0002
into table itab1
for all entries in itab
where perid = itab-perid.
07-15-2008 3:27 PM
use this..
select pernr
perid
from pa0002
into table itab1
for all entries in itab
where perid = itab-perid.
07-15-2008 3:30 PM
DATA: itab2 LIKE pa0002 OCCURS 0 WITH HEADER LINE.
SELECT * FROM pa0002 INTO TABLE itab2 FOR ALL ENTRIES IN itab1
WHERE perid = itab1-ssn.
07-15-2008 3:36 PM
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