Skip to Content
May 01, 2012 at 07:10 PM

Print Layout Designer - displaying values from a lookup field


I am trying to create a report in SAP's Print Layour designer. Using SAP B1 8.8

The report is a basic Sales Order layout, except instead of displaying bill to and ship to from the sales order, I am displaying bill to and ship to addresses from the Business Partner master.

Everything looks good except the country field. Instead of showing the actual country name, it shows it's abbreviatd code. So for Lebanon as an example I am showing "LB" and so on. How do I display the actual country name and not the code?

I have tried displaying from but when I try to display the report, it says "no data found".

There must be an easy way to do this... Please help. thanks!