topic Re: regarding this select statement in Application Development and Automation Discussions

regarding this select statement

Former Member — Sat, 04 Aug 2007 14:14:14 GMT

hi,

please explain this code clearly.

perform rajesh.

from rajesh.

select xxxx xxxx xxxx from table XXXX where XXXX = XXXX

exit.

endselect.

endform.

Re: regarding this select statement

Former Member — Sat, 04 Aug 2007 14:21:23 GMT

Hi,

select xxxx xxxx xxxx from table XXXX where XXXX = XXXX

exit.

endselect.

In the Where clause, if XXXX = XXXX (If these both fields are same) then the select will be exited.

Regards

Sudheer

Re: regarding this select statement

Former Member — Sat, 04 Aug 2007 14:46:37 GMT

HI,

*-- This Statement is going to call the Subroutine called rajesh

perform rajesh.

*-- This Form.. endForm is the Subroutine definition

from rajesh.

*-- Select the fields xxxx can be any fiedls from the table XXXX

where the field XXXX is equal the value in the field XXXX.

if it finds one such entry in the table then come out of the select statment no more loop into the select.

select ... endselect will select one record at a time and loops. .. here you are using exit so when this select finds one record then it will come out of the loop.

select xxxx xxxx xxxx from table XXXX where XXXX = XXXX

exit.

endselect.

endform.

Example :

tables : vbap.

*-- if the select finds an entry in vbap for sales order number 123456 then it will come out

select vbeln posrn from vbap where vbeln = '123456'.

exit.

endselect.

Thanks

Mahesh