how to create view with many tables

[Former Member]

Hi..

how to create view with tables like mara mvke makt mast tables and how to make innerjoin relation for this tables...

reply me as soon as possible..

with regards

kiran

[Former Member]

Hi Kiran,

1.Goto transaction SE11, Put new View name zview1 and click on create button.

2. Select database view on next screen.

3. On next screen under leaft hand tables put all table names. i.e mara mvke makt mast and undet right hand table put the relationship between table..( Join with primary key ) and activate it.

thats it.

Cheers,

Nilesh

Message was edited by: Nilesh Kshirsagar

[Former Member]

hi,

u will required info. in this:

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

award pts. if it helps.

regards,

keerthi.

[Former Member]

Hi,

Its not a good practice to create views for many tables. Couple tables its fine but its not good to have a view created for multiple tables. It ultimately does a join on all the tables and it effects the performance.

Cheers

VJ

[govind_seenivasan]

Hi Kiran,

Use SE11 Tcode. Select the Views Radio Button, Click Create. thats it. Goto Talble / Inner Joins tab, Select the Tables you want to include in the list of tables. Type the Join Conditions.

Then go to To view the fields Tab, Select the table fields to list in your view.

Thats it....

-govind

[Former Member]

Hi,

Goto SE11

select views and press create then you have to give all your table names and in other tab (in same screen) you need to give condition for example

table name,field name '=' table name, fieldname

Cheers,

Bujji

[former_member181962]

Go to se11.

Select View radio-button.

Click Create button.

Give the tables and table fields that you want to join in the subsequent screens.

Save the technical attributes and then activate the table definition.

Refer this link for more info:

http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21ed06446011d189700000e8322d00/frameset.htm

Regards,

Ravi

[LucianoBentiveg]

Look up in SE11 for a view with those chars.

Example VEDIEDIFCT.

Regards.