general

[Former Member]

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 ?

[Former Member]

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

then generate a maintenance for the VIEW suing maintenance generator.

Regards,

Ravi

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi

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^

[Former Member]

Hai Mrudule,

<b>It is better to go for Database view.</b>

Follow the below steps:

<b>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.</b>

Hope this helps you a lot.

<b>Reward points if it helps you.</b>

Regds,

Rama chary.Pammi