on 01-25-2019 4:49 AM
Here is a screenshot from ME53N of a Purchase Requisition's Approval Log. I blanked out the User Names and typed in fictitious names. I am trying to figure out how the levels (L1, L2, L3, L4) associated with each approval are determined.
I checked CDHDR and CDPOS and I found the records that correspond to the 4 records listed:
I know that the 4 users listed have the following authorizations:
CKING L1, L2
JDANIELS L1, L2, L3
MPRICE L1, L2
SJAMES L1, L2, L3, L4
However, I cannot figure out how ME53N determines that the entry by MPRICE is the L1 Approval and the CKING entry is the L2 Approval. I thought that I could use CDPOS-VALUE_NEW, but the number of "x"s does correspond to the correct level. The first CDPOS record is for CKING (L2), but only has 1 "X".
How do I use CDHDR and CDPOS to determine which Approval Level goes with each User?
Hey Jack,
Even therough CDHDR and CDPOS you can get the information that status of PR has been released or blocked or in other status based upon your release indicator!
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The MM configuration for PR Release strategy sets what Release Codes are assigned to the PR. In your case L1...L4 are Release Codes.
Users are given authorization for a Release Code. Specific users are not assigned to a code in configuration. Specific users can be assigned via workflow if it is used. Otherwise everyone with authorization for a Release Code can release a PR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks, Ankur, but that does not answer my question. I know that I can get the status but what I am trying to understand is how they are determining which user goes with the different levels of Approval (L1, L2, etc).
When I look at CDHDR and CDPOS for the Purchase Requisition in the first screenshot above, I can see that MPRICE was the third person to Approve, with CHANGENR 12755267 and the NEW_VALUE is "XXX". How does that translate to "Approval L1"? and how does CKING, the first one to enter an approval with CHANGENR 12737104 and NEW_VALUE of "X" translate to "Approval L2"?
Is there another table (besides CDHDR and CDPOS) that is being accessed to make this translation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks, Ankur, but that does not answer my question. I know that I can get the status of the PR, but I need to get each level of approval and the associated user.
The Approval Log (see the first screenshot above) shows:
L1: MPRICE
L2: CKING
L3: JDANIELS
L4: SJAMES
What I need to know is how it is associating MPRICE to the L1 Approval. Looking at CDPOS, the record for MPRICE (CHANGENR 12755267) has a NEW_VALUE of "XXX". How does this translate to L1?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.