The Book of Drinks
36/8. Chapter:
The punishment of one who drinks Khamr if he does not repent from it: he will be denied it in the hereafter
Sahih Muslim
حَدَّثَنَا يَحْيَى بْنُ يَحْيَى، قَالَ قَرَأْتُ عَلَى مَالِكٍ عَنْ نَافِعٍ، عَنِ ابْنِ عُمَرَ، أَنَّ رَسُولَ اللَّهِ صلى الله عليه وسلم قَالَ " مَنْ شَرِبَ الْخَمْرَ فِي الدُّنْيَا حُرِمَهَا فِي الآخِرَةِ " .
Ibn 'Umar reported Allah's Messenger (ﷺ) as saying: He who drank (wine) in this world would be deprived of it in the Hereafter.
Reference : Sahih Muslim 2003eIn-book reference : Book 36, Hadith 96USC-MSA web (English) reference : Book 23, Hadith 4967