Catalysis of the reaction: (S)-2,3,4,5-tetrahydrodipicolinate + H2O + succinyl-CoA = L-2-succinylamino-6-oxopimelate + CoA.
succinyl-CoA:2,3,4,5-tetrahydropyridine-2,6-dicarboxylate N-succinyltransferase activity