Skip to Content
0
Former Member
Nov 08, 2006 at 01:11 AM

Create Table/View with Validity Date Control?

38 Views

Hi,

does anyone know the easiest way for me to create a custom view that uses validity dates to control records by time periods, similar to time constraint 1 infotypes in HR?

For instance, if I define a table to store entries like so

Client (Key): 100

PSubArea (Key): C001

Grouping (Key): 01

End Date (Key): 99991231

Begin Date: 18000101

and I want to ensure that there can only be one record active on any given date, how can I prevent someone from creating a record from 20061107 - 20071107 that overlaps the existing record?

Is there a setting I missed?

Add conditions to generated view coding? Is there a good example?

Thanks