It is narrated from Sayyiduna Ibn Abbas (may Allah be pleased with them both) that it was said: "O Messenger of Allah (peace and blessings be upon him)! Will we have intimacy with our women in Paradise just as we do in this world?" He (peace and blessings be upon him) said: "By the One in whose hand is the soul of Muhammad (peace and blessings be upon him)! Indeed, a man will go in to a hundred virgins in a single morning."
Imam Abu Ya'la recorded this hadith with a da'if (weak) chain, because the narrator Zayd al-Ammi in it is weak; however, a narration of Sayyiduna Abu Hurayrah (may Allah be pleased with him) supports it as a corroborating report (shahid), which Imam al-Bazzar recorded with a sahih (authentic) chain.