Skip to Content
Former Member
Jun 16, 2008 at 03:05 PM

Checking for values in a check table with an interval


Hi experts,

I have a Z table with a check table(T706B1) for the field SPKZL, it also has a BEGDA(Begin date) and ENDDA(end date). What I want to do is when inserting new data the table would verify if the fields BEGDA and ENDDA in my Z table are in the corresponding intervals of the field SPKZL in the check table(T706B1- also named BEGDA and ENDDA), if they aren't in the interval it should not allow the new entry to be inserted.

Is there any way to do this?

Thank You

David Pereira