Any pointers as to where I can get Sweet Cherry Wine alongwith its German name would be highly helpful ..

Are you refering to Röteli? It's a cherry liquor from the Graubunden / Grissons area, available in most places selling booze. Very cold it's almost palatable.

yes ..

someone suggested Aldi to be also an option to try .. will check if they have it ..