Formatted Search

[Former Member]

Hi Experts,

Help me with the query for below,

I created one UFD and i have written formatted search

(SELECT * from dbo.CS_MAWB)

to pick AWB number this one is working perfect.

the problem is i want the customer code should populate as per the UFD selected , for that i have written another formatted search that is

SELECT account3 from dbo.CS_MAWB where MAWB = $[$U_MASTER.0.0]

please help me with the correction of the above query.

[Former Member]

1^st Query(FMS) for UDF

SELECT * from dbo.CS_MAWB

2^nd Query(FMS)

SELECT account3 from dbo.CS_MAWB where MAWB = $[$U_MASTER.0.0]

For 1^st query it’s working perfect , but 2^nd query should pick account3 column with belongs to UDF

It’s getting the error like

Get Internal Error (3006) [Message 131-183]

[kvbalakumar]

Hi Anil,

May we know, how you created CS_MAWB table?

It looks like it was created from SQL and not through SAP.

It's best practice to ALWAYS create tables and fields through SAP and not using SQL!

To create tables, Tools --> Customization tools --> UDT - Setup

Regards,

Bala

[agustin_marcoscividanes]

Hi

try this query:

SELECT account3 from dbo.CS_MAWB where MAWB = -$[$U_MASTER.0.0]

When you want to select an UDF you have to write "-"UDF.

Kind regards

Agustín Marcos Cividanes

[former_member184146]

Hi Anil,

by which field you want to pick the customer code??