Formatted search : link a field from item master date into invoice

[Former Member]

Hi,

i like to see from the item master data , the Purchasing UoM in the A/R Invoice as a table field.

I tried it in many ways, but it doesn't work. maybe the sql statement is wrong.

could somebody help me?

thanks

michael

[Former Member · Accepted solution]

Thank you all for your reply.

but it doesn't work anyway.

i create a word document , that shows , what i want to do.

[http://www.mydrive.ch]

for login: name:polley password:sap2008

greetings from hamburg

michael

[former_member583013 · Accepted solution]

Ok. The field is actually BuyUnitMsr

SELECT T0.BuyUnitMsr FROM [dbo\].[OITM\] T0 WHERE T0.ItemCode=$\[$38.1.0]

[Former Member]

many many thanks for you fast answer.

it works !!

best regards

michael

[former_member583013]

Michael

I think the UDF you have created is in the Marketing Document lines.

Suda

[Former Member]

Hi Michael,

Try this query to see if it works:

SELECT T0.purpackmsr from oitm T0 where T0.itemcode=$[$38.1.0]

Thanks,

Gordon

[Former Member]

hi Sridharan,

thanks for your fast reply ,

i'm sorry, but the sql statement doesnt't work. (failed)

i use SBO2007

greetings michael

[Former Member]

$[Inv1.itemcode] is a System variable. As with any system variable, 
if you only run it within the Query Generator, it will give you error, as 
within the query generator the system cannot retrieve the correct current 
value for the system variable. 

Therefore, you need to run the query either from the menu: Tools -> 
User Queries, or from within a document as formatted search. 

[Former Member]

Use the following query as FMS to the Row level UDF in AR Invoice

SELECT oitm.purpackmsr from oitm where oitm.itemcode=$[Inv1.itemcode]