on 07-29-2013 9:37 AM
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.
Hi,
Try this:
SELECT T0.[ U_Size] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0]
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
hi swapnil Vichare
Select U_Size From OITM where T0.[ItemCode] = $[$38.1.0]
Regards
Jenny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.