topic Re: Database table going to short dump in Application Development and Automation Discussions

Database table going to short dump

Former Member — Fri, 03 Oct 2008 11:14:10 GMT

Hi Friends,

When I am executing a database table BSEG for a particular set of input data it is going to short dump due to a

'LONG-TIME'.

There is a program which uses the table BSEG as data source in its select query and the execution of this program also goes to short dump for the same input data which is used in the database table BSEG.This short dump occurs at SELECT query itself.

Can you people please help me out by telling me, how to retrieve data from the database table for this given set of input in the program which uses the select statement.

Is it possible to retrieve data from the table by using any special select statement.

Please inform me as soon as possible.

Have a nice day!

Thanks & Regards.

Re: Database table going to short dump

Former Member — Fri, 03 Oct 2008 11:18:42 GMT

Hi,

BSEG is a cluster table of BSID,BSADBSIK,BSAK etc, hence you cannot use select-for all entries...

Try to go ahead with the individual transaparent tables BSID,BSAD,BSIK,BSAK...etc...

or use select-end select..

Select ......

from BKPF

......

Select ....

from BSEG...

.......

endselect " BSEG

endselect " BKPF

Hope this solves the data retrival and timeout

Regards

Shiva

Re: Database table going to short dump

digvijay_rai — Tue, 07 Oct 2008 04:30:25 GMT

hi ,

try to adjust the table with the tcode SE14 , Adjust it then again try to retrieve record .

regards

Digvijay rai

Re: Database table going to short dump

Former Member — Tue, 07 Oct 2008 04:32:37 GMT

what is the dump actually you are getting..?

Re: Database table going to short dump

christine_evans — Wed, 15 Oct 2008 12:37:22 GMT


> hi ,
> 
> try to adjust the table with the tcode SE14 , Adjust it then again try to retrieve record .
> 
> 
> regards
> Digvijay rai

No, don't try to do this with BSEG.....

Re: Database table going to short dump

Former Member — Wed, 15 Oct 2008 13:17:57 GMT

Did you enter the key field combination (along with the particular set of input data) when checking for entries in BSEG table.

Regards,

Dwaraka.S