Reg:Select Query

[former_member197425]

Dear All,

Here i came across a peculiar problem in SELECT query my query looks like below

DATA: WA_EBAN1 TYPE EBAN.

DATA: I_EBAN TYPE TABLE OF EBAN.

SELECT * FROM EBAN INTO TABLE I_EBAN WHERE BANFN = WA_EBAN-BANFN AND BNFPO NE ''.

In wa_eban-banf i am giving the Purchase requisition number.When executing the report the data not getting populated to I_EBAN

internal table but when i keep a Break-point at the Query and then run the report data is populating into internal table. If i execute without keeping Break-pont then data is not populating in internal table...............

CAn anyone suggest how to overcome this........

[former_member209217]

Some where u might be clearing or refreshing the table after select query.

Post ur code once.

Regards,

Lakshman.

[Former Member]

Hi,

If the internal table is being populated when you keep a break-point and u dont get data without stoping at the select, you may be refreshing or clearing the internal table else where in code. check once again and ensure you are not refreshing the internal table.

Regards,

Vik

[Former Member]

Hi,

You must be clearing your internal table after the select ,may be before reading or before looping at this internal table,do check for it.

Anitha

[Former Member]

Hi,

Please check below points once.

1. Check once with break-point and without break-point same data retriving, i mean in where condition purchase requisition number.

2. Once data come into internal table, it won't go unless untill refresh the table.

Regards,

Ganeshj

[Former Member]

You can also use a write statement on the internal table immediately after the select and ensure that data is being populated without using break point and check if the output is coming properly

Regards,

Vik