topic Re: ABAP Query in Application Development and Automation Discussions

ABAP Query

Former Member — Wed, 06 Apr 2005 09:03:14 GMT

Hi All,

Will it be ok If I copy and mondify the code

autamaticaly generated for an abap Quary ??

Thnaks in advance for your reply.

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 09:20:42 GMT

Hi,

I tried that a very long time back. Can't remember if I had faced any particular problems. What's the harm in trying it out anyways?

Regards,

Anand Mandalika.

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 09:38:34 GMT

when i copied an exat copy of query to a z-program,

I am getting different set of results from both sides.

Re: ABAP Query

michael_bennett1 — Wed, 06 Apr 2005 12:51:55 GMT

Hi John,

I agree with previous comment that technically you could copy and change a SAP Query report. Of course there is so much happening in such coding that you might find that a simple copy doesn't work.

I would offer that you can actually do a lot of "additional" processing in SAP Query using the existing features. For example, you can add fields, structures, additional selection criteria, coding at many reporting events (e.g. GET, GET LATE, SELECTION, DATA). The help in the SAP Library is quite good in terms of what you can do with InfoSet and queries.

If you want to reply with your specific issue I'll try to give my thoughts.

Regards,

Michael

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 12:54:49 GMT

Hi,

U can copy ABAP QUery into z-programs ,But u will get problem while Transport to testing ,Bcos the Logic or code generated by ABAP Query may not be compatible with Client <> Client.Better to write Own Program.

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 13:37:36 GMT

Hi Michael,

This is customer Open Items aging report in iter company transactions.using LDB- KDF .

Data is fetched from LDB in the query.

But the new requirement is to handle inter company postings,in case a an inter conmapany document is found

fetch all the corresponding documents from the receving company codes.

Since we give co-code in selection screen, LDB will not process other company code documents,So I wrote select query in the right place in the info set to fetch the other company info,in Get event.

But the problem is the user wants to display all the line items coming under a document which is posted in different co-codes.

i.e like sub items of the original document info.

Thanks for your help.

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 13:43:34 GMT

I observed some line items is filtered while i am

exicuting the report from the query,but not in the correspoding z-report.

I have all the authorization in the development system.

any clues.

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 14:01:59 GMT

Hello,

I had a similar problem. The report generated by abap query was generated report: AQA2SU-TEAM=====PR_CHECK======

Copy the program with all the includes to a Z program and then make changes or transport it.

Regards,

Shekhar Kulkarni

Re: ABAP Query

Former Member — Wed, 06 Apr 2005 14:03:22 GMT

Hello,

I had a similar problem. The report generated by abap query was generated report: AQA2SU-TEAM=====PR_CHECK======

Copy the program with all the includes to a Z program and then make changes or transport it.

There is also a way to add code or make changes to the query using SQ02.

Regards,

Shekhar Kulkarni

Re: ABAP Query

michael_bennett1 — Thu, 07 Apr 2005 00:03:45 GMT

Hi John,

Thanks for the explanation. Ironically enough I just faced this situation myself. I wrote my own report using the logical database instead of using SAP Query, the main reason is not being able to "insert" the additional records from the cross company documents. On relection, without having tried, there should be no reason that you couldn't include the additional logic at the GET event for the BSID item, as you indicated, and then add these extra records to the field-groups that SAP Query uses (i.e. you should find an EXTRACT statement in the generated coding). That is to say you will need to EXTRACT the additional retrieved records to the defined FIELD-GROUPS in order to see them in the report. I haven't tried it but it should be possible.

As others have mentioned you might just find this easier i your own ABAP report.

Regards,

Michael