topic Re: Create transparent table : overlap record in Application Development and Automation Discussions

Create transparent table : overlap record

Former Member — Fri, 26 Dec 2014 09:50:26 GMT

Hi all and happy Christmas !!

Well, i need to create a new transparent table, but his records do not have to overlap.

For example the following record c2 will not be recorded because of their date overlap with record C1.

CODE BEGDA ENDDA

C1 01.01.2014 31.12.2014

C2 01.05.2014 05.10.2014

But how can i do from a technical point of view ? I know the time dependent function in the Table Maintenance Generator but how it works ?

Thanks for your help.

Re: Create transparent table : overlap record

ipravir — Fri, 26 Dec 2014 10:18:02 GMT

Hi Eric,

If you are providing the table Maintenance Generator to Update the Information.

You can put a validation on event 01 / Before Saving the Data in Database table.

you can use the IN BETWEEN method to validate the entered date is already overlapping

with other entered or old records information.

Regards.

Praveer.

Re: Create transparent table : overlap record

Former Member — Fri, 26 Dec 2014 10:28:36 GMT

Hi Praveer,

thanks for your answer, can you explain me event 01 and IN BETWEEN method ?

Re: Create transparent table : overlap record

ipravir — Fri, 26 Dec 2014 10:32:33 GMT

Hi Eric,

Go to the Table Maintenance Generator screen through SE11.

In Menu Environment->Modification->Events

after select you will get a new screen same like Table Maintenance, you have select "New Entry" and in Editable mode you have to select an Event (Through F4).

Based on the selected Event a code will auto Generate in your Table's Function Group.

Inside the PERFORM routine, you have to write your logic.

Hope this will help you.

Regards.

Praveer.

Re: Create transparent table : overlap record

Former Member — Fri, 26 Dec 2014 11:56:08 GMT

Thanks a lot Praveer