Create Table/View with Validity Date Control?

[Former Member]

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

[Former Member]

K, so I found these

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/91/ca9fb3a9d111d1a5690000e82deaaa/content.htm">SAP Help - Time-Dependent Table/View</a>

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/c1/df5c3c3b067331e10000000a114084/content.htm">Generate Time-Dependence</a>

I'll give it a whirl now.