Skip to Content
0
Dec 02, 2011 at 09:42 AM

FMS in 'Issue for production'

46 Views

Hi

I have some problems creating an FMS:

SELECT T1.PlannedQty FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocNum=$[IGE1.BaseRef.0] AND T1.[$37.15.0]=$[$13.60.0]

returns

SELECT T1.PlannedQty FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T0.DocNum=N'11204           ' AND T1.[$37.15.0]=N'15          '

which turns out to be a problem with

T1.[$37.15.0]

Could anybody please tell me what I did wrong?

My target is to create a function for partial issue using the Ref.2 field to enter the base quantity to issue and using the returns of the FMS above to calculate the corrected issue quantity line by line.

Thanks

Franz