Hi,
There is a select statement which is causing performance issue.
SELECT
matnr
charg
sobkz
kunnr
lfgja
lfmon
kulab
FROM msku
INTO TABLE t_msku
FOR ALL ENTRIES IN t_msku_key
WHERE
matnr IN s_matnr
AND werks IN r_werks
AND sobkz IN r_sobkz
AND kunnr = t_msku_key-kunnr
In this select statement matnr is not a mandatory field.Since this is a mandatory field in msku table and this is not passed in the where condition of the select statement it is taking lot of time for execution.
Is it possidle to use range on matnr field instead of select-option field?
If so how do we populate that range?which function module do we use for this?