GO:0009013:   succinate-semialdehyde dehydrogenase [NAD(P)+] activity
Catalysis of the reaction: succinate semialdehyde + NAD(P)+ + H2O = succinate + NAD(P)H + H+.