topic Re: Cannot fetch data from Select Query in Application Development and Automation Discussions

Cannot fetch data from Select Query

Former Member — Mon, 25 Dec 2017 11:46:24 GMT

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?

Re: Cannot fetch data from Select Query

Ankit_Maskara — Tue, 26 Dec 2017 03:46:58 GMT

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

Re: Cannot fetch data from Select Query

Former Member — Tue, 26 Dec 2017 06:17:09 GMT

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

Re: Cannot fetch data from Select Query

Sandra_Rossi — Tue, 26 Dec 2017 10:47:28 GMT

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

Re: Cannot fetch data from Select Query

Sandra_Rossi — Tue, 26 Dec 2017 10:48:12 GMT

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