Skip to Content

Table for deleted by field in PR

Hi Friends, I need the field "deleted by" (not changed by) for Purchase Requisition, which table will help me to fetch this data, kindly advise.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 31, 2013 at 09:14 AM

    Dear Pankaj,

    One option is to develop a report based on the tables.

    EBAN- fetch deleted PR status and get CDHDR details and pass it to CDPOS. In that way we can get the result.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 31, 2013 at 09:19 AM

    Hi,

    Check the tables CDHDR & CDPOS.

    Pass your PR number with prefix 00 (eg: 0010015176) to CDPOS-OBJECTID and get the object id or CHANGENR for which FNAME=LOKEZ and VALUE_NEW = X . This will give you the deleted PR's.

    Now pass the CHANGENR to CDHDR table (CDHDR-CHANGENR) to get the USERNAME. This will giv you the user who deleted the PR item.

    Hope its helpful.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.