Error with Select in ABAP

[Former Member]

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

[Former Member]

Hi ram,

is not

Data: w_test_name type zfi_glv_notf-tdname.

???

how this table is declarated??

Regards

Allan Cristian

[Former Member]

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

[Former Member]

Hi

First corrrect the DATA decleration...

it should be like <b>tablename - field name</b>

<b>Data: w_test_name type zfi_glv_notf-tdname</b>

SELECT tdname FROM zfi_glv_notf

INTO w_text_name

WHERE zzglvstid = w_group_status

AND zzglvrole = w_role.

ENDSELECT.

<b>Reward Points if it is helpful.</b>

Thanks & Regards

ilesh 24x7

[Former Member]

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.

<b>*Code ????</b>

ENDSELECT.

[Former Member]

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

[Former Member]

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.

[Former Member]

Check the original date of this post.

Rob