topic Re: Regarding views in Application Development and Automation Discussions

Regarding views

sreeramkumar_madisetty — Tue, 10 Apr 2007 04:21:19 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 — Tue, 10 Apr 2007 04:26:53 GMT

Hi,

You can use the statement by joining the tables MARA and MAKT. Later on based on the records you get select data from MARC table.

Split the select statement into two as below.

SELECT a_{matnr 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

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'.

If not i_mara[] is initial.

select matnr

werks

from AMRC

into table i_marc

for all entries in i_mara

where matnr = i_mara-matnr.

endif.

Regards,

Ram

Reward points if helpful

Message was edited by:

Ram Mohan Naidu Thammineni

Re: Regarding views

Former Member — Tue, 10 Apr 2007 04:28:19 GMT

Would 'JPV_MAT_ORG' this help ?

Re: Regarding views

Former Member — Tue, 10 Apr 2007 05:05:57 GMT

use

V_MATNR or

V_MATNR_HU

regards

shiba dutta

Re: Regarding views

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

It's Answered.