How to maintain multiple database table through one mask screen

[Former Member]

Dear Experts,

As I am a beginer in ABAP and I am in a  learning process so my question may reflect of basic level as well. Sorry for that. 

I have a requirement wherein I have 6 different database tables( with various fields and some of the fields of some of the database tables have one field which are = to each other).

Requirement: I want to create an UI/ mask screen in which the DATA of the above fields can be seen and through which they  can be DELETED, New fields datas can be entered and saved. i.e I want to maintain MULTIPLE Database tables through one Mask screen / UI.

I know Table Maintenance generator but it can be used only to maintain one Table.

How can I do this? Looking forward for suggestions from you experts.

Regards

Chandan

[Former Member]

Dear Sir,

Ya that is also a good idea but my problem is that I want to create the UI/ mask screen through which the contents (data) of various database tables can be maintained and give this UI/ mask screen into the hands of an user who doesn#t knows much of ABAP/ SAP.

Thorugh this screen he/she with the help just selecting few button by a click can easily maintain the database table. That is my idea or requirement.

A mask screen with few buttons/ options which can provide an acceess to this User an access to maintain Database table with an ease.

Looking forward for your suggestion.

Regards

Chandan

[Former Member]

hi Chandan

Maybe you can create a new FORM routine on TMG event '02'.

In this form, write sql to update other database tables.

How to create a form routine you can refer this link, http://wiki.scn.sap.com/wiki/display/ABAPch/EVENTS+IN+TABLE+MAINTENANCE

But, there are a fields problem. i mean, all the field must belong one table.

regards,

Archer

[matt]

Chandan Kumar wrote:



I know Table Maintenance generator but it can be used only to maintain one Table.

Then you know incorrectly. Search for "cluster maintenance".

[Former Member]

Dear Sir,

Ya that is also a good idea but my problem is that I want to create the UI/ mask screen through which the contents (data) of various database tables can be maintained and give this UI/ mask screen into the hands of an user who doesn#t knows much of ABAP/ SAP.

Thorugh this screen he/she with the help just selecting few button by a click can easily maintain the database table. That is my idea or requirement.

A mask screen with few buttons/ options which can provide an acceess to this User an access to maintain Database table with an ease.

Looking forward for your suggestion.

Regards

Chandan

[matt]

Well, if you can't use cluster maintenance, then you need to either use classic dynpro (that is module pool) programming, or develop using Web Dynpro. Telling you how to do this is tantamount to giving you the contents of several five day courses at the SAP Academy, and so not in the scope of this discussion.

[Former Member]

Dear Mr. Billingham,

Just one technical info I need from you. Cluster maintenance can be used only in SAP versions: SAP ABAP/ SAP ECC (4.7) / SAP ECC (6.0).

Being a beginer in ABAP I have for my practice the "minisap". So can I perform cluster maintenance in this minisap version of SAP.

Looking forward for your suggestion.

regards

Chandan

[Former Member]

Thanks, i even don`t know this.  i test a sample, works fine.

[matt]

I suggest you search and work out how to find what version of sap you are on. Or even how to get a more up-to-date version.

[Former Member]

It's Billingham, not Buckingham.

[Former Member]

Dear Mr. Billingham,

Your suggestion about "Cluster Maintenance" was right. Had idea about Table Maintenance generator but not about Cluster. thanks for throwing ligh on that.

I am also trying to perform database table maintenance through WEBDYNPRO.

Being new to ABAP your suggestion are valuable for to the point learning. Thanks.

regards

Chandan