SAP query

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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

[Former Member]

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.

[Former Member]

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,

[Former Member]

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

[Former Member]

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

thanks alots.

Alia

[andreas_mann3]

Hi,

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

Andreas

[Former Member]

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

alia

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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