Report

[Former Member]

hi,

How can I generate a report of cancelled PO?

thnks.

[Former Member]

HI,

For this we have 3 solutions:

A1:Use a Query with table EKKO whose field LOEKZ is the deletion indicator.

A2: Go to the initial screen of purchasing. Then go to PURCHASING -> LIST DISPLAYS -> BY PO NUMBER -> EDIT -> DYNAMIC SELECTION. This allows you to select certain fields from the EKKO table and EKPO table. Deletion indicator can also be seen here. Use ‘dynamic selections’ to determine your selection criteria and run the report.

A3: You can also do this via the IMG

Go to Transaction OMEM or Menu path - MM -> Purchasing -> Reporting -> Maintain Purchasing Lists

Click on Scope of List Create New entry.

Check on Change Documents field. Name the new Scope with relevant name. This will now appear in Scope of List field in all Purchasing List Display screens. The output will show the details of the changes like date and time of change, old value, new value etc.

Cheers,

Chandra Sekhar.

[rahul2000]

Dear Sreekar,

Just pick all the EBELN from EKKO table for which LOEKZ = 'X'..u wont have to do anything else i guess if only this is u r requirement