FOR BROWSE:
Sometimes you will loose the orange drill-down arrows while writing SQL in SAP B1 (for a variety of reasons).
One way to get the orange drill-down arrows to reappear in the SQL results is to put the phrase "FOR BROWSE" at the very end of your SQL.
Sometimes the "FOR BROWSE" will not help bring back the orange drill-down arrows;
for example, when using a "UNION" in your SQL or with some other advanced functions.
Go ahead and get into the habit of entering the phrase at the end of each SQL you write and
when the SQL does not allow it, you will get an error message specifically stating "FOR BROWSE" cannot be used.
to be continued...
source:
http://wiki.scn.sap.com/wiki/display/B1/SAP+B1+SQL+Contributors'+Tips+and+Tricks
