Creating a function for a simple select statement?
You could write an inline table valued function, or use a view to encapsulate this code, but it would depend on what you hope to get out of it. 

There's no performance gain by doing so. It can make the application query simpler, or obfuscate table names, but that's about it.

Obfuscating table names may provide an additional, though minimal layer of security. Any escalation of privileges could result in someone seeing the view definition and exposing the table names anyway.