topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Wed, 19 Jan 2011 12:03:51 GMT

I have one query designed by somebody else. When I see the code generated for this query is different in developmenet and production. While in dev everything is plane program, the same has been achived in production through different FM. I could not understand the reason. My question is I see there is a SELECT statement which we want to change, I want to find out is how it has been inserted into that FM because I dont see the same SELECT statement in design mode. Any clues would be helpful. I am trying to get the access key for the FM but can we avoid using access key?

Thanks in advance

Re: SAP Query

Former Member — Wed, 19 Jan 2011 13:11:41 GMT

Hi ,

you cannot write select statements in query.

You can transport the query from developemt to production or vice versa.

Just copy fron prod to development server then look for conditions and field list.

you will definately find something which is relevant.

hope this will help.

Re: SAP Query

andreas_mann3 — Wed, 19 Jan 2011 13:18:54 GMT

analyse query with tcode SQ02, especially additional codings!

Re: SAP Query

former_member201275 — Wed, 19 Jan 2011 13:24:04 GMT

Hi,

It sounds like you are new to SAP Query, here is a nice document which explains everything you need to know:

http://help.sap.com/printdocu/core/print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

regards,

Warren.

Re: SAP Query

Former Member — Thu, 20 Jan 2011 10:25:10 GMT

Thanks Andreas.

thanks all for your help, it was in additional coding.