cancel
Showing results for 
Search instead for 
Did you mean: 

How to Select Row level field value as input to FMS

Former Member
0 Kudos

Hi,

I required query in which we select Row level field value as input to FMS.

I have added in row level UDF named Size in Sales Order Document.

Requirement is  When we select Item code in sales order document required to show the size in that row level UDF from the Item master.

In item master there is a document level UDF named Size.

i have tried query  "Select U_Size From OITM where Itemcode=$[RDR1.Itemcode]" But it not worked.

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this:

SELECT T0.[ U_Size] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0]

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Thank You Naga Rajan

In above query 38.1.0  is used in which 38 is item no. but .1.0 is for what?

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

FYI

The general format is $[$FieldIndex.FieldColumn.Number/Currency/Date/0]

Where

Field Index: The item number of the field on the form.

Field Column: The index of the column of the field within a table.

Number / Currency / Date / 0

 

Where

Use Number if the required field includes a number and a currency symbol (item price, document total) to retrieve the number (without the currency symbol or the unit of measurement). This separation is essential when you need to use the number for arithmetic expressions.

Use Currency to retrieve the currency symbol or the unit of measurement from a field that includes a number and a currency symbol/unit of measurement.

Use Date if the required field is a date field and you need to use it for computation.

Use 0 if the field contains a single value (quantity, item number, item description, business partner code, or document number) that you want to use as a character value.

Hope helpful.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Thank You 

Answers (1)

Answers (1)

former_member325312
Active Contributor
0 Kudos

hi swapnil Vichare

Select U_Size From OITM where  T0.[ItemCode] = $[$38.1.0]

Regards

Jenny

Former Member
0 Kudos

Thank you JENNIFER ANDERSON

In your query what is means by .1.0 ?