cancel
Showing results for 
Search instead for 
Did you mean: 

Extract BOM data from R/3 to BW

Former Member
0 Kudos

Hello BW Gurus,

what is the method of extracting BOM data from R/3 into BW.

Thanks in advance.

rgds,

TR PRADEEP

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Pradeep,

unfortunately you have to create something custom in order to manage BOM data in BW.

Doing that, consider that all your BOM data is available in R/3 tables STKO and STPO (Header and Item).

With the table MAST you can find also the link among the combination material/plant with every BOM codes.

At this point your might create a view (and then link it with your custom datasource) by using these tables (however you have to consider your specific needs).

Please keep in mind that you will extract all historical data of that BOM number. So, use the "Created date" to use the BOM data you are interested in.

By the way, access against these tables is not so feasible...try to search in your R/3 (I don't have the access now) a function module (search with BOM) that has as input parameters BOM Header, Alternative and others and gives back a table of the respective BOM items. You can create an InfoSet on the table STKO, enhance it with some code that calls the FM and writes the returned values in the Infoset (then use it to create your custom datasource !)

Hope it helps !

Bye,

Roberto

Former Member
0 Kudos

Roberto,

I have read all the BOM threads out there and still am unable to obtain a solution. Have tried all the function modules and can't find any that will work. Even the highly recommended CS_BOM_EXPL_MAT_V2 doesn't return any results. I enter a date and leave the default parameters in with a test and the output = NO_BOM_FOUND. There are BOMs in our system. I tried to extract Equipment BOMs to get to the Material BOMs because I need to determine if a material is in an equipment BOM.

Any solutions would be greatly appreciated.

Since this one seems to have been a problem since 2003/2004, you would think SAP would provide business content to get this information. Explosion of the material BOMs would be nice but I just need the equipment the material eventually belongs to. (I have to do multiple looping but don't know the relationship of the tables.

Former Member
0 Kudos

Hi Tracey,

I guess you need to post your question in the abap forum. For sure you will get some help on this quickly. If you need further assistance for creating your extractor we can be of help for you.

regards

Siggi

Answers (0)