topic Re: dump when using IN in select statement in Application Development and Automation Discussions

dump when using IN in select statement

Former Member — Thu, 09 Oct 2014 07:40:08 GMT

Hi All

SELECT rsnum matnr werks bdter bdmng INTO TABLE gt_bdmng

FROM resb FOR ALL ENTRIES IN gt_matnr

WHERE matnr = gt_matnr-matnr AND bdart IN (c_bdart_sb ,c_bdart_ar)

AND werks = p_werks AND XLOEK = '' AND KZEAR = ''.

c_bdart_sb = 'SB'

c_bdart_ar = 'AR'

sb and ar are declared as constants.

dump description

I am getting this dump in production,Program worked fine in development and quality.

Thanks

Vamsi

Re: dump when using IN in select statement

fredericbasilius — Thu, 09 Oct 2014 07:47:05 GMT

Hi Mohan,

Can you please share the declaration provided for the constants c_bdart_sb ,c_bdart_ar.

Regards,

Re: dump when using IN in select statement

Former Member — Thu, 09 Oct 2014 07:48:00 GMT

Hi,

Please try below:

   SELECT rsnum matnr werks bdter bdmng INTO TABLE gt_bdmng
     FROM resb FOR ALL ENTRIES IN gt_matnr
      WHERE matnr = gt_matnr-matnr AND ( bdart = c_bdart_sb or bdart = c_bdart_ar )
                                   AND werks = p_werks AND XLOEK = '' AND KZEAR = ''.

Hope it helps.

Regards,

Re: dump when using IN in select statement

former_member188724 — Thu, 09 Oct 2014 08:00:36 GMT

Hi,

Please move bdart i.e., sb & ar into ranges table(t_bdart) and use

SELECT rsnum matnr werks bdter bdmng INTO TABLE gt_bdmng

FROM resb FOR ALL ENTRIES IN gt_matnr

WHERE matnr = gt_matnr-matnr AND bdart IN t_bdart

AND werks = p_werks AND XLOEK = '' AND KZEAR = ''.

Hope it helps.

Regards,

K.S

Re: dump when using IN in select statement

Former Member — Thu, 09 Oct 2014 08:19:41 GMT

Hi,

I think the problem seems to be bdart IN (c_bdart_sb ,c_bdart_ar).

Can u check replacing it with bdart IN ('SB','AR')

A Rahim.

Re: dump when using IN in select statement

Former Member — Thu, 09 Oct 2014 08:45:32 GMT

Hi Fredric

CONSTANTS : c_bdart_sb(2) TYPE c VALUE 'SB',

c_bdart_ar(2) TYPE c VALUE 'AR',

thanks

Vamsi

Re: dump when using IN in select statement

Former Member — Thu, 09 Oct 2014 08:46:15 GMT

Hi All

changed

gr_bdart-sign = c_i .

gr_bdart-option = c_eq.

gr_bdart-low = c_bdart_sb.

Append gr_bdart.

gr_bdart-low = c_bdart_ar.

Append gr_bdart.

CLEAR gr_bdart.

SELECT rsnum matnr werks bdter bdmng INTO TABLE gt_bdmng

FROM resb FOR ALL ENTRIES IN gt_matnr

WHERE matnr = gt_matnr-matnr AND bdart IN gr_bdart

AND werks = p_werks AND xloek = '' and kzear = ''.

I need reason why it went dump with earlier query

Re: dump when using IN in select statement

Former Member — Thu, 09 Oct 2014 08:57:08 GMT

col [NOT] IN (dobj1, dobj2 ... ) ...

in supports only values not variables

like IN ('C','F','Y')

as per documentation

ABAP Keyword Documentation