Oh gosh, I missed the "com" when I first read this. The phrase has a different meaning with that reading!
Yes, without the "com" it means 'when will you drink my friend" and it's a really, REALLY creepy sentence
I am Brazilian and I cannot have understand the phrase. It not sounds natural.
Would "quando você vai tomar uma bebida com meu amigo?" sound more natural?
Yes, it sounds natural =)