Standard Query Issue.

[Former Member]

Hi All,

In Query Definition, for a query "Browse Product Category Tree view", when im trying to duplicate the query and save it then its throwing an error as :

"The Java execution type is not allowed in a custom query."

But we have a requirement to edit this query and on execution show the results directly instead of clicking on show button as the original query shows.

in help.sap documentation they say "Query Executor Class" field in query is available for standard queries only.

Can anyone throw some light on how to proceed for the requirement.

Any help would be appreciated.!

Thanks!

[vikram_shanmugasundaram]

The Execution Type Java is only available for standard queries and not for custom queries. In earlier releases, these types of queries were handled through stored procedures. You might want to try creating a stored procedure and call the stored procedure from the custom query definition.

Regards,

Vikram

[Former Member]

Hi Vikram,

We have a similar requirement now, where the query "Scorecard Report" is a java query, but we want to make changes in this query. We want to add new fields and remove few existing fields from it.

Can u pls help us with this?.

Thanks,

Shikha