SAP Query Creation - Where to do? Dev or Prd

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)