Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Table Validation Logic

sreeramkumar_madisetty
Active Contributor
0 Kudos

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>

Regards,

Sree

1 ACCEPTED SOLUTION

Former Member
0 Kudos

loop at itab into wa_itab1.

v_index = sy-index + 1.

read table itab into wa_itab2 index v_index.

if wa_itab1-validTo > wa_itab2-ValidFrom.

message e000.

endif.

endloop.

here we r reading the consecutive records n checkin dates if its less dan prev date..else giv an error message

Hope dis helps..Reward points if it does

Regards

3 REPLIES 3

Former Member
0 Kudos

loop at itab into wa_itab1.

v_index = sy-index + 1.

read table itab into wa_itab2 index v_index.

if wa_itab1-validTo > wa_itab2-ValidFrom.

message e000.

endif.

endloop.

here we r reading the consecutive records n checkin dates if its less dan prev date..else giv an error message

Hope dis helps..Reward points if it does

Regards

Former Member
0 Kudos

Hi Sree,

Check ur int table sy-index.

within DO loop. check if ur 1st line ToDate > 2nd line From date. Then throw msg.

Regards

Srimanta

sreeramkumar_madisetty
Active Contributor
0 Kudos

Hi Friends

Thanks for your responses.

I need diffrent test perceptions how a lemon can enter the data into the above table

by violating the overlapping records constraint.

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

Regards,

Sree