02-21-2011 5:03 PM
Hi Guru's,
Can you suggest any Transaction code or table to find the number of variants for a given list of generic articles?
In MM43, we can find the variants related to just one article, I want to get the number of variants for a group of generic articles.
Ex: In the list of 30,000 Generic articles, I want to list the articles with 100+ variants, how to achive this?
Thanks,
Ravi
Edited by: ravi duggirala on Feb 21, 2011 7:42 PM
02-28-2011 2:38 PM
Hi Ravi,
Its a very interesting question.However i doubt there is no straight forward Tcode or Table that can give you the list of generic articles with Variants attached to it thought you may find link between MARA and CAWN tables.
The best thing would be to get help of an ABAPer and he can figure out how he can bring the list of variant articles which are visible in the subscreen of variants SAPLWMMB with screen Number 2101 or he can even refer some structures to bring this for you.Ofcourse a time consuming ONE TIME activity,but can surely be of help for you.
Hope it helps.
Best Regards,
Aram.
05-16-2011 2:59 PM
05-16-2011 4:20 PM
Hi Amol,
I tried PGMI table and I did not find the way to trace total number of variants for a generic article.
Can you please let me know the way to meet my requirement If I am wrong in finding by using PGMI table.
Thanks for the response.
Regards,
Ravi Duggirala
05-18-2011 3:46 PM
05-20-2011 12:57 AM
Hi,
Only the way we can get the variants for generic articles is follows
Table: MEAN
enter the generic article, followed by the - and no of charatestics
ex: Generic article# 1010101
variants - 1010101-010
1010101-011
1010101-012
in the table you enter the article# as 1010101-***
u will get all the variants for the generic articles with their respective ENA no
u can do the concanecate fromula in excel for all the generic articles in excel and attach to the clipboard, u can get all the details in one shot
Hope this may answer ur question, we are following same method in our project
05-20-2011 12:59 AM
null
Edited by: Arungujjari on May 20, 2011 2:00 AM
Edited by: Arungujjari on May 20, 2011 2:01 AM
06-13-2011 10:24 AM
Through MEAN table, if we enter the Generic Article code in MATNR field, its not showing any list of variants, even after adding * in the end. Rather PGMI table was bit more helpful. If we give the Generic Article code in PRGRP field, its showing the variants for that generic code.