I wan to determine listing status for multiple sites and articles, WLK1_CHECK is too slow

[Former Member]

I want to determine the listing status for a big amount of site-article combinations to output on a report.

WLK1_CHECK is the function module we usually use to determine site-article listing status, but the problem is that I have to call this FM for every single site and article individually, resulting in multiple calls on the database and resulting in a very long run time. Is there a different function module or method that I can use that does this type of determination for a list of sites and articles?

[andras_strobl · Accepted solution]

Hi Natasha,

How about using WLK1_READ_INTO_BUFFER ?

It should read all necessary entries at once, and you can just read the internal table afterwards, which is definitely much faster.

Best regards,
Andras

[Former Member]

Thanks, Andras, I will definitely try that.

[Former Member]

Unfortunately this did not assist in the runtime at all.

[maciej_jarecki]

Hi

Try first with FM:ASSORTMENT_GET_ASORT_OF_USER or other FM from function group WSO1. Perhaps with them you can easily limit number of articles to final check. It depends as well how complex is listing landscape in your company.

Best regards,

Maciej