topic Re: Submit Statement in Application Development and Automation Discussions

Submit Statement

Former Member — Mon, 15 Dec 2008 09:45:43 GMT

Hi All,

I have written a report, which calls another report.

Eq:- I have report Program1 which has company code as a selection screen.

First it fetches all the PO doc's from EKKO.

Then these PO's are passed to ME2N tcode using SUBMIT statement in my report Program1.

Currently for a given company code i have 75,000 odd recrords.

All these are pased to ME2N using "SUBMIT program with selection-table i_seltab exporting list to memory and return".

But I am getting short dump has "Error in the module RSQL accessing the database interface."

is ther any memory limit for this. for submitting the report.

Former Member — Mon, 15 Dec 2008 10:09:36 GMT

hi parveen......

The reason for the exception is:

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept

so please check the data you are passing to TCODE ME2N as right data is moving in the right column or not,,,,

Then you rproblem will be solved.

Thanks

Saurabh

Former Member — Mon, 15 Dec 2008 10:14:55 GMT

Hii

The simplest way that we can resolve it is .... to the same addition ...

place the table in the parameter id i mean set parameter and then after submitting ..retive the data using get parameter ...

and after retrieving it ..move it into the corresponding fields ...

what u have done is right ,.... however the other way of solving the issue if its ....

thanks and regards

chandu reddy sunkari

Former Member — Mon, 15 Dec 2008 10:29:17 GMT

hi ,

Do mean I need to set the parameter id for my table

i_seltab where it contains the data of PO's to which i am passing to ME2N.

and how can i use get parameter.