Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performace Issue

hi all,

below code is taking a lot of time in prod server.

can any help me to optimize this code.

SELECT amatnr aersda

bwerks bdispo bmatnr beisbe b~mmsta

c~maktx

INTO CORRESPONDING FIELDS OF TABLE it_matl

FROM ( mara AS a INNER JOIN marc AS b

ON amatnr = bmatnr )

INNER JOIN makt AS c

ON bmatnr = cmatnr

WHERE a~matnr IN s_matnr

AND b~werks IN s_werks

AND mtart EQ 'UNBW'

AND mmsta NE '98'

AND b~dispo IN s_dispo

AND b~kzaus EQ ' '

AND c~spras EQ sy-langu.

regards,

raghu

Tags:
Not what you were looking for? View more on this topic or Ask a question