Hello, i have small problem. I want to combine sql statement with reference. 

Is there any way, how to create custom column in purchase order, where i need using SQL statement but i want use link possibility as well. Ideal result for me is a “String” from SQL statement and if user click on string will be transfer by link path. 

And another silly question. It is possible to create a reference outside the LU. For example: In purchase order i have PART_NO from PART_CATALOG on order line and i want create reference from this line to PART CATALOG. It is possible? 

Thanks you guys.