select statment

[Former Member]

hi all,

i want to retrieve the pernr(field) from pa0000 and pa0105 tables. condition is, in table pa0105 some pernr linked with usrid, except this pernr i want to retrieve all the pernr.

pls suggest me,

best regards,

ashok reddy.

[Former Member]

hi,

do this way ...

    select pernr from pa0105 into table it_pa0105
      where  usrid ne uname.
    if sy-subrc <> 0.
    endif.
   
  if not it_pa0105[] is initial.
* Get data for the specified Pernr
    select * from pa0000 into table it_pa0000
      for all entries in it_pa0105
      where pernr = it_pa0105-pernr.
    if sy-subrc = 0.
      sort it_pa0000 .
    endif.
  endif.    

[Former Member]

ya santoish is wright .

KinDlY LET ME KNOW IF U REQUIRE performa oriented kindly let me knwo

Regards

sas