Regarding views

[sreeramkumar_madisetty]

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

[Former Member]

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

[sreeramkumar_madisetty]

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

[Former Member]

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

[Former Member]

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

[sreeramkumar_madisetty]

Hi

It's Answered.