Internal table no data.

[Former Member]

Hi Guys,

I was no able to get the data from SAP into my Internal table.I wrote select statement like this

" SELECT *

into Table il_bkpf_header

from BKPF

where ( CPUDT > wa_init_date OR

UPDDT > wa_init_date ). "

Thanks,

Gopi.

[Former Member]

Hi,

What is the value of WA_INIT_DATE??

ALso check in SE16 for the table BKPF..to see if there is any records for the given conditions..

Thanks

Naren

[Former Member]

Hi narendra,

When i am running wa_init_date contains '00000000' value.

Thanks,

Gopi.

[Former Member]

Hi Gopi,

Goto SE16 and in table BKPF see if the data is there for the dates you are giving. If there is no data in table then you will not get in select query.

Reward points if useful.

Regards,

Atish

[Former Member]

Hi Guys,

OOPS....... there is no data in SAP .

Thanks,

Gopi.

[Former Member]

Hi Gopi,

Then reward points to all helpful answers and close the thread :).

Regards,

Atish

[Former Member]

look at the data in SE16 with condition ( mentioned in where clause ),if data is available ,then problem at query..

Let me know what condition do you want to get the data

Gopi - Personal suggestion ..

You are not assigning any reward points even you get answer,if you get answer ,keep reward points..

[Former Member]

Hi,

Also check if there is any record in the table by using SE16..

One more thing..The SQL that you are planning to use will create performance..Also make sure you use one of the index in the table BKPF..

Thanks

Naren

[Former Member]

thanks Guys