Time Dependent Table Maintenance

[Former Member]

I am creating a table maintenance view on a table with time dependent entries ( validity period ) . I created the table with a valid-from date as part of the key ( using data element BEGDA ) and the valid-to date as a non key column. My question, other than writing my own custom code at one of the predefined Events isn't it possible to generate the maintenance dialog such that overlapping validity periods will be prevented? I am pretty sure I was able to do this in the past but cannot recall how. My example is: Lets say I have a row with a validity period of 01/01/2004 to 12/31/2004. User then creates a new row with the same key ( key fields excluding valid-from )

with a validity period of 03/01/2004 to 05/31/2004. I would expect the generated code to recognize that 3 rows would now be required, (01/01/2004 - 02/29/2004, 03/01/2004 - 05/31/2004 and 06/01/2004 - 12/31/2004).

[Former Member]

Problem Solved. After Creating Maintenance View

Execute transaction (SE54).

Enter the table name.

Set the Generated Objects flag.

Choose Create/Change.

Choose Environment ® Time-Dep. in the next screen. Generate.

[Former Member]

Hi Bob,

Read your post and was delighted to know the way you approached and solved the problem. However, when I tried, I did not find the Time Dependency at all.

Till Environment, I had no issues, but I didn't find the Time Dependency at all in one of the sub-menu items.

Which version are you working on ?

Best Regards,

Subramanian V.

[Former Member]

Hi Subramanian,

We are running version 4.6C

Regards,

Bob