ENDDA and BEGDA adjustment in table maintenance generator

[former_member440107]

I have to make the table maintenance for the interest tables where the rate is defined on the date ranges

from BEGDA to ENDA like

4%     10.10.2013 - 31.10.2013

5%      01.11.2013 - 31.12.9999

Now if a new entry needs to be maintained in this table maintenance like from 01.12.2013

It should automatically adjust itself like this

4%     10.10.2013 - 31.10.2013

5%     01.11.2013 - 31.11.2013   " Adjusted as soon as the user enters

6%     01.12.2013 - 31.12.9999

[former_member188827]

Please make endda your primary key and begda should not be the key field in your table. Your requirement will be fulfilled by this as delimit option will automatically be activated.

Regards

[former_member440107]

what are these delimit options.

[Former Member]

Hi Nikhil,

Delimit option refers to vaidity of a particular record.

[former_member188827]

When you insert new record, the validity of last active record would automatically be changed which is what you require.

Regards

[Former Member]

Hi All,

Thanks nikhil for posting this question. Even i have got the same issue.

Can you please be more descriptive and explain the process of doing it. Suppose i have got 3 fields BEGDA ENDDA(Primary Key) and INTEREST_RATE. How do i suppose to delimit the ENDDA??

Regards

[Former Member]

Hi,

You can handle this in events in TMG.

You can add custom logic to update the existing records, whenever a new entry is created,

Do a check on the dates of the new entry and modify existing entries accordingly.

Regrads,

MB

[SuhaSaha]

There is no need to write any code in the TMG events for this...

Since you have defined the table fields as BEGDA & ENDDA; i think it'll be easier for you to define a Time-Dependent table/view. SAP will do the rest to "delimit" the data for you.

You can search for available content for further details

[former_member440107]

Hi

Not able to achieve the desired result. Can someone elaborate more with the example to achieve the desired result as required in the original main post.

Regards

Nikhil Jain

[raymond_giuseppi]

Some questions :

• Did you apply the standard SAP solution like described in  Suhas Saha's link ?
• What are now the primary keys of your table ?
• Did you read the document following Time-Dependent Table/View in SAP documentation, Generate Time-Dependence ?
• Are you working on a (very) old version of SAP, then you may require to execute report RSVIEWTD (ref : Note 92394 - Time dependency for customer tables not usable)

Then if the standard solution does not fulfil you requirement, you may have to build your own program for maintenance or manage it by using Extended Table Maintenance Events.

Regards,

Raymond