SAP Query - how to retrieve data within another program / FM

[Former Member]

Hi,

I need to retrieve data from SAP Query, but when I used SUBMIT ..., the program results dump, because it is called within open custor loop.

Is there any another way, some FM or sth else?

thanks

Juraj

[Former Member]

Hi,

I need to retrieve data from SAP Query, but when I used SUBMIT ..., the program results dump, because it is called within open custor loop.

Is there any another way, some FM or sth else?

thanks

Juraj

[Former Member]

Hi Juraj ,

Plesae explain "retrieve data from SAP Query" what does it mean.

Regards,

Uma Dave

[Former Member]

Hi,

I think of getting data from SAP Query according to parameters for processing within program or FM.

I found FM IQAPI_QCALL_EXTR, but I'm not familiar with it

thanks

Juraj

[Former Member]

Ohhh okeyy ,

You mean you want to execute a SAP Query within another program.

Why don't you try SUBMIT.

Regards,

Uma Dave

[Former Member]

I already tried it, but I always get dump with CX_SY_OPEN_SQL_DB exception.

The problem is, that I tried to execute the query within open custor loop and this exception is caused by calling commit work somewhere in query report.

therefore I try to find another way

thanks

Juraj

[Former Member]

are you able to run that query explicitly.

Regards,

Uma

[Former Member]

what to you mean by runnig the query explicitly?

regards

Juraj

[Former Member]

Hi ,

for that SAP Query you can have a report createde from SQ01 and run that report and see what happens.

Regards,

Uma Dave

[Former Member]

Hi,

I already have seen it ... I get dump ... I found generated report for query and run it explicitly via SUBMIT ... AND RETURN statement