Cannot fetch data from Select Query

[former_member391452]

Hi,

I am developing a simple BSP application in which I am using a simple select query like:

DATA: gt_zemp TYPE TABLE OF zemp_detail.
FREE: gt_zemp[].
SELECT * FROM zemp_detail INTO TABLE gt_zemp.

The table ZEMP_DETAIL has 3 entries but I am still getting SY-SUBRC = 4 and the GT_ZEMP is not getting filled. But when I am executing the same query in a demo report GT_ZEMP is getting filled.

The table ZEMP_DETAIL has TMG and and there is no restriction on this table.

Can anyone please help me where I am doing wrong?

[former_member185414]

What purpose does free statement serve ? Its not needed just after declaration.

[bhagaban_pradhan2]

Hi Subhajit,

DATA: gt_zemp TYPETABLEOF zemp_detail.

FREE: gt_zemp[].

SELECT*FROM zemp_detail INTOTABLE gt_zemp.

instead of Free write refresh.

i.e REFRESH : gt_zemp[].

Regards,

Bhagaban.P

[Sandra_Rossi]

and also useless right before SELECT ... INTO TABLE ...

[Sandra_Rossi]

Maybe you have run the program from the wrong client (mandant)?