Create transparent table : overlap record

[Former Member]

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.

[ipravir]

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.

[Former Member]

Hi Praveer,

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

[ipravir]

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.

[Former Member]

Thanks a lot Praveer