Skip to Content
0

Cannot fetch data from Select Query

Dec 25, 2017 at 11:46 AM

63

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded

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

0

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sandra Rossi Dec 26, 2017 at 10:48 AM
-1

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 26, 2017 at 06:17 AM
-3

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

Share
10 |10000 characters needed characters left characters exceeded