JOIN VBRK VBRP : BAD performance

[Former Member]

I have a big performance problem with this :

SELECT v_{vbeln v}fkart v_{fkdat v}vbtyp v_{kunrg v}vkorg v~bukrs

b_{POSNR b}matnr b_{fkimg b}prsdt b~werks

FROM VBRK As v

JOIN VBRP AS b ON b_{vbeln = v}vbeln

APPENDING corresponding fields of table t_vbrk

WHERE v~fkart IN s_fkart

AND b~matnr IN s_matnr

AND b~ean11 IN s_ean11.

Any idea to solve this issue to improve the perfromance ?

Thank you.

[Former Member · Accepted solution]

HI

Use for all entries instead of joins and remove corresponding fields of, use into table with exact strucutre fields.