topic Re: Regarding views in Application Development and Automation Discussions

Regarding views

sreeramkumar_madisetty — Mon, 09 Apr 2007 14:05:41 GMT

Hi Folks

I was developed a report and in that I am using the mara and makt tables.

Using the following I am fetching the data:

SELECT a_{matnr c}werks b_{maktx b}spras

a_{matkl a}mtart a_{meins a}ersda

INTO TABLE i_mara

FROM ( mara AS a INNER JOIN makt AS b

ON a_{matnr = b}matnr )

INNER JOIN marc AS c

ON a_{matnr = c}matnr

WHERE a~matnr IN s_matnr

AND a~matkl IN s_matkl

AND a~mtart IN s_mtart

AND a~ersda IN s_ersda

AND b~spras = 'EN'

AND c~werks IN s_werks.

But Client is not happy with the above statement's execution time so I need to reduce the execution time.

Can anyone help me that any Existed View is there for this purpose.

It's little bit urgent.

Regards,

Sreeram

Re: Regarding views

Former Member — Mon, 09 Apr 2007 14:11:41 GMT

Hi,

I think, you have to limit the Material Type and Material Group with some restrictions on the selection screen. give No extensions.

little changes for the select statement.

SELECT a_{matnr c}werks b_{maktx b}spras

a_{matkl a}mtart a_{meins a}ersda

INTO TABLE i_mara

FROM ( mara AS a INNER JOIN marc AS c

ON a_{matnr = c}matnr )

INNER JOIN makt AS b

ON a_{matnr = b}matnr

WHERE a~matnr IN s_matnr

AND a~matkl IN s_matkl

AND a~mtart IN s_mtart

AND a~ersda IN s_ersda

AND c~werks IN s_werks

AND b~spras = 'EN'.

Just check this statement and restrict MTART and MATKL accordingly.

reward points if useful

regards,

ANJI

Re: Regarding views

sreeramkumar_madisetty — Tue, 10 Apr 2007 05:51:16 GMT

Hi Anji

Thanks for your reply.

What are the changes you did for this select statement.

Because i am not able to find any changes.

Regards,

Sreeram

Re: Regarding views

Former Member — Tue, 10 Apr 2007 05:54:25 GMT

Hi,

Just observe the sequence of data fetching.

first join MARA and MARC then MAKT.

and in the where condition also changed the sequence of fields.

reward points for useful answers

regards,

Anji

Re: Regarding views

Former Member — Tue, 10 Apr 2007 06:16:10 GMT

i have also replied to your previous thread

just check

V_MATNR or

V_MATNR_HU

views if they are satisfying that or not? have checked these?

regards

shiba dutta

Re: Regarding views

sreeramkumar_madisetty — Wed, 23 May 2007 07:49:31 GMT

It's Answered.