Skip to Content

Cannot fetch data from Select Query

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 26, 2017 at 10:48 AM
    -1

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

    Add comment
    10|10000 characters needed 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

    Add comment
    10|10000 characters needed characters exceeded