كتاب الأشربة
36  
The Book of Drinks
(8)
Chapter: The punishment of one who drinks Khamr if he does not repent from it: he will be denied it in the hereafter
(8)
باب عُقُوبَةِ مَنْ شَرِبَ الْخَمْرَ إِذَا لَمْ يَتُبْ مِنْهَا بِمَنْعِهِ إِيَّاهَا فِي الآخِرَةِ ‏‏
Sahih Muslim 2003 e

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 2003e
In-book reference : Book 36, Hadith 96
USC-MSA web (English) reference : Book 23, Hadith 4967
  (deprecated numbering scheme)