Dump in select querry

[Former Member]

Can any one help me with this issue?

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"XTAB_SELECT_SALES" "(FORM)"

The reason for the exception is:

The SQL statement generated from the SAP Open SQL Statement violates a

restriction imposed by the database system used in R/3.

Possible errors:

o The maximum size of an SQL statement has been exceeded.

o The statement contains too many input variables.

o The space needed for the input data exceeds the available memory.

o ...

Prem

[Former Member]

Can any one help me with this issue?

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"XTAB_SELECT_SALES" "(FORM)"

The reason for the exception is:

The SQL statement generated from the SAP Open SQL Statement violates a

restriction imposed by the database system used in R/3.

Possible errors:

o The maximum size of an SQL statement has been exceeded.

o The statement contains too many input variables.

o The space needed for the input data exceeds the available memory.

o ...

Prem

[Sm1tje]

The explanation of the dump seems quite clear. So if anyone would be able to answer it, it would be you. Otherwise, be so kind as to provide some additional info like program name (custom or standard), the actual select statement and anything that in anyway would be helpful.

[Former Member]

Hi Prem,

Could you please share the SQL statement and other details with it?

Regards,

Anand.

[Former Member]

Hi Prem,

The error because the select query list of value and Internal Table is mismatch

Check it both both sould have smiliar structure and sequence

reagrds

Nilesh

[Former Member]

Hi,

The error coming in your query is coming may be because of

number and sequence of fields in the select query and in the internal table

used does not match.Their number and sequence must be equal .

Hope it helps

Regards

Mansi

[p604431]

Hi,

Probably in this the input condition in your select stamtent (i.e) select-option fields or internal table whichever using in the where condition contains huge data to compare and fetch details in the select statement.

[Former Member]

Hi,

Can you share your internal table structure and select statement here.

thanks.

[Former Member]

Hi everyone the problem has been solved. Thank you all for your suggestions