If you can see that he is deteriorating and he cannot see this, it means he has a poor insight into his situation.
If you can, then convince him to see a doctor who can then get his
liver function and other tests done and then your friend will also see how alcohol is harming him. Once he realizes this, the chances that he would think about quitting become higher.
He can be started on motivation enhancement therapy.
Medicines will help him with the craving and sleep.
Next Steps
Please consult a psychiatrist.
You can also convince your friend to consult online, he might agree for that.