Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How to maintain multiple database table through one mask screen

Former Member

‎2014 Apr 25 8:06 AM

0 Likes
1,241

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

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

Reply
9 REPLIES 9
Read only

Former Member

‎2014 Apr 25 8:42 AM

0 Likes
1,176

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

Read only

matt
Active Contributor

‎2014 Apr 25 9:01 AM

0 Likes
1,176 


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".

Read only

Former Member
In response to matt

‎2014 Apr 25 9:17 AM

0 Likes
1,176

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

Read only

matt
Active Contributor
In response to matt

‎2014 Apr 25 9:26 AM

0 Likes
1,176

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.

Read only

Former Member
In response to matt

‎2014 Apr 25 10:14 AM

0 Likes
1,176

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

Read only

Former Member
In response to matt

‎2014 Apr 25 10:24 AM

0 Likes
1,176

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

Read only

matt
Active Contributor
In response to matt

‎2014 Apr 25 10:26 AM

0 Likes
1,176

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.

Read only

Former Member
In response to matt

‎2014 Apr 25 1:38 PM

0 Likes
1,176

It's Billingham, not Buckingham.

Read only

Former Member
In response to matt

‎2014 Apr 29 11:12 AM

0 Likes
1,176

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