topic Select query in Application Development and Automation Discussions

Select query

Former Member — Wed, 13 Feb 2008 13:47:24 GMT

This select query is going into dump (ABAP RUN TIME ERRORS)

please tell me weather it si correct or not

SELECT mseg_{mblnr mseg}bukrs mseg_{waers mkpf}bldat mkpf~budat

mkpf_{bktxt mkpf}frath

INTO TABLE it_header FROM mseg

INNER JOIN mkpf ON mseg_{mblnr = mkpf}mblnr

WHERE mkpf~mblnr IN s_mblnr

AND mkpf_{budat IN s_budat AND mseg}ebelp IN s_ebelp AND

mseg~lifnr IN s_lifnr.

Regards

Ajay

Edited by: ajay babu on Feb 13, 2008 3:02 PM

Edited by: ajay babu on Feb 13, 2008 3:07 PM

Former Member — Wed, 13 Feb 2008 14:04:59 GMT

Could you provide us wit text of the dump ??

I think t may be time out dump due to very large amount of data extracted from database and not efficient

'IN' operator in where condition.

Otherr possibility is that internal table 'IT_header' structure is different than seleceted fields in you selct statement

BR, Jacek

Edited by: Jacek Slowikowski on Feb 13, 2008 3:06 PM

Former Member — Wed, 13 Feb 2008 14:05:15 GMT

Hi,

What is the dump message you are getting?

Thanks,

Sriram Ponna.