topic Re: SAP query in Application Development and Automation Discussions

SAP query

Former Member — Thu, 08 Dec 2005 12:09:53 GMT

Hi all,

Can we put additional coding inside sap query? for example: for sales amount, i want to add with tax amount, so that will be total sales amount.

how to put these calculation in query?

thanks alots.

alia

Re: SAP query

Former Member — Thu, 08 Dec 2005 12:12:19 GMT

it is not possible to change the SAP query(it will ask for access key)

instead you can make a copy of the query and do your changes

regards

Arun

Re: SAP query

Former Member — Thu, 08 Dec 2005 12:14:43 GMT

Hi,

You can write custom code in the Infoset/Query. But it should be a Z query. You can't change SAP query until unless if you have access key.

Regards,

Sudhakar.

Re: SAP query

Former Member — Thu, 08 Dec 2005 12:17:18 GMT

Hi,

You can create the custom infoset query from SQ02 and add & make changes as per the requirement, however standard query cant be modified without the access key,

Rgds,

Re: SAP query

Former Member — Thu, 08 Dec 2005 12:18:47 GMT

Hi,

You can put any kind of code in SAP query through SQ02 (Infoset).

inside the infoset select GOTO Option and then you will find CODE option.

Thanks

Eswar

Re: SAP query

Former Member — Thu, 08 Dec 2005 12:33:12 GMT

these is custom query... im using SAP ECC 5.0, from where i have to reach the GOTO option? cant find..

thanks alots.

Alia

Re: SAP query

andreas_mann3 — Thu, 08 Dec 2005 13:49:24 GMT

Hi,

look here for <a href="http://help.sap.com/saphelp_47x200/helpdata/en/d2/cb4504455611d189710000e8322d00/frameset.htm">Further Code</a> in infosets

Andreas

Re: SAP query

Former Member — Thu, 08 Dec 2005 18:53:07 GMT

Hi Alia,

- Copy Infoset to custom Infoset

- Write field code for Sales Amount field

- Create a query on new Infoset

I am assuming it's SAP infoset.

Hope this solves your problem.

- Bharat

Re: SAP query

Former Member — Fri, 09 Dec 2005 01:17:18 GMT

hi Eswar... thanks. can see the CODE option now. have to reach by other way..oohh.

alia

Re: SAP query

Former Member — Fri, 09 Dec 2005 04:04:59 GMT

Hi all. Can you pls tell me what the SAP Query code (SQ01) can be used. I have never used it. Please tell me the utilities.

Thanks & Regards,

Bijo.

Re: SAP query

Former Member — Fri, 09 Dec 2005 04:23:53 GMT

hi BiJo,

SQ01 is the ABAP query.....

it is the simple tool to generate simple reports without need for any coding....

i haven't used it...

regards,

purushothaman.

Re: SAP query

Former Member — Fri, 09 Dec 2005 04:36:09 GMT

Hi,

This will be used for basic(Easy) reports by the functional consultant itself.(usually no coding is required , everything is done by drag and drops)

Generall Sq01 wont be used alone…It will be used along with sq02 & sq03

regards

Arun