How Can I attache Approver ID in report "Posted Sales Shipment"?

PanJ

Hi users,

Follow that issue, How can I get through this?
I had checked, there are 3 tables which relate to each others. As I see is

1. At Table : Sales Shipment Header >> field "Order No." which store Sales Order No.
2. Then I think l have to make a relation between (1) with Table : Sales Header Archive >> field "No."
which the same No. as "Order No." to get filed "Assigned User ID"
3. After that, make a relation between (2) with Table : User Setup >> field "User ID", so I can reach "Approver ID"

Is there any ways to get this easier?

Thank you in advance

pradi

Link the Order no. field with Approval entry Document No. The last record found would give you the USERID who has approved it. Or create an array variable to store all the approver's against that document and display it in the report.