Performance Issue

[Former Member]

Hi All,

Can you please tell me what exactly the table views are, actually I have created a report and it has got some performance issues, and I have been told to use views instead of tables, so can you please tell me how to create a view for tables. Please explain me with an example.

Thanks,

Rajeev

[Former Member]

Hi!

There are four types of Views. You'll need to analyze your context and see which one is the best for your situation

Here is some useful documentation about the four types of view:

[Creating Views|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm]

Hope it helps!

Regards.

[Former Member]

In SE11 we can create views.

Check this out.

http://www.sap-abap4.com/sap/se11/

Check this Views and see the Selection Conditions, Table/Join Conditions and u can also view the fields in it.

V_MMIM_LN.

V_MMIM_KN

V_MMIM_ON

and u can execute it and the corresponding records are displayed.

Hope it helps

Thanks,

Chaithanya

[Former Member]

Hi Rajiv,

Creating view is not a big deal

Select the view button and create the name with 'Z'

there u can mention the option which u want join instead of inner join in ur program and even u can select the required feilds in ur own structure.

u can use this view as direct data base table in ur program.

Its simple way to explain

Thanks

Pathan.