topic Error in table maintenance in Application Development and Automation Discussions

Error in table maintenance

Former Member — Mon, 26 May 2008 12:55:41 GMT

Hi all,

I have requirement to add events in table generator.For that i created the table maintenance and then add events also.

Added event 01 and 02 ie. event on before saving the data to database and event on after saving the database.

In event 01 my requirement is to check material whether that material exists in MARA table or not if not exists then display error message without saving the changes to databse and return to edit screen else do changes.

for ex. ZTESTMARA table with fields

MANDT

MARA

QTY

created two step maintenance screen 101 and 102.

while manually editing matnr that matnr doesn't exist in MARA table then it throws error message and screen comes to 101 but i want to throw error message and screen comes 102.

Any suggestion welcome..

Regards,

Re: Error in table maintenance

Former Member — Mon, 26 May 2008 13:04:48 GMT

Hi,

EVENTS:

http://help.sap.com/saphelp_nw70/helpdata/EN/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm

Regards,

Shiva Kumar

Re: Error in table maintenance

Former Member — Mon, 26 May 2008 13:14:17 GMT

Hai,

Just Validate the MATNR field from MARA table.

ie. Link forgin key for ZTABLE-MATNR to MARA-MATNR that time automatically validate.

Thanks,

Durai.V

Re: Error in table maintenance

Former Member — Mon, 26 May 2008 13:33:38 GMT

Thanks Venkatachalam ,

Problem resolved points awarded.

Regards,