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?