This already exists
Take a look at Page 32 of the GRW (Grundregelwerk) for DSA5 (german version) - It is called Stunned ("Betäubung")
This might not sound at all like what you are looking for, but the description text says that you can get this condition by "too much wine, tiredness or a good brawl".
The penalties are more in line with what I would have chosen, too. The condition only gives penalties to all tests ("Proben") depending on the level of the condition (1 to 3), and stops you from doing anything at level 4.
Regarding your homebrew idea:
Attribute penalties are not a good idea
Take a look at the other conditions, like wounded ("Schmerz") or disorientation ("Verwirrung"), they don't give you any penalties to attributes, only to stuff like initiative, attack, parry and the like. This is (probably, as I can only guess the designers intentions) to prevent the players from having to do any math with their attributes, like reducing some derived values (Hit Point max, Astral Energy max and so on) as a result of loosing points in an attribute. This takes away time and confuses people. "Do my current astral points or hit points go down, too?" is only one question that I heard people asking in DSA4, where attribute penalties happen relatively often. And the book had no real answer for that.
Take your time with homebrewing, get to know the game first
In your other question you state that you and especially your group are new to DSA. I would recommend you to follow this advice: get to know the game first, before trying to hack (to homebrew) it
I can tell you from experience that this will work out much better, as having an understanding of the rules will allow you to better decide for yourself if something is balanced or even (like in this example) needed. Trying to make a game even better is a good and cool thing, but without a good understanding of not only how the game works but also how different pieces of the game work together, you are going to throw stones in your own path and make the game even more complicated than it already is. If you play DSA5 for a bit and decide you want more complicated rules (I would not really call it "realistic", personally, but your opinion may vary), you can still switch to DSA4.1