topic Re: Sap Query Report Assignment Parameter in Application Development and Automation Discussions

Sap Query Report Assignment Parameter

Former Member — Thu, 05 Nov 2015 13:06:38 GMT

Hi,

Actually I am a functional Consultant and building a query for PM Reports.

I have two queries in place where First query provides the Equipment Life (i.e., days with calculations) and second one is for Equipment Order Costs.

I want to call up the second query from the first one.

I have made the report assignment everything is working fine but the problem is as below:

The second query (With order details) is having two selection fields one with Equipment (EQUI-EQUNR) and second is PERID (which I have created as selection parameter in infoset SQ02) and it is a date field (with reference from AFKO-GLTRP).

Now, the field PERID (or AFKO-GLTRP) is not present anywhere in first query but since it is a date field, it is picking the value from EQUI-ANSDT which is also a date field and is present in my First Query.

Here I want the report not to take up that value and instead I want to give a formula for this field.

Is there any way to provide formula for Report assignment.

Thanks in advance.

Regards,

Chin2.

Re: Sap Query Report Assignment Parameter

jogeswararao_kavala — Thu, 05 Nov 2015 14:52:47 GMT

What is the method of Report Assignment you are using?

Re: Sap Query Report Assignment Parameter

Former Member — Fri, 06 Nov 2015 04:48:45 GMT

Jogeswara Rao Kavala

Sir, I have tried using TR as well as query as mentioned in your post but in both the cases it is behaving the same way.

Your post was stuffed well enough to help me in creating the query and quiery is working like a charm.

But if there is any way I can give the condition from first query to selection field in second query it would be done.

Thank you for your valuable time and response sir.

Regards,

Chin2.

Re: Sap Query Report Assignment Parameter

jogeswararao_kavala — Fri, 06 Nov 2015 05:11:57 GMT

At the most from the known methods so far you can try to give the Variant name also in the Query you are referring to in Report Assignment. And the variant can contain dynamic Date values (you know the settings while Saving a variant). For detailed calculations of the Date field in the called query, I would say, Such are the requirements which drove me to ABAP reporting always.

Re: Sap Query Report Assignment Parameter

Former Member — Fri, 06 Nov 2015 09:24:51 GMT

Jogeswara Rao Kavala

Thank you so much for your response sir.

I solved it myself as I have created a similar field in first query and I am fetching the values from that field instead.

Re: Sap Query Report Assignment Parameter

jogeswararao_kavala — Fri, 06 Nov 2015 09:29:46 GMT

Happy you've resolved. Often this area demands innovative methods. Very recently similar thing happened to me and I had posted that timely as an update to my existing blog. i.e., Please go through the same at the end of the post. It might be a useful knowledge piece, because you are active in this area.

Good luck

KJogeswaraRao

Re: Sap Query Report Assignment Parameter

Former Member — Fri, 06 Nov 2015 09:35:15 GMT

Jogeswara Rao Kavala

Thank you so much sir.

By the way, I have been through this post as I am constantly following all your posts.

As in some manner, I am a big fan of your writting.

Thank you once again Sir.

Regards,

Chin2.