The calculated distance (air line) between Schöppenstedt and Cologne is approximately 184 miles respectively 297 kilometers.
By car or train, the actual journey to Cologne is certainly longer, as only the direct route (as the crow flies) between Schöppenstedt and Cologne has been calculated here.
Air line (approximately)
297 kilometers
160 nautical miles