topic Re: SAP Query - how to retrieve data within another program / FM in Application Development and Automation Discussions

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

Former Member — Wed, 23 Jun 2010 09:13:33 GMT

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

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

Former Member — Wed, 23 Jun 2010 09:19:50 GMT

Hi Juraj ,

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

Regards,

Uma Dave

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

Former Member — Wed, 23 Jun 2010 09:33:42 GMT

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

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

Former Member — Wed, 23 Jun 2010 09:35:49 GMT

Ohhh okeyy ,

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

Why don't you try SUBMIT.

Regards,

Uma Dave

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

Former Member — Wed, 23 Jun 2010 09:42:18 GMT

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

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

Former Member — Wed, 23 Jun 2010 09:45:23 GMT

are you able to run that query explicitly.

Regards,

Uma

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

Former Member — Wed, 23 Jun 2010 09:47:52 GMT

what to you mean by runnig the query explicitly?

regards

Juraj

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

Former Member — Wed, 23 Jun 2010 11:32:22 GMT

Hi ,

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

Regards,

Uma Dave

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

Former Member — Wed, 23 Jun 2010 11:43:06 GMT

Hi,

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