topic Time Dependent Table Maintenance in Application Development and Automation Discussions

Time Dependent Table Maintenance

Former Member — Tue, 08 Mar 2005 18:03:50 GMT

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).

Re: Time Dependent Table Maintenance

Former Member — Tue, 08 Mar 2005 19:12:38 GMT

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.

Re: Time Dependent Table Maintenance

Former Member — Wed, 09 Mar 2005 08:04:10 GMT

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.

Re: Time Dependent Table Maintenance

Former Member — Wed, 04 Jan 2006 18:18:08 GMT

Hi Subramanian,

We are running version 4.6C

Regards,

Bob