Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Regarding Table Validation Logic

Hi Friends

I am doing some Table validations.

My table contains:

<b>A/C Number ValidFrom Text ValidTo Code</b>

The requirement is : No overlapping entries if the month of the new from date is greater than the month of the existing from date are allowed.

I had written some logic to handle this.

But when user enter like

000001 02.11.2007 test1 10.11.2007 ab

000002 11.11.2007 test2 20.11.2007 cd

The above 2 are valid entries because no overlapping here.

Ofcourse my logic working perfectly for this case.

But suppose if the user changes the Todate of 1st entry as follws:

000001 02.11.2007 test1 <b>12.11.2007</b> ab

000002 11.11.2007 test2 20.11.2007 cd

In this case it's has to give a error message because these are overlapping here.

Here my logic is failing.

Can anyone please suggest me the logic to handle this case.

<b>Points are assured for useful answers.</b>




Helpful Answer

Not what you were looking for? View more on this topic or Ask a question