The story
Based on the idea that the player was only there long enough to have a cup of coffee.
Etymology from Wiktionary, CC BY-SA 4.0.
cup of coffee
Today it means: The situation where a minor league player comes up to the major league team for a short period of time. Full definition →