How get approver for corresponding PR or PO?-Urgent

[former_member526144]

Hi,

I want to identify the list of PO's or PR's who has approved. this information where i can get i mean in which table?

I know reporting line history we can get from HRP1001 based on the position.

thank you.

Ravi

[former_member526144 · Accepted solution]

Hi all,

If anyone helps me on this that would be great. i am desperately looking for this..whetther it is possible or not?

I couldn't find any table which give me the shooping cart approver for corresponding shooping cart..

Thank you.

Ravi

[Former Member · Accepted solution]

Hi Ravi,

For example, PR 10002620

(1) Browse table CDHDR (Change document header), specify:

Change doc. Object = BANF

Object value = PR number (remember to add first 2 zeros) i.e. 0010002620

Transaction = ME54N (release manually) and/or ME55 (collective release)

The result showing the user who has run transaction ME54N and/or ME55 for the PR, then user may be the approver of the PR. If multiple records found for a particular PR, it may be approve/reject several times. You may only extract the latest record.

(2) Because transaction ME54N can either approver or reject PR, it is necessary to further check table CDPOS (Change document items), specify:

Change doc. Object = BANF

Document number = <found in step (1)>

Table Name = EBAN (Purchase Requisition)

Field Name = FRGKZ (Release Indicator)

In the result, if field FRGKZ (Release Indicator) changed from Old value 'X' (blocked) to New value '2' (PO creation allowed), we know that the user found in step (1) is the PR approver.

Regards,

Donald