Time Dependent Table

Former Member — Wed, 07 May 2014 08:35:10 GMT

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

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

Re: Time Dependent Table

Former Member — Wed, 07 May 2014 08:59:36 GMT

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.

topic Time Dependent Table in Application Development and Automation Discussions

Time Dependent Table

Re: Time Dependent Table