Error in table maintenance

[Former Member]

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,

[Former Member]

Hi,

EVENTS:

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

Regards,

Shiva Kumar

[Former Member]

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

[Former Member]

Thanks Venkatachalam ,

Problem resolved points awarded.

Regards,