The question is worded incorrectly...there are two kinds of foreigners:
1.) The refugee, the foreigner (now mostly from 3 world countries), who is taken in because of our duty to help those in need. He is not expected something else but to be a welfare burden. When he finds a way to make a life, get a job and to pay us back, great...but he is only here till the situation in his home country gets better.
The duty to offer asylum to refugees is something which still finds a great majority in Germany!
And then there is that:
2.) People without having any claim to any refugee/asylum status (also now mostly from 3 world countries), in search for work or just a better life. Nobody wants them to be a welfare burden.
I blame in big parts the dumb and unskilled immigration policy of the german govs during the last decades that both groups have become entangled and muddled.
Also that many foreigners claim to be asylum seekers because they know they wouldn't have a chance to be let in otherwise.
The subsequent process to separate the wheat from the chaff has become incredible bureaucratic, longwired and complicated with the consequence that many people are abusing our generally accepted and widely supported right of asylum and have become undeservedly a burden to our welfare system. And even once they have been found out that they are here illegally, our laws are such that many of them are still allowed to stay here...which is making some blood boiling!
So...when you don't differentiate between these two groups of 3 world immigrants you won't understand the numbers.