Infoset Query

[jogeswararao_kavala]

Dear Experts,

I am getting a dump when the number of values exceed 9999 in the multiple selection (EQUNR) in the selection screen

(of an infoset query using logical database.)

Pl. guide.

kind regards

Jogeswara Rao

[Former Member]

Hi Jogeswara Rao,

This is a common limitation. You are exceeding the maximum allowed query length. Let me explain with an example.

Suppose you have two entries on the selection screen s_equnr- eq 1 or eq 2. The open SQL select query gets converted native SQL query as  - where EQUNR = 1 or equnr = 2. Now if you enter 9999 values the query length exceeds a set limit - say 20000 characters. It is fixed length for a system - May be BASIS can increase it - Not sure. This can happen for any field. Just that if you use a smaller field like vbeln (10 chars) you can may be enter a couple of thousand more. Hope that makes sense.

Regards,

Shravan

[jogeswararao_kavala]

Thank you for explaining.

Regards

Jogeswara Rao