Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

replied

Ok. The field is actually BuyUnitMsr

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question