Hi All , validating in table maintenance

[Former Member]

how to validate the entries when we are entering in a table maintenance in sm30 by pressing new entries.

for ex:

From Date Fromperiod To Date To period

01.02.2008 05 11.02.2008 11

when the user enters the from date and to date it has to validate whether from date is less than to date and vice versa.

its urgent .

Thanks & Regards.

Bharat .

[Former Member]

how to validate the entries when we are entering in a table maintenance in sm30 by pressing new entries.

for ex:

From Date Fromperiod To Date To period

01.02.2008 05 11.02.2008 11

when the user enters the from date and to date it has to validate whether from date is less than to date and vice versa.

its urgent .

Thanks & Regards.

Bharat .

[Former Member]

Hi Bharat,

Please check this post

Best regards,

raam

[Former Member]

Hi Raam,

Pls send me the code as per my requirement.

Regards.

Bharat

[Former Member]

Hi Bharat,

Please check this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-87652872...

In the Third Step mentioned above select Event 05 --> Creating a New Entry

and write a Subroutine name and click on Editor and write the required code .

If <table_name>-from_date GE <table_name>-to_date .

MESSAGE ID <id> TYPE <t> NUMBER <n>.
or 
MESSAGE tnnn(id).

endif.

Best regards,

raam

[Former Member]

Hi Bharat,

Try the Following Steps,

1. Go to SE11 and enter your table name (ZTEST)(Go to change or create mode).

2. once complete your table creation than active the table, go to step 3.

3. go to the menu Utilities-->Table Maintenance Generator

4. Environment>Modification> Events.

5. Click 'New Entry Button'.

6. Validate your data in the events 01 and 05.

or

Go to the function group in se80 and directly validate your fields in the PAI event of the table maintenace screen but this is not recommend by SAP.

Reward if it is useful.

Regards,

Boobalan Suburaj

[Former Member]

Hi,

For your Table Maintenance Generator, Standard SAP Program SAPZXXXX will be created for your table/Views.

You can go to the Program and the screen you have created for it.

Double click the Screen No & click Flow Logic.

Under that, you will find PAI Event, with the fields you are having for the rable.

Choose the selected fields for validation under CHAIN... ENDCHAIN, with Module for validation.

Do validations in the module as per your requirement.

Hope it helps you.

Regards,

Anbalagan