Retreve current form value in user define field

[Former Member]

Hi,

I got a questions, please help.

I want to retrieve values in current form, like the quantity and discount in Sales order, into a user define field with formatted search, is it possible?

Many Thanks!

Paddy

[former_member204969 · Accepted solution]

In an FS connected to the sales order row, you can refer to the quantity with the code $\[RDR1.Quantity] and to the Discont % with $\[RDR1.DiscPrcnt] .

[Former Member · Accepted solution]

Hi experts,

I have tried many times, but I still cannot retieve a multiply value, my command is Select $[38.11.8] * $[38.15.0], but it returns a error, please help

Many Thanks!

Paddy

[Former Member · Accepted solution]

Check this code which multiplies Quantity Field and Discount Field in Marketing Documents

Declare @qty numeric(18,6)
Declare @disc numeric(18,6)
Set @qty=($[$38.11.0])
Set @disc=($[$38.15.0])

Select (@disc * @qty)

[Former Member]

Check this ELearing on Formated Search Queries

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5cae89f9-0901-0010-64be-f37d9a7eed7b]

[Former Member]

Hi All,

Please help me to get the help for reference which the query Gordon posted? Select $[$38.11.0]

it works, but I never saw a query like that, does anyone has reference or help for that?

Many Thanks!

[Former Member]

This is the Syntax of FOrmatted Search Query. This syntax will work only with SBO.

$[$38.11.0]

38 Represents the Matrix(Table) in a Marketing Document

11 Represents the Quantity Field in the Matrix

0 Represents the Number Format.

Place your Cursor on the Matrix and Press CTL + SHFT + D, you'll find the Column information in the Left side of the Status Bar

[Former Member]

Hi Paddy,

That is what formatted search good at.

For example, you may use this one to try:

Select $[$38.11.0\]

Assign it to line level UDF on Sales Order to check

Thanks,

Gordon

[Former Member]

Hi Gordon,

I have saved your query in query generator, and assign it to a UDF, but it cannot get any value, please help!

Paddy