08-03-2013 9:47 AM
Hi all,
An article is sold in a store and the eod sales data goes to posdm(bi) . We are getting this error -articlexxxx not listed for this storexxx. Xxx denotes their respective numbers . I checked the respective combination in the Marc table and list data is available ie., site article combination . I checked in t code RSA3 and that article site combination was not present so article site data was not extracted to BI . Data source 0Art_plant_attr . Extraction on full load (F) . We run program customzupdate_marc to update the Marc table when we get the error , still doesn't get updated . Listing is via layouts. Each laymod = asst. How do I proceed to check and rectify this issue.
08-04-2013 11:30 AM
Hi Jae Kumar:
MARC is not confirmation of listing. Please use WSL11 to confirm that listing conditions exist for this Article / Site.
If not, then Listing must be executed (presuming the master data is correct) in MM42 or WSM4L.
If listing conditions are not created via MM42 or WSM4L then the master data is likely not correct (assignment of Site to General Assortment Module, maintain layout module, etc).
- Paul
Paul R Gendreau Jr
SAP Retail
08-04-2013 11:30 AM
Hi Jae Kumar:
MARC is not confirmation of listing. Please use WSL11 to confirm that listing conditions exist for this Article / Site.
If not, then Listing must be executed (presuming the master data is correct) in MM42 or WSM4L.
If listing conditions are not created via MM42 or WSM4L then the master data is likely not correct (assignment of Site to General Assortment Module, maintain layout module, etc).
- Paul
Paul R Gendreau Jr
SAP Retail
08-04-2013 12:27 PM
Hi Paul,
Thanks for the advice , I shall do some lookup as per your suggestion and will post back .
Gratefully,
Jae kumar
08-05-2013 11:27 AM
Hi Jae,
If it through assortment module. Then create assortment through WSO1, assign article through WSO2 to the assorment and then assign site to that assortment through WSO5 .... It will update WLK1 and MARC table...
Then try to extract the same in BI.....
08-11-2013 8:04 PM
Hi,
Did you check if the article/assortment combination exist on WLK1 on the date of your eod sales?
08-13-2013 9:47 AM
All the listing data is intact in ECC.
In basic I checked the BI Delta updates RSA1 in BI . some have failed , error says "Data did not load into target ".
This apart ,the POSDM sales data when posted in BI has a validation body which checks if article site combination exists in BI master data ,due to delta failure(which updates article site combination ) I suspect that articles with few site combinations which failed in delta caused the error while validation.
Example:
Posdm : Aggregated sales: Article : 101121 SITE : 0009 SALES : 86623 Pounds
BI MASTER: ARTICLE : 101121 SITES : 0001,0002,0003,0004,0005,0007,0010,0011,00DC.
Here BI master data does not contain the combination of Article 101121 , Site 0009 so the error is thrown" Article 101121 not listed in Store 0009".
Kindly advice if my approach is wrong.
Thanks,
JK
08-15-2013 5:54 PM
Thanks Everyone.
After gathering some more information , I understood that
1. BI extracts from Data Source " 0ART_PLANT_ATTR" ie., MARC table ARTICLE and SITE combination.
2. POSDM was enhanced to validate the ART SITE COMBINATION while posting sales if it was not satified there would be a rejection.
3.I suspect that POSDM wont have its own data so it will definitely make use of the target infocube in
BI which is updated by data from data source mentioned above.
4.In BI PSA for this source , the delta load is failing and doesn't reach the target, it was not even rectified as of till date- A lot of delta would have dropped off in error state.
5.Is this causing the original error (read above) ? I am almost 80 percent convinced with the logic.
My humble request to veterans to please advice on this at the earliest .
08-22-2013 8:11 PM
Hi Jae,
i. Please check at SAP ECC whether the article is listed to site or not.
ii. Please check the table entries WLK1 Assortment listing entries)
iii. Sometimes, listed articles have not maintained in Site, i.e table MARC entries missing. Please maintain
iv. Please check in BI whether the listed articles are updated in BI or not. If not, please check the error thru respective info cubes and rectify the error if any (SAP ECC article information flowed to BI)
v. Use the tcode WSPL for any listing error analysis and to do list articles, use WSM3, WSP4 and WSM8.
Once you done all the above, please reprocess and check.
Thanks & Regards,
Keshavan C