Data Consistency

There are three table it_a, it_b, It_c in the Sap DB, I have to keep the consistency of all the records. If there’s an error occurs, which may be trigger by the program, or by the independency,

How can I realize it, Very thanks in advance..