How to include a click to view functionality in SAP querry report

[Former Member]

Dear Experts,

I have developed a sap querry report for Open PO details.

Now I want to include a functionality by which if user is selecting a line item of PO from the report he will be guided to the ME23N and will display a particular PO and line item.

I dont know how to do it in sap querry.

Please help.

Thanks,

Sachin

[tomas_talpa · Accepted solution]

Hello Sachin,

well, with enjoy transaction like ME23N it will require some simple development... anyway, the first step is "how to include a transaction/report call in SQ01" -- picture is worth a thousdands words, so see bellow (starting from query change in SQ01):

    

With this function ("Report Assignment" via "Other report type"), you can specify which report/transaction will be called during double-clicking the query line.

How the system determine with which specific data should it call such report/transaction? It uses a Parameter IDs -- be sure that the field in your query has the ID assigned (for EBELN "Purchasing Document Number" the PID is 'BES', as you can see in SE11 -> Data type EBELN).

Now here is the issue with ME23N -- enjoy transaction doesn't utilize these PIDs, so inserting ME23N as assigned report will call the transaction, but it will not set the correct PO number (as opposed to old transaction ME23).

Workaround is easy-- create a simple ABAP report reading the field EBELN from entry screen with the PID (like "PARAMETERS: EBELN type EBELN MEMORY ID BES.") and then calling the PO display (e.g. via FM ME_DISPLAY_PURCHASE_DOCUMENT), and then use this as assigned report.

Kind Reagrds

TomT