How to get approver with SO in PLD
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?
Abhinav Banerjee replied
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
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
SAP Business One Forums Team
Edited by: Abhinav Banerjee on Nov 22, 2008 2:49 AM