SAP Query

[Former Member]

Hi

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

[Former Member]

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.

[andreas_mann3]

analyse query with tcode SQ02, especially additional codings!

A.

[Former Member]

Thanks Andreas.

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

[former_member201275]

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.