This is a view in the mssqlsystemresource database.
CREATE VIEW sys.dm_io_backup_tapes AS SELECT * FROM OpenRowset(TABLE TAPE_STATUS)