Skip to Content

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

How to get the Prefixnumber of salesorder to the Prod.order-->Issue&Receipt

Hi Experts,

I have created a Prefix no(AH-SO) in the salesorder document the document number range starts from 10001 to 2000

First iam doing a sales order for the parent item without NULL stock

and raising a production order and giving the issue & Receipt for the item.

The value of the Prefix and the saleorder number should get displayed in a UDF field both in the Receipt and Issue from Production.

I have tried out with this query but it is working within the salesorder document window

( select T0.Seriesname + $[$8.0.0] from NNM1 T0 where T0.series = $[$88.0.0])

any other possiblilities of getting these values through Formatted search?

Waiting for your replies..

Regards,

Magesh.

Former Member
Former Member replied

You want to put the FMS on the Issue and Receipt from Prod transaction? Correct?

In the Production Order UDF please create a FMS with this query

<b>SELECT T0.BeginStr + '-' + CAST(T1.DocNum AS VARCHAR)

FROM [dbo].[NNM1] T0 INNER JOIN [dbo].[ORDR] T1 ON T0.Series = T1.Series

WHERE T0.ObjectCode = '17' AND T1.DocNum = $[OWOR.OriginNum]</b>

Suda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question