topic Re: SY-SUBRC in Application Development and Automation Discussions

SY-SUBRC

Former Member — Sun, 15 Apr 2007 04:28:33 GMT

y shouldnt v give SY-SUBRC with in select statement..

if yes y? wat z the use??

if no y??? wat z the use??

Re: SY-SUBRC

Former Member — Sun, 15 Apr 2007 04:34:02 GMT

Hi,

Sy-subrc is used to check whether the select statement is executed successfully or not..

Meaning..

IF SY-SUBRC = 0.

***Record found.

ELSE.

***No record found..

ENDIF

Thanks,

Naren

Re: SY-SUBRC

Former Member — Sun, 15 Apr 2007 04:39:04 GMT

Hi,

What do you mean by in SELECT statement?

Are you talking between SELECT and ENDSELECT? Between SELECT and END SELECT sy-subrc is always 0. Because if your code between SELECT .... ENDSELECT is being executed, that means that the record found in database. And if record found in database than sy-subrc = 0.

Let me know if you have any question.

Regards,

Re: SY-SUBRC

Former Member — Sun, 15 Apr 2007 04:40:51 GMT

chk this

This is because, only if the condition given (in WHERE) in the SELECT statement is true then only it will go inside the SELECT ...ENDSELECT.

In below select if there is an entry for the plant in p_werks in the table T001W then only the control will go inside. That means inside this SELECT ...ENDSELECT the value of sy-subrc will be always zero.

select SINGLE * from t001w where werks = p_werks.
if ( sy-subrc eq 0 ).
move '-Plant existing in table ' to msg.
else.
move '- Plant not existing in table ' to msg.
endif

Re: SY-SUBRC

Former Member — Sun, 15 Apr 2007 10:37:16 GMT

Hi,

See if Sy-subrc = 0

success or ( you can use it accordingly)

else

not succes

http://help.sap.com/saphelp_nw2004s/helpdata/en/7b/fb96c8882811d295a90000e8353423/frameset.htm

regards

Chilla

Re: SY-SUBRC

Former Member — Sun, 15 Apr 2007 11:17:59 GMT

Hi,

As Select EndSelect is generally used to fetch a lot of records and if inside it we use if sy-subrc = 0. then it will consume precious database time during which the table is locked for use.Hence it is unadvisable to use sy-subrc inside Select Endselect.

U can either use 'Select into Table' for the same along with 'Where' as the criteria.

Award Suitable points for all the useful answers.

cheers.

ashish.

Re: SY-SUBRC

Former Member — Mon, 16 Apr 2007 05:35:52 GMT

Sy-Subrc = 0 means records found as per the select statement. If sy-subrc is not equal to 0 then no records are found.

If you want to know how many records it selected, check sy-dbcnt. if a select statement finds 60 records in a table then sy-dbcnt = 60.

I guess this is helpful

Re: SY-SUBRC

Former Member — Mon, 16 Apr 2007 05:48:42 GMT

Hi..

SELECTsets SY-SUBRC to 0 if at least one row was read, otherwise 4 or even 8 with SELECT SINGLE FOR UPDATE.

so you can use the sy-subrc to check weather the select statement has retrieved any data from the data base or not.

see the following example.

parameters g_matnt type mara-matnr.

select single matnr from mara into g_matnr where matnr = g_matnr.

at selection-screen.

if sy-subrc ne 0.

message 'Invalid material ' Type 'E'.

Endif.

Reward points if useful......

Suresh......

Re: SY-SUBRC

Former Member — Mon, 16 Apr 2007 06:17:56 GMT

Hi Kota,

As a rule, if SY-SUBRC = 0, the statement was executed

successfully.SELECT sets SY-SUBRC to 0 for every pass by

value to an abap data object ,Otherwise to 4 if the result set is

empty, Possibly 8 in SELECT SINGLE FOR UPDATE without the

primary key being specified after where clause, Else 12 for warning

message.

Conclusion:

sy-subrc would matter only if you give inside a nested select statement

Else it must be declared out for observing the stated rules above...

Thanks and regards,

Dhayanandh .S

Re: SY-SUBRC

Former Member — Tue, 17 Apr 2007 05:37:43 GMT

hiii

Sy-subrc is used to check whether the query in the select statement is executrd or not.If sy-subrc is 0 then select query is successfully executed .

Regards

Hitesh

Re: SY-SUBRC

Santhosh_Vellingiri — Tue, 17 Apr 2007 06:00:10 GMT

Hi kota sansy

SY in general means system variables. SUBRC is used to check whether the previous statement was executed successfully. If subrc is 0 means it was successful. It is used within the select statement to check whether some data have been selected using that select statement.

Regards

Santhosh Kumar .V