Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 .

MATNR

WERKS

BDTER

SBNUM

SBPOS

SBART

PLSCN

BDMNG

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 .

Former Member
Not what you were looking for? View more on this topic or Ask a question