SM30 Validations

[former_member213112]

HI,

I have created SM30 for 2 tables say A & B with validations & logic in both the tables, which is having same primary keys for both the tables. So now the question is when user enters a primary key in table A same should be updated in table B automatically and when user removes entries from table A same should be deleted from table B automatically, this should work for multiple addition or deletion.

Need help on this

Regards,

Watch-point.

[Former Member]

Have you considered using a View Cluster?

[Former Member]

Hi,

This can be done through Table Maintenance Events

Event for your use is --02  After saving the data in the database--

Details given in below link

TABLE MAINTENANCE GENERATOR and ITS EVENTS - ABAP Development - SCN Wiki

[RaymondGiuseppi]

Did you consider creation of a View Cluster, first step would be correct foreign key relation between your tables.

Regards,

Raymond

[former_member213112]

Hi Raymond & Andre,

Yes I am considering View cluster in the event 5 whether work center is allocated to the plant & material is for valid for the plant or not same kind. I have written code in PBO for insert & at event 5 to delete the entry but this is not working for multiple insert & delete.

Regards,

watch-point.

[Former Member]

You do not need to implement table maintenance events. And please avoid changing the standard code generated by maintenance generator.

Just have a close look on the View Cluster. I think it will fit your needs.

[former_member213112]

Hi Andre,

I am using event because for some of the fields three tables are involved based on the entries of each table the validation changes and when it comes to PBO I have created separate Z module and calling that to insert & delete.

Regards,

[Sandra_Rossi]

Did you consider creating one table and 2 projection views with distinct maintenance dialogs?