topic Re: Internal table no data. in Application Development and Automation Discussions

Internal table no data.

Former Member — Tue, 19 Jun 2007 23:52:32 GMT

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.

Re: Internal table no data.

Former Member — Tue, 19 Jun 2007 23:56:05 GMT

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

Re: Internal table no data.

Former Member — Tue, 19 Jun 2007 23:56:15 GMT

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

Re: Internal table no data.

Former Member — Tue, 19 Jun 2007 23:57:19 GMT

Hi narendra,

When i am running wa_init_date contains '00000000' value.

Thanks,

Gopi.

Re: Internal table no data.

Former Member — Tue, 19 Jun 2007 23:57:55 GMT

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

Re: Internal table no data.

Former Member — Wed, 20 Jun 2007 00:00:58 GMT

Hi Guys,

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

Thanks,

Gopi.

Re: Internal table no data.

Former Member — Wed, 20 Jun 2007 00:01:32 GMT

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

Re: Internal table no data.

Former Member — Wed, 20 Jun 2007 00:04:29 GMT

Hi Gopi,

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

Regards,

Atish

Re: Internal table no data.

Former Member — Wed, 20 Jun 2007 01:12:45 GMT

thanks Guys