topic Re: Performance Issue in Application Development and Automation Discussions

Performance Issue

Former Member — Mon, 12 May 2008 18:53:34 GMT

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

Re: Performance Issue

Former Member — Mon, 12 May 2008 19:04:01 GMT

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.

Re: Performance Issue

Former Member — Mon, 12 May 2008 19:05:00 GMT

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

Re: Performance Issue

Former Member — Mon, 12 May 2008 19:13:57 GMT

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.