Best way to get the latest Identity when inserting through View
IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.

SCOPE_IDENTITY returns the last identity value generated for any table in the current session and the current scope