Outside south Asia, accredited MBA programmes are open only to participants with substantial work experience. Take a look at the FT MBA ranking, so long as you first learn fluent German, any of those programmes in Germany will be very likely to place you.

Maybe I was not clear enough, I am not looking for the stereo MBA course, but for a course which might be specially designed for mid managers. Does German institute provide such courses?

Yes. Please read my answer again.

The strong accredited full time MBA programs in Germany - ESMT, Frankfurt, Mannheim, etc. - usually recruit candidates with between 5-8 years of work experience on average. You'd be coming into a class like that with substantially more experience. However, the alternative would be an executive MBA program, which is generally designed for those who a lot of work experience and who don't want to make substantial career shifts.

The full-time programs are probably more appropriate for your goals, but you'll have to convince them that you do need an MBA at this point in your career, with your experience level.