topic Re: SM30 Validations in Application Development and Automation Discussions

SM30 Validations

former_member213112 — Thu, 08 Sep 2016 13:24:09 GMT

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.

Re: SM30 Validations

Former Member — Thu, 08 Sep 2016 13:33:56 GMT

Have you considered using a View Cluster?

Re: SM30 Validations

Former Member — Thu, 08 Sep 2016 13:36:05 GMT

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

Re: SM30 Validations

RaymondGiuseppi — Thu, 08 Sep 2016 13:36:10 GMT

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

Regards,

Raymond

Re: SM30 Validations

former_member213112 — Thu, 08 Sep 2016 13:48:46 GMT

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.

Re: SM30 Validations

Former Member — Thu, 08 Sep 2016 13:54:55 GMT

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.

Re: SM30 Validations

former_member213112 — Thu, 08 Sep 2016 14:06:06 GMT

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,

Re: SM30 Validations

Sandra_Rossi — Thu, 08 Sep 2016 19:36:28 GMT

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