"Weenie" (the usual spelling) is well known in the US though mostly as a childish or jocular euphemism.
Same with "wiener." And, yes, both literally mean a Vienna sausage.
A frankfurter is also sometimes called a wiener or a weenie, though "weenie" is usually jocular.