Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to get approver with SO in PLD

Hi expert

I have an approvel procedure on sales order.

I would like to get approver in PLD, but how to get them?

I know the data save in OWDD/WDD1 table, and I can use

Alt key to pull the all table, but I don't know how to join them well. Have any body meet the sam problem? Any body have the solution?

Glen

replied

Hi,

Please follow the below mentioned steps:

1. make a UDF on the title level of the marketing document

2. make a query like this:

SELECT T3.U_NAME FROM OWDD T0, ORDR T1, WDD1 T2 INNER JOIN

OUSR T3 ON T2.UserID = T3.INTERNAL_K

WHERE T1.DocEntry= T0.DocEntry and T2.WddCode=T0.WddCode

and T1.DocNum=$[$8.1.0]

3.link the query to the UDF;

4.add a data field in the print template to make the UDF visible.

+But,please note that for multi approver scenario,the system does have

the limitation here that when in these cases, you can display only one

approver or you have to create several UDF to display the whole

information.

Regards,

Abhinav Banerjee

SAP Business One Forums Team

Edited by: Abhinav Banerjee on Nov 22, 2008 2:49 AM

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question