This is a view in the mssqlsystemresource database. Contains one row per authenticated session on the SQL Server.
CREATE VIEW sys.dm_exec_sessions AS SELECT * FROM OpenRowset(TABLE SYSSESSIONS)