Delivery deletion report

[former_member560195]

Hello SAP guru's,

my client requires a delivery deletion report where he want to see delivery number, item number, part number, part description, plant, deletion date & time and user id who deleted. Kindly help me for this that is there possibility to find all these things for deleted delivery either whole delivery deleted or partially deleted. As I tried with CDHDR & CDPOS table but i m not able to find part number, description and plant details. Is there any possibility by using SQ01 or SQVI?

Thanks in Advance!!!!

[eduardo_hinojosa]

Hi

If there are powerful reasons to check what deliveries are deleted, when and whom delete them, you can try to store this information in customer tables using userexits. Check "Note 415716 - User exits in delivery processing", when it talks about "FORM routine USEREXIT_DELETE_DOCUMENT (include MV50AFZ1)" and if it matters in your release. Take in account its advices, furthermore related with no use of messages (W or E) or no prevent the deletion inside this subroutine. In your table you can save number of document, user ID, date and time.

I hope it helps you

Regards

Eduardo

[former_member560195]

thanks for your support.

[VeselinaPeykova]

In the standard system the information that your clients asks (material number, material description and plant of the items of deleted deliveries) is not available, so it does not matter if you use SQ01, SQVI or you write a custom report.

For the rest a standard solution is already available - SAP have provided transaction AUT10.

[former_member560195]

thanks for your support.