SAP Query Creation - Where to do? Dev or Prd

[Former Member]

HI,

We have a two system landscape as DEV and PRD.

We want some query to be generated in PRD. So whether we have to create in DEV and then transport the report to PRD or Can i directly create query in PRD and then assign one transaction code for that?

Is there any drawback in creating Queries in PRD directly?

Please give a idea about queries.

Regards,

Lijo Joseph

Message was edited by: Linda Bortolus (just to mark the post as a question)

[Former Member]

Hello Lijo,

Since the SAP Query, in general, is only used to SELECT the data and display it, I don't think there's any drawback in creating the query in the production system.

In fact, in some cases (eg., the development environment does not have sufficient data) it might be a better idea to create a query directly in the production system.

Regards,

Anand Mandalika.

[Former Member]

Dear Anand,

Thanks for your information.

How it will effect dataload in PRD?

And what is the ideal way to do it? and how?

Thanks in advance,

Lijo Joseph

[Former Member]

Go to SQ01 and create queries in PRD as you would do in DEV. Dataload depends on what query you build at the end. For creating queries, the PRD environment is open unlike creating programs.

Regards,

Sougata.

[Former Member]

Hi Anand,

There ia a coding section in query creation SQ02.

Can anybody harm our DB with that?

Please help.

Regards

Lijo Joseph

[Former Member]

Hi Lijo,

That is precisely what I had in mind when I said that <i>"....the SAP Query, in general, is only used to SELECT the data..."</i> !!

Though the purpose of the coding section is only to enhance / customize the display, there's nothing to prevent a DELETE / MODIFY statement in there.

If you think that there is a chance that someone might access the query in the production system in change mode, then you have a major risk. But I think it is not a problem to prevent access to SQ02 in the production system. But then, the developer who writes the query (I guess that's you in this case ) should also exercise extreme caution in handling this part. NEVER use any DML statements here (DELETE / MODIFY / UPDATE).

Hope this information has been useful.

Regards,

Anand Mandalika.

[Former Member]

Dear anand,

Thank you for your valuable information. Normally who all will have SQ02 authorization? Only abap developers?

Can we restrict that code area in Authorization?

I am not able to view star icon to give you points.. i am sorry for that.

Thanks and regards,

Lijo Joseph

[nablan_umar]

Hi Lijo,

So far during my implementations with several customers, SAP query is not allowed in PRD. This is due to performance problem created by the query. If you do want to have it in PRD, my recommendation is it be given to users not Abapers. And you only give SQ01 but not SQ02 or SQ03. Let SQ02 and SQ03 setups be transported from DEV.

[Former Member]

Hi Umar,

thanks for the information.

I would like to give oints to you. how can i do it?

regards,

Lijo Joseph

[Former Member]

Hi Lijo,

I edited your original post to check the box under the message field indicating that this was a question. Then, I awarded some points on your behalf, but feel free to increase them!

See: /people/mark.finnern/blog/2004/08/10/spread-the-love for directions.

Click on the Yellow Star icon in each reply.

You can give:

1 - 10 pointer (solves problem, marks as answered)

2 - 6 pointers (very helpful)

Lots of 2 pointers (helpful)

Cheers!

Linda (and Mark Finnern)

[Former Member]

Hi Linda,

Thank you for your service. i would like to inform you that in many post i am not able to view star icon to assign points. please look in to this.

Regards,

Lijo Joseph

[balaji_viswanath]

Lijo,

Before posting the new topic, you have to select "Mark this topic as a question" check box. Then you will get the option to reward points.

Regards,

Balaji Viswanath.