topic Reg:Select Query in Application Development and Automation Discussions

Reg:Select Query

former_member197425 — Wed, 05 Aug 2009 09:53:15 GMT

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........

Re: Reg:Select Query

former_member209217 — Wed, 05 Aug 2009 09:58:44 GMT

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

Post ur code once.

Regards,

Lakshman.

Re: Reg:Select Query

Former Member — Wed, 05 Aug 2009 10:06:02 GMT

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

Re: Reg:Select Query

Former Member — Wed, 05 Aug 2009 10:08:48 GMT

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

Re: Reg:Select Query

Former Member — Wed, 05 Aug 2009 10:09:27 GMT

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

Re: Reg:Select Query

Former Member — Wed, 05 Aug 2009 10:16:10 GMT

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