topic validations in table maintance generator in Application Development and Automation Discussions

validations in table maintance generator

Former Member — Thu, 10 Jan 2013 11:24:14 GMT

Sir,

In my TMG there are fields district and warehouse. data was populated in to that TMG from upload program

the last four digits of the warehouse must be equal to the district code.

The data will be populated in wrong format for the warehouse field . the user will refer the district field and changes the last four digits

of the warehouse field.

so if he changes according to the district code which was available the data should save.

other wise it should throw a validation.

where can i write the validation in the TMG.

Thanks & Regards.

Re: validations in table maintance generator

former_member185848 — Thu, 10 Jan 2013 11:27:45 GMT

Hi,

There are events triggered in TMG.

Re: validations in table maintance generator

gouravkumar64 — Thu, 10 Jan 2013 11:33:48 GMT

Hi,

Some ways is there,

like the event.

this link will help u to understand

http://wiki.sdn.sap.com/wiki/display/ABAPch/EVENTS+IN+TABLE+MAINTENANCE

other is from table main, screen>system>status>program>in PAI >create a module.

U can write.ur logic/validation.

Hope it helps.

Thanks

Gourav.

Re: validations in table maintance generator

Former Member — Thu, 10 Jan 2013 11:40:45 GMT

Hi Satish,

As suggested by Gourav, you have use either of the two options, well using Table Maintenance Generater's Event will be better option, of these two.

Else you can also do the validation in your Upload Program.

Thanks.

Re: validations in table maintance generator

former_member491621 — Fri, 11 Jan 2013 16:53:10 GMT

Hi Satish,

You can use TMG events for your requirement.

You can also create a module in PAI for validating the data.

eg: FIELD <warehouse field> MODULE<your module>.

Here you can put your desired condition and display an error message if the condition fails.

I have tried this and it works perfectly

Re: validations in table maintance generator

Former Member — Tue, 15 Jan 2013 05:09:01 GMT

Sir,

Can pls post the code of what u have written.

Thanks & Regards.

Re: validations in table maintance generator

Former Member — Tue, 15 Jan 2013 05:51:28 GMT

Check above link..

Regard's

Smruti

Message was edited by: Vinod Kumar

Re: validations in table maintance generator

Former Member — Tue, 15 Jan 2013 06:24:00 GMT

hi,

create TMG, goto ENVIRNAMENT -> modifications -> events.

later u will be getting many events select BEFORE save events.

write code within method generate for the events and do validations there only.

like say you have field XXX of table abc should be 123 else you have through error then write like

if abc-xxx = '123'.

else.

"error'.

exit.

endif.

regards.

lingaraj.

Re: validations in table maintance generator

former_member491621 — Tue, 15 Jan 2013 06:29:31 GMT

Hi Satish,

Please follow the below steps:

1. Go to the FunctionPool of your TMG.(It must have name like ZSAPLTABLE where your table name is ZTABLE).

2. Create a new include with name ZLTABLEF01(This is required as the system gives a message saying 'User xxxxxx is currently editing the program ZSAPLTABLE'). Save and avtivate the program.

3. Now go to the screen flow logic of the TMG screen.

4. You have to write the code in bold as shown below

   LOOP AT EXTRACT.
   MODULE LISTE_INIT_WORKAREA.
   CHAIN.
    FIELD dist_code.

FIELD warehouse MODULE check_distcode(or whatever name you want to give).

5. Now double click on check_distcode and the system will ask if you want to create a new module. Click yes and select the name of the new include you have created in step 2 above.

6. Write the below code in the module

IF ZTABLE-warehouse+length(4) NE ZTABLE-distcode. (where length is the no. of digits before last 4 digits)

.... Throw up an error message

ENDIF.

7. Save and activate the module and the main TMG program. Check the validation in SM30.

Hope this helps

Reward points if helpful

Re: validations in table maintance generator

Former Member — Tue, 15 Jan 2013 07:08:04 GMT

Hi Satish,

Check this link.

http://help.sap.com/saphelp_47x200/helpdata/en/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm

"Before Saving the Data in the Database"

Regard's

Smruti

Re: validations in table maintance generator

Former Member — Fri, 18 Jan 2013 10:19:19 GMT

Sir,

Thank u i have completed the requirement.

Re: validations in table maintance generator

Former Member — Fri, 18 Jan 2013 10:21:35 GMT

sir,

thank u i have completed my requirement

Re: validations in table maintance generator

Former Member — Fri, 18 Jan 2013 10:22:08 GMT

Sir,

Thank u i have completed the requirement.

Re: validations in table maintance generator

gouravkumar64 — Fri, 18 Jan 2013 10:25:21 GMT

Hi,

So close this thread & mark it answered.

Reagrds

Gourav.