From where we can get the value of tdpur045.pmsk?

I thought tdpur045.pmsk=tdpur051.pmsk but when I see some test data it seem to be wrong.

There are 2 steps for Order Type return order.
8 Print Purchase Invoices
9 Process Delivered Purchase Order

tdpur045.pmsk=nnnnnnneennnnnnnnnnn
tdpur051.pmsk=nnnnnnnyynnnnnnnnnnn for Record Type=1
tdpur051.pmsk=nnnnnnneynnnnnnnnnnn for Record Type=3

What is the meaning of "e" in procedure mask?

Note: For Screen shots plz. refer the attached documents.

Mask" used in the software for the processing of purchase orders.

n the session with the step number equal to the position
of this "n" is not executed.

y the session with the step number equal to the position
of this "y" must still be executed.

c the session with the step number equal to the position
of this "c" can be run again.

e the session with the step number equal to the position
of this "e" has already been executed.

Hi All,

Actually we are try to restoring missing receipts which are deleted during archiving. I mapped tdpur045.pmsk with tdpur051.pmsk (PO Line History).
But they are not always equivalent. So it may be give wrong result. I want to know whether the Procedure Mask is stored anywhere other than PO Line History (tdpur051).

From which table can I get the value of tdpur045.pmsk other than tdpur051?

I guess those two tables would be it..I dont see why any other table would have purchase order procedure mask.

What are you trying to retrieve from 51? I mean what values?
You can get reciept date and quantity from tdinv700. Since receipt number is not available in tdpur51, the only other reason why i think you would want tdpur51 is for the invoice number and date.

In anycase, you wouldnt need to link the procedure mask in this scenario..

sk

Hi Sukesh,
I am asking for tdpur045.pmsk only. Only from this field we came to know whether PDPO is completed or not. Since the value of tdpur045.stsc (Update Status of Actual Purchase) is dependent on procedure mask.
If Purchase Delivered PO has completed, set to 'Actual Costs Updated’, otherwise ‘Free’. Only from Procedure Mask we can decided whether PDPO is completed or not. (The session with the step number equal to the position of "e" in the procedure mask indicate session already been executed.)

But the problem is that tdpur045.pmsk is not always equivalent to tdpur051.pmsk

I guess that the Process Delivered Purchase Order part of the procedure mask is not updated in the pur45 table and instead of showing "e" like in 51 table it only shows "y"...

sk

Hi Sukesh,

Yes, you are right. Is there any solution?

I have to clarify something beforehand...The process delivered purchase order step is updated "e" in 45 but in 51 it remains at "y" contrary to what i said in my previous post..

Therefore, 45 will show you the correct status of the PO from the procedure mask. The relevant info can be obtained from 51 if you select record type (ckor) = 3 and by linking the first 8 characters of the procedure mask in both the tables since only the 9th step differs..

Another fact is that pur51 doesnt record the receipts untill they are invoiced..

sk

Hi Sukesh

If you study the script tdpur4223 (PDPO) you can found that first it update tdpur051.pmsk with older value of tdpur045.pmsk (tdpur045.pmsk(stno.4223;1) = "y") and then after it update the value of tdpur045.pmsk (tdpur045.pmsk(stno.4223;1) = "e"). So it is always tdpur051.pmsk<>tdpur045.pmsk. Now we are restoring data from tdpur051 itself (tdpur045.pmsk=tdpur051.pmsk). Which will always incorrect. From only procedure mask we came to know whether PDPO is completed or not. Since we are not getting the correct value of Procedure Mask, we can't getting the value of Update Status of Actual Purchase (tdpur045.stsc).