cancel
Showing results for 
Search instead for 
Did you mean: 

Table for deleted by field in PR

pankajchawda
Explorer
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Prasoon
Active Contributor
0 Kudos

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

vijay2006ece
Contributor
0 Kudos

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.