topic Re: problem in select in Application Development and Automation Discussions

problem in select

Former Member — Mon, 11 Aug 2008 11:46:06 GMT

Hi,

i have question:

what is the problem with this select.

select * from hrp1000

if sy-subrc is initial.

write'....'

endif.

Regards

Re: problem in select

Former Member — Mon, 11 Aug 2008 11:51:29 GMT

HI,

Ricardo has written-


select * from hrp1000
if sy-subrc is initial.
write'....'
endif.

In this case you are selecting the records from table but not mentioning where to store that records, Thats why the problem occur.

You have to mention INTO Clause and the internal table name to store selected data.

like below-



data: itab type table of hrp1000.

select * from hrp1000 into table itab.
if sy-subrc = 0.
write'....'.
endif.

Here itab is the internal table of the type hrp1000.

Regards,

Sujit

Re: problem in select

naveen_inuganti2 — Mon, 11 Aug 2008 11:53:57 GMT

Hi....

There is no target area...

Declare one target variable.

use open cursor statement.

The correct similer statements are...

>select * from hrp1000 into corresponding fields of table itab.

>(here iatb with some fields of hrp1000)

>open cursor znav for select * from hrp1000.

>(here znav type cursor)

Thanks,

Naveen Inuganti.

Re: problem in select

Former Member — Mon, 11 Aug 2008 11:54:28 GMT

U have to write select statement:

Either:

select * from hrp1000

if sy-subrc is initial.

write'....'

endif.

endselect.

OR:

select single * from hrp1000

if sy-subrc is initial.

write'....'

endif.

Re: problem in select

Former Member — Mon, 11 Aug 2008 12:00:16 GMT

Hello Ricardo,

If you don't use into clause then you should write ENDSELECT

after select.

Use select single.

These two are allowed only if work area hrp1000 is available.

Regards,

Subbu

Re: problem in select

naveen_inuganti2 — Mon, 11 Aug 2008 12:01:09 GMT

Hi.. Chandra...

What about the target area.??

Thanks,

Naveen Inuganti.

Re: problem in select

Former Member — Mon, 11 Aug 2008 12:01:18 GMT

Hi ,

Thanks ,

u think that into is the problem ,

what about sy-subrc it can be initial or just get 0 4 8 .?

Regards

Re: problem in select

Former Member — Mon, 11 Aug 2008 12:01:24 GMT

Hi,

U can do like this also.


Tables hrp1000.

select * from hrp1000.
  if sy-subrc is initial.
    write'....'
  endif.
endselect.

Regards,

Sunil Kumar M

Re: problem in select

former_member787646 — Mon, 11 Aug 2008 12:02:49 GMT

In your SQL the INTO clause is missing.

i.e, Where you want to save the fetched data which is a variable or work area or internal table?

select * from hrp1000 into wa.

if sy-subrc <> 0.

write'....'

endif.

select * from hrp1000 into table itab.

if sy-subrc <> 0.

write'....'

endif.

Hope it helps.

Murthy

select * from hrp1000

if sy-subrc is initial.

write'....'

endif.

Re: problem in select

Former Member — Mon, 11 Aug 2008 12:03:17 GMT

hi chandra madapati ,

sorry but the select is like that:

select * from hrp1000
if sy-subrc is initial.
write'....'
endif.
endselect.

Regards

Re: problem in select

former_member206439 — Mon, 11 Aug 2008 12:07:58 GMT

The main problem is you need to use INTO some internal table or work area.

you write a select statment with out where condition but needs a target location to store that results.

like this

select * from HRP1001 into table itab1.

in this case the total table values will be stored at itab1.

Regards

Naresh

Re: problem in select

former_member206439 — Mon, 11 Aug 2008 12:23:47 GMT

select * from hrp1000

if sy-subrc is initial.

write'....'

endif.

endselect.

in this condition.

sy-subrc value won't be ZERO.

that means it failed to get that data.

always SY-SUBRC is equal to ZERO only when above statement is correct other wise it will give 1 or 4 or 8 values

any thing you want from this.

Re: problem in select

Former Member — Mon, 11 Aug 2008 15:07:02 GMT

hi,

it wont be infinite loop?

Regards

Re: problem in select

Former Member — Mon, 11 Aug 2008 17:56:16 GMT

solved