topic Re: How to programmatically listing articles in assortment? in Application Development and Automation Discussions

How to programmatically listing articles in assortment?

Former Member — Tue, 16 Oct 2007 07:28:35 GMT

Hi,

This is Retail.

I am creating articles from scratch based on data uploaded to some Z-tables.

I have already successfully created the article. Now I need to list this article in some assortments, but I can't seem to understand how this can be done in ABAP. I tried to look for relevant FM but didn't find any.

Can anyone help?

Thanks,

Nuno

Re: How to programmatically listing articles in assortment?

Former Member — Fri, 19 Oct 2007 11:41:46 GMT

how you going determine in which assortments list article?

from algorithm point of view

0. you have relations "article - store - yes/no" in your scratch DB

1. for each article change article listing procedure (mm42 -> listing -> listing procedures 03 (manual)

2. for each store create standart module (wso1)

3. fill module with articles according to relations from scratch DB

4. assign module to store local assortment (ws05, local assortment exists for each store and has same code as store)

Re: How to programmatically listing articles in assortment?

Former Member — Fri, 19 Oct 2007 11:54:17 GMT

Hi Mikhail,

Thank you for your answer.

But in ABAP I don't want to start inserting records in tables directly so I'm looking for a function which helps me achieve this safely. Now I'm already doing it by submitting program RWSORLIARTI which is assigned to transaction WSM3 which kind of works, but it's not easy to get error reporting and it always commits. With a function I'd have much more control.

Thanks,

Nuno

Re: How to programmatically listing articles in assortment?

Former Member — Fri, 19 Oct 2007 13:05:10 GMT

I did this awhile back: Loop at your matnrs, then....

LOOP AT t_outdata INTO wa_outdata. "MATNRS

CLEAR: t_assortments_matnrs.* REFRESH: t_assortments_matnrs.*

SELECT filia FROM wlk1 APPENDING CORRESPONDING FIELDS OF TABLE t_assortments_matnrs

WHERE artnr = wa_outdata-matnr AND

datab <= sy-datum AND

datbi => sy-datum.

Re: How to programmatically listing articles in assortment?

Former Member — Fri, 19 Oct 2007 13:18:01 GMT

Hi Tom,

Thank you for answering.

Actually I need to CREATE listing for this materials in WLK1. Not list existing entries in WLK1 because there are none since I've just created the material programmatically.

Regards,

Nuno

Re: How to programmatically listing articles in assortment?

Former Member — Wed, 24 Oct 2007 08:35:34 GMT

Well,

I found the solution by analysing report RWSORLIARTI. It can be done using two function modules: MODULE_CREATE followed by ASSIGNMENT_POS_TO_SHOP. It's fast and it works quite well.

Regards,

Nuno