regarding the dump

[Former Member]

hi,

this is my code

select a_{ebeln a}ebelp a~zspltno

a_{zstatus a}zdeltrm a~zexpdt

a_{zffcomm a}zexprem a~zexwdt

a_{zffcrdt a}zffchdt a~zvcondt

a_{zfprmdt a}zsprmdt a~zredydt

a_{zcolldt a}zrecddt a~zetddt

a_{zetadt a}zpaimdt a~zmaimdt

a_{zpermit a}zdedesc a~zdeduom

a_{zconstn a}zorgstn a~zrefnum

a_{zpackage a}erdat

a_{upddt a}uptim b~zirrcod

b_{zirridt b}zirrtim b~zirrrdt

into corresponding

fields of table it_oexp from

zexpedite as a

inner join zpoirr as b on a_{ebeln = b}ebeln

and a_{ebelp = b}ebelp

and a_{zspltno = b}zspltno where

a~ebeln in s_ebeln and

a~zexpdt in s_zexpdt and

a~zexwdt in s_zexwdt and

a~zvcondt in s_zvcndt and

a~zfprmdt in s_zfprdt and

a~zsprmdt in s_zsprdt and

a~zredydt in s_zreddt and

a~zcolldt in s_zcoldt and

a~zrecddt in s_zrecdt and

a~zetddt in s_zetddt and

a~zetadt in s_zetadt and

b~zirrcod in s_zirrcd and

b~zirridt in s_zirrdt and

b~zirrrdt in s_zirdt and

(s_string).

and s_string = 'ZEXPEDITE-ZSTATUS NE C_CONST AND ZEXPEDITE-ZEXPDT LE SY-DATUM'.

it is throwing to dump.

Please correct me.

thanks in advance

[Former Member]

Hi Surya,

remove s_string from the select query and instead,

add the below code,

<b>and

a~zstatus ne c_const

and

a~zexpdt le sy-datum.</b>

in place of

<b>and (s_string).</b>

That would resolve your problem.

<b>Reward points if this helps,</b>

Kiran S