topic Re: Select single problem in Application Development and Automation Discussions

Select single problem

Former Member — Tue, 09 Dec 2008 19:05:02 GMT

Hi,

I have a problem with a select single statement:

select single * from PA0001 where pernr = wa-pernr.
if sy-subrc <> 0.
  do something
endif.

I always get the syntax error "A target error must be declared either explicity with an INTO clause or implicity with a TABLES statement."

Does anybody have an idea what the problem is?

Thanks and regards,

Martin

Re: Select single problem

former_member194669 — Tue, 09 Dec 2008 19:13:53 GMT

Try this way


Tables : PA0001.
select single * from PA0001 where pernr = wa-pernr.
if sy-subrc  0.
  do something
endif.

Re: Select single problem

devendran_krishnan — Tue, 09 Dec 2008 19:18:23 GMT

Hi Martin,

When you try to use any select statement there should be a into clause in case if your using tables declaration it would consider the table as a workarea by default and will not throw a synatx error.

Try the below logic.

Report zxyz_123.

tables: pa0001.

select single * from pa0001 where pernr = '000156784'.

if sy-subrc = 0.

endif.

cheers,

Devendran

Re: Select single problem

Former Member — Tue, 09 Dec 2008 19:21:45 GMT

Hi ,

define work area for PA0001 with keyword Tables.

In select statement use 'INTO PA0001'.

then you can use work area PA0001 "to perform someting".

Try below code.

Tables: PA0001.

data: wa_pernr TYPE PA0001-PERNR.

parameters: p_pernr.

wa_pernr = p_pernr.

select single * from PA0001 INTO PA0001 where pernr = wa_pernr.

if sy-subrc = 0.

do something ( here you can use work are fields as per your requirement e.g. PA0001-PERNR, PA0001-SUBTY).

endif.

Re: Select single problem

I355602 — Wed, 10 Dec 2008 03:59:38 GMT

Hi Martin Fischer,

To fetch records from DB and perform some action on it, first you need to move the records either in an internal table(for more than one records) or in a work area(for a single record.)

Use this code:-


REPORT  zxy_abc.

*--------------------Type Declaration----------------------*
TYPES : BEGIN OF it, 
        pernr TYPE pa0001-pernr,
        subty TYPE pa0001-subty,
        objps TYPE pa0001-objps,
        END OF it.
*--------------------Data Declaration----------------------*
DATA : wa_pa0001 TYPE it. "Work Area for type it
*--------------------Query---------------------------------*
START-OF-SELECTION.

SELECT SINGLE * FROM pa0001
INTO wa_pa0001
WHERE pernr = wa_pa0001-pernr.

IF sy-subrc EQ 0.
*code
*use these fields by wa_pa0001-pernr and so on..
ENDIF.

Hope this solves your problem.

Thanks & Regards.

Tarun Gambhir.

Re: Select single problem

Former Member — Wed, 10 Dec 2008 04:13:09 GMT

Hi Martin,

Use the below query.


Tables: PA0001.
data: wa_pa0001 type pa0001.

select single * into wa_pa0001 from PA0001 where pernr = wa-pernr.
if sy-subrc  0.
  do something
endif.

Thanks,

Chidanand

Re: Select single problem

Former Member — Wed, 10 Dec 2008 04:19:15 GMT

Hello,

Select Query is correct ;

check out with wa-pernr. Is it wa_pernr or wa-pernr. ?

Else try to use the into clause as :

SELECT SINGLE * FROM pa0001

into wrk_area

WHERE pernr = wa_pernr.

Thanks.

Re: Select single problem

Former Member — Wed, 10 Dec 2008 04:39:26 GMT

Either use explicit work area using into clause or use the TABLES command to decalre implicit work area..