Extraction from MDSM
Hello Experts ,
I have a very peculiar problem. I want to extract from the tables MDSM the following fields in my Generic Datasource .
However the unit for the Quantity field BDMNG is MEINS which is referenced from MARA. I need the unit in my BW extraction.
Now if i Join MDSM (which contains 17 million rows) to MARA (which is also equally big ) the join through MATNR is very resource intensive and I believe it will create many problems in future .
My question is : Is there any other method to extract records from MDSM other than using the View of MDSM and MARA ? The ideal method would be to use MDSM singularly and avoid any joins . However if joins are to be used at all , they are to be very minimum .
Please post in your suggestion as soon as possible .