Skip to Content
0
Former Member
Nov 06, 2012 at 11:23 AM

Territory Value Displays as a Number in Query

316 Views

We have a field setup on our SAP B1 system for the following detail...

  • Territory - This shows the geographical location based on our sales areas, midlands, scotland, south, europe etc.

The issue i have is that i would like to build a query so the results give me the text value of this field and not the numeric value...

For example, I want to be able to run a query that i can choose from a dropdown of options to return all BPs that are in a particular territory. I would also like to be able to run this report to return all types excluding a particular territory

Thanks