Skip to Content

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

FMS Query

Dear All,

Greeting of the day..

I have created one UDF field (price) at Business Partner Master data.

and another field at delivery row level labour amount.

now i want multiplication of the master filed with delivery quantity at each row level. I have tried the below FMS.

(SELECT T0.[U_LabCost] FROM OCRD T0  INNER JOIN ODLN T1 ON T0.[CardCode] = T1.[CardCode] INNER JOIN DLN1 T2 ON T1.[DocEntry] = T2.[DocEntry] WHERE T0.[CardCode] =$[ODLN.CardCode.0]) * ($[DLN1.Quantity.0])

but couldn't get result.

Regard,

Datta Kharat

Former Member
Former Member replied

Hi,

Try this query SELECT $[OCRD.U_PRICE] * CAST(REPLACE($[$38.11.0],',','') as FLOAT)

as FMS in labour amount field with quantity as focus.

Cheers,

Shiva

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