on 07-31-2013 8:48 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.