topic Re: Data validation in Table maintenance in Application Development and Automation Discussions

Data validation in Table maintenance

Former Member — Wed, 15 Nov 2006 21:16:15 GMT

Hello,

Can anybody tell me how to validate the data while entering in table maintenance screen ? I wanted to validate data based on certain conditions on custom table. I am using VIEW_MAINTENANCE_CALL thro abap report. Also the user should not be allowed to save the data if the condition failed.How to set default values for the field created in custom table ?

Thnx in advance

Anney

Re: Data validation in Table maintenance

Former Member — Wed, 15 Nov 2006 21:22:39 GMT

Re: Data validation in Table maintenance

Former Member — Wed, 15 Nov 2006 21:26:29 GMT

Hi,

Check these links..

https://forums.sdn.sap.com/click.jspa?searchID=66826&messageID=2434739

https://forums.sdn.sap.com/click.jspa?searchID=66826&messageID=2470794

https://forums.sdn.sap.com/click.jspa?searchID=66880&messageID=2403945

Thanks,

Naren

Re: Data validation in Table maintenance

uwe_schieferstein — Wed, 15 Nov 2006 21:32:43 GMT

Hello Anney

You have to use table maintenance events in your maintenance view (or table). Go to the table maintenance generator and choose menu Environment -> Modifications -> Events.

There you have to choose the appropriate event and define a FORM routine. This FORM routine is created within a form-include of the function group containing the maintenance dialogs.

If you want to set the default value at the start of the dialog and when the user creates new entries you will need events '21' (fill hidden fields) and '05' (creating a new entry).

For the events define a form routine within an include in your function group. There you have access to the structure of the view (e.g. z_tabl_view). There you fill z_tabl_view-column = <fixed value>.

For checking data before saving you will need event 01 (before saving the data in the database).

For detailed information please refer to the SAP online documentation:

<a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/content.htm">Extended Table Maintenance Events</a>

Regards

Uwe

Re: Data validation in Table maintenance

Former Member — Wed, 15 Nov 2006 22:28:24 GMT

Hi,

As suggested I tried to create using event '05' as i need to validate by existing data in the custom table . But its asking for include . And it says program L...are reserved for function group includes. So what shall i do now ?

Is there any alternative solution ?

Regds

Anney

Re: Data validation in Table maintenance

Former Member — Wed, 15 Nov 2006 22:30:40 GMT

Hi,

Go to SE80 give the function group that you used for creating the table maintenance..

Choose the main program..

Get it into change mode..

Give INCLUDE Z_CUSTOM_INCLUDE..

Double click on the include..Then create it..

Thanks,

Naren

Re: Data validation in Table maintenance

Former Member — Wed, 15 Nov 2006 23:29:33 GMT

you can hit enter a create the Include. The created include is a user created for the event. In Se80 for the function group check for the main program. But in the include you have give the form name. CHECK_DATA( whatever u have given for the event) is nothing but the form name you have given for event 05.

in the Include file which the system suggested

FORM CHECK_DATA

what ever the code

ENDFORM.

After activating the include also activate the main program also.

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 15:43:45 GMT

Hi Eda,

I tried to give the validation inside the form ... endform as suggested but it says perform is missing . Also i wanted to validate the current processing custom table so which event do i need to use .

rgds

Anney

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 15:46:10 GMT

This article should clear all your doubts

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

Regards,

Ravi

Note - Please mark all the helpful answers

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 15:46:58 GMT

Hi Eda,

I tried to create inside the include ,

module check_data.

perform check_data.

endmodule.

but it says 'main program for include not found'

regds

Anney

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 15:52:49 GMT

are tring a new PBO or PAI or is it just for event 05 cause if its only validation then a type of subprogram should be fine and with in this

form

endform as a routine should work.

*******************************************************************

User-defined Include-files (if necessary). *

*******************************************************************

* INCLUDE LZTABF... " Subprograms

INCLUDE LZTABO... " PBO-Modules
INCLUDE LZTABI... " PAI-Modules

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 15:59:20 GMT

to add on in the EVENT FORM ROUTINE

give the event as 05 and in form routine : check_data

on the right side click on the editor and it sould create the include. In this include

form check_data

break-point.

endform.

Activate the include as well as the main program from se80 before you run it in sm30.

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 16:27:16 GMT

Hi Eda,

I did the same whatever you have mentioned . But still when I am running the report if I click on save it throws the errror as PERFORM_NOT_FOUND.

Is there any other way that I can write include in PBO or in PAI ? As I need to have default values also. I am not sure . Kindlu suggest me.

Regards

Anney

Re: Data validation in Table maintenance

Former Member — Thu, 16 Nov 2006 17:38:18 GMT

from se11 when you go to the maintenenace, was the table saved and activated after you created the event modification?