finding views

[Former Member]

hi dar

how to see whether there is any view provided by SAP on those base tables?

[Former Member]

Hi,

Just do a where used list on the tables and select views in that.

Regards,

Atish

[Former Member]

hi atish,

thans for responce.

i am joining on mseg and mkpf . but i got a view V_MKPF. i know it will give better performance with view.

but i got only few fields available in view, where as i need lot of fields from mseg and mkpf.

am giving my code here. this statement is used 5 times with a change in two field values in where clause.

SELECT

a~mblnr

a~zeile

a~mjahr

a~werks

a~lgort

a~matnr

a~menge

a~meins

b~budat

b~cpudt

b~cputm

a~aufnr

a~lgnum

a~lgpla

a~tbnum

a~bwart

a~ebeln

INTO TABLE gt_mseg

FROM mseg

AS a INNER JOIN mkpf

AS b ON a_{mblnr = b}mblnr

AND a_{mjahr = b}mjahr

FOR ALL ENTRIES IN gt_matnr "MB

WHERE a~bwart IN gr_bwart

AND a~matnr EQ gt_matnr-matnr "MB

AND a~werks EQ p_werks

AND a~lgort EQ p_lgort

AND a~kzbew EQ 'B'

AND b~cpudt GE gw_ref-l_date

AND a~lgnum EQ p_lgnum.

plz suggest!

[Former Member]

Hi,

In such case create one more custom view and use that in program.

Creating a view with all your required fields is the better option as it will have good performance as well.

Regards,

Atish

[Former Member]

hi