topic general in Application Development and Automation Discussions

general

Former Member — Thu, 26 Apr 2007 10:09:36 GMT

i am having two ztables zstudent,zstudent_marks,the primary key for both the fields is sno.i want to join the two tables by maintanence view is it possible if so how ?

Re: general

Former Member — Thu, 26 Apr 2007 10:12:34 GMT

Go to se11 and create a View between the two tables.

then generate a maintenance for the VIEW suing maintenance generator.

Regards,

Ravi

Re: general

Former Member — Thu, 26 Apr 2007 10:14:11 GMT

Ya Naga,

That is possible.

Create the Maintenance type View from SE11.

Simply give all the tables names that you want and specify the fields that you want to display in the view.

This will work.

Reward Points if helpful,

Regards,

Tejas

Re: general

Former Member — Thu, 26 Apr 2007 10:18:04 GMT

naga,

1. Select the particular table in transaction SE11.

2. Press Change button

3. Use the menu Utilities->Table Maintenance Generator

4. Give Authorization code (&NC&)

5. Give Functiongroup (can be created using SE80)

6. Maintenance type (one step)

7. Click the find Scr number and ask the system to propose the number.

8. Save the same and activate.

9. Then you can use SM30 to mainitain the data.

For more information, please check this link.

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Don't forget to reward if useful

Re: general

Former Member — Thu, 26 Apr 2007 10:18:51 GMT

naga,

1. Select the particular table in transaction SE11.

2. Press Change button

3. Use the menu Utilities->Table Maintenance Generator

4. Give Authorization code (&NC&)

5. Give Functiongroup (can be created using SE80)

6. Maintenance type (one step)

7. Click the find Scr number and ask the system to propose the number.

8. Save the same and activate.

9. Then you can use SM30 to mainitain the data.

For more information, please check this link.

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Don't forget to reward if useful

Re: general

Former Member — Thu, 26 Apr 2007 10:19:25 GMT

hi tejas

i am able to enter only one table in tables bcz only one line is enabled and other lines are disabled then how can i write the table names

Re: general

Former Member — Thu, 26 Apr 2007 10:24:40 GMT

good

you can create the veiw for both the tables in se11

http://help.sap.com/saphelp_nw04/helpdata/en/f5/35c83ecedc636be10000000a114084/content.htm

THANKS

MRUTYUN^

Re: general

Former Member — Thu, 26 Apr 2007 10:32:03 GMT

Hai Mrudule,

It is better to go for Database view.

Follow the below steps:

Go to Se11-->Give viewname(ZSTUDENT),

Give Short Description,

Type table names(ztables zstudent and in the next line zstudent_marks )

Type join condition at join Tables/Join Conditions tab.

In the View Fields tab,Give the Field Names that ypou want to see in the View Output.

Hope this helps you a lot.

Reward points if it helps you.

Regds,

Rama chary.Pammi