Time Dependent Table

[Former Member]

Hi all,

I have one requirement in which I want non overlapping periods as BEGDA and ENDDA.

In time dependent table I am not able to achieve it

Like

Customer XYZ in Company code ABCD having some periodicity for materials to take. He can take only one material.

Maintainance like given below:

ABCD     XYZ     01.01.2014     01.02.2014

ABCD     XYZ     02.02.2014     01.03.2014

is OK

ABCD     XYZ     01.01.2014     01.02.2014

ABCD     XYZ     05.01.2014     01.03.2014

is Not OK

I am trying to use events in TMG

Can this be obtained through some standard functionality as there can be many cases related to Employee in HR module.

Regards

Nikhil Jain

[Former Member]

Hi,

If you are using TMG events then you try this coding.

Fetch the latest record for the customer and company code i.e which has highest ENDDA(you can use MAX aggregate). Now check the BEGDA of the record that you are trying to insert with ENDDA. If it is less than or equal to that then it means it is overlapping.

Regards,

Aswath.