Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Query Creation - Where to do? Dev or Prd

Former Member

‎2005 Jan 10 6:51 AM

0 Likes
1,845

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)

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)

Reply
11 REPLIES 11
Read only

Former Member

‎2005 Jan 10 7:36 AM

0 Likes
1,705

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.

Read only

Former Member
In response to Former Member

‎2005 Jan 10 7:54 AM

0 Likes
1,705

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

Read only

Former Member
In response to Former Member

‎2005 Jan 10 11:29 AM

0 Likes
1,705

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.

Read only

Former Member
In response to Former Member

‎2005 Jan 11 6:57 AM

0 Likes
1,705

Hi Anand,

There ia a coding section in query creation SQ02.

Can anybody harm our DB with that?

Please help.

Regards

Lijo Joseph

Read only

Former Member
In response to Former Member

‎2005 Jan 11 7:33 AM

0 Likes
1,705

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.

Read only

Former Member
In response to Former Member

‎2005 Jan 12 4:11 PM

0 Likes
1,705

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

Read only

nablan_umar
Product and Topic Expert
Product and Topic Expert
In response to Former Member

‎2005 Jan 12 4:55 PM

0 Likes
1,705

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.

Read only

Former Member
In response to Former Member

‎2005 Jan 13 3:29 AM

0 Likes
1,705

Hi Umar,

thanks for the information.

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

regards,

Lijo Joseph

Read only

Former Member
In response to Former Member

‎2005 Jan 15 2:04 AM

0 Likes
1,705

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)

Read only

Former Member
In response to Former Member

‎2005 Jan 15 5:24 AM

0 Likes
1,705

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

Read only

balaji_viswanath
Participant
In response to Former Member

‎2005 Jan 15 10:22 AM

0 Likes
1,705

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.