topic Re: Error with Select in ABAP in Application Development and Automation Discussions

Error with Select in ABAP

Former Member — Tue, 09 Oct 2007 17:09:24 GMT

Hi All,

I am using the following query, zzglvstid and zzglvrole are primary keys for the table zfi_glv_notf.

Data: w_test_name type tdname-zfi_glv_notf

SELECT tdname FROM zfi_glv_notf

INTO w_text_name

WHERE zzglvstid = w_group_status

AND zzglvrole = w_role.

ENDSELECT.

When I do and extended program check it says " SELECT TDNAME HAS AN EMPTY BODY", I don't why.

Can any one help me in getting it through ...(do not want to use "#EC *)

Thanks

Re: Error with Select in ABAP

Former Member — Tue, 09 Oct 2007 17:22:27 GMT

Hi ram,

is not

Data: w_test_name type zfi_glv_notf-tdname.

???

how this table is declarated??

Regards

Allan Cristian

Re: Error with Select in ABAP

Former Member — Tue, 09 Oct 2007 17:32:27 GMT

From your SELECT it feels that TDNAME is a structure whose value you are trying to pass to a variable W_TEST_NAME. Please make correction in W_TEST_NAME declaration and it should solve your problem.

ashish

Re: Error with Select in ABAP

Former Member — Tue, 09 Oct 2007 17:38:13 GMT

First corrrect the DATA decleration...

it should be like tablename - field name

Data: w_test_name type zfi_glv_notf-tdname

SELECT tdname FROM zfi_glv_notf

INTO w_text_name

WHERE zzglvstid = w_group_status

AND zzglvrole = w_role.

ENDSELECT.

Reward Points if it is helpful.

Thanks & Regards

ilesh 24x7

Re: Error with Select in ABAP

Former Member — Tue, 09 Oct 2007 17:54:25 GMT

Why is there no code between your

SELECT tdname FROM zfi_glv_notf

INTO w_text_name

WHERE zzglvstid = w_group_status

AND zzglvrole = w_role.

*Code ????

ENDSELECT.

Re: Error with Select in ABAP

Former Member — Tue, 17 Nov 2009 16:39:52 GMT

If you're not selecting into a table, you don't need the ENDSELECT statement, but your select statement should be SELECT SINGLE

Re: Error with Select in ABAP

Former Member — Tue, 17 Nov 2009 17:07:51 GMT

Hi Ram ,

It means that body of SELECT and ENDSELECT is empty, you should have written some logic here.

Check your program again , you can replace it by SELECT or SELECT SINGLE.

Re: Error with Select in ABAP

Former Member — Tue, 17 Nov 2009 17:11:59 GMT

Check the original date of this post.

Rob