topic Re: select statment in Application Development and Automation Discussions

select statment

Former Member — Fri, 11 Apr 2008 13:08:43 GMT

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.

Re: select statment

Former Member — Fri, 11 Apr 2008 13:13:49 GMT

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.

Re: select statment

Former Member — Fri, 11 Apr 2008 13:36:26 GMT

ya santoish is wright .

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

Regards

sas