Skip to Content
avatar image
Former Member

can we write query for fomatted search without from clause

can we write query for fomatted search without from clause as below.

SELECT (($(u_amt)*14)/100)

here U_amt is a UDF .I want to assign this to another field .

Rgds,

Rajeev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 19, 2008 at 09:22 PM

    Hi Rajeev,

    You can write query for FMS without from. That is because you can omit it when you get value from active form by default. The grammar of it is:

    Select $[$38.u_amt.0\] * 14/100 in your case if you have item type marketing document @line level.

    From View-System Information, you can get the info you need for your FMS query at the left bottom of your screen.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded