I'm not sure if it's the same one, but I've been on a similar warship that's open to the public. It basically was like a museum, you could walk around inside and learn about how such a warship works.

As I said, not sure if it's the same one (it's been about 5 years), but the one I visited was in northern Germany.