on 12-17-2004 9:55 AM
Hello BW Gurus,
what is the method of extracting BOM data from R/3 into BW.
Thanks in advance.
rgds,
TR PRADEEP
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.