cancel
Showing results for 
Search instead for 
Did you mean: 

List of BOMs

Former Member
0 Kudos
29,836

Is there a transaction I can use to view the BOMs of a list or range of Material Master Numbers at once?

Accepted Solutions (0)

Answers (10)

Answers (10)

Former Member

Hi Ray,

There is work around solution for your requirement. You can go to Display BOM transaction (CS03) and for material field, click on F4 options wherein select the criteria 'Material by bill of material'. In this selection criteria enter the values like plant and BOM usage.

By doing so you can at least get the List of BOM materials in selected plant along with BOM usage.

Regards,

Naresh

former_member200970
Participant
0 Kudos

Hi Ray,

Depending on the requirement like

  1. Bom Explosion : How and what quantities of materials are consumed at each level is possible to see in CS11.
  2. Explosion Level : If you need at each level the priority based you can get it using the CS12
  3. summarized View : lets say at each level there are a few common bi-products also produced this are nullified and a single entry is posted for them overall , this is possible by CS13
  4.   Bom Changes : If you want to know the changes done at a particular Bom say quantity they can be calculated using the CS14 . In this each and every Bill of material is considered . We can also see the changes done date wise.

Regards

Arvind pabba

Former Member
0 Kudos

Hi Ray,

As other Colleagues say, there is no standard transaction that you can execute and see BOMs for multiple materials easily. But you can get a download using CEWB tcode (use this carefully as you can change data)

Goto CEWB and select SAP_ITEM in ‘Current Working Area’ fiels at the selection screen, then you can see a detail selection screen where you can filter your execution. Once that is done click the button ‘Load BOMs and Task List’ at the top left corner. You will be directed to a screen where you can see BOMs in a grid/table. Now you may click on Print button so the total list can be seen in more user friendly way. And you have the download option there too.

If you need to access this frequently you can develop a simple ABAP program using CS_BOM_EXPL_MAT_V2 Bapi. Good Luck!

Thanks!

Isuru

VigneshV
Participant
0 Kudos

Hi

Use CEWB you can get the details but be careful while using it.

Vignesh.V

former_member196530
Active Contributor
0 Kudos

Please use the CS03/CS02 where you have option as search criteria to list down the BOM using Plant and Usage -1.Goto CS03-Click on Material -Here you choose search -Material by BOM -Enter Plant and Usage 1 -You will get list of material in that plant having valid BOM

there are multiple search criteria  to get the BOM Details.

You can also build a query in SQVI with STPO/STKO/MAST and get the BOM list .

Former Member
0 Kudos

Hi Ray,

If your requirement is only to get list of BOM for a range of materials then I agree with solution provided by pravin ujwalkar.

CEWB is the transaction you should use and select working area as "SAP_BOM". here you have option to give material range.

If your requirement is to explode multple BOM together then SAP will only let you exlpode 1 BOM at a time as mentioned by other forum members.

You can always refer to SAP table MAST if you do not want an end user transaction.

Regards,

Rohit

Former Member
0 Kudos

Hi,

You will get BOM detail from T. Code CEWB.

You have to use this t. Code carefullyas it is for mass change.

Former Member
0 Kudos

Hi Ray Stormer,

I can understand where you are coming from..  Let me explain reason why Such simple requirement is not addressed by SAP.

BOM are stored as Parent-->Child relationships in STPO table & Child appearing in STPO table can also appear as parent & it can have it's child entries.  Note that Levels displyed in CS11 & CS12 reports are not stored in any of tables... they are calculated by CS11 & CS12 & displayed on screen only.

So if you input material numbers From & To , what is system suppoed to do...  it can follow steps

-Read Material number & pull its first level BOM (Essentially dump STPO record)

- If any of child record has it's own BOM, it has to pull ( Else BOM report will be incomplete) those reocrd & then arrange in multlevel by calculating level..

-Go to next Material no & it happens to be one of the Child material in first BOM, it will repete all records & report will be redundent.. This is the reason BOM for multiple material is not provided

As you can see , it will be multilevel tree for many reocrd & difficult to understand/Download... that's the reason, SAP has not provided as standard... SAP provided only for Single material.

If you wish to write query , you will be faced with questions above..(ABAP programmer will give you Blank stare..). whether to consider child BOM in report & that's where Low-level code ( Field is updated when BOM is created in MARA table) comes into play.. You can Only ask for BOM with Low-level code=0 ... This way you dun repete STPO records

Happy BOMing

Regards

Jatin

Former Member
0 Kudos

There is no standard transaction available to list BOM component for all materials at one glance. It always better to create Query or ABAP report which is always required for the Planner. Various table associated with BOM are MAST linked with STKO and STPO. So you can easily create a query or Report.

RahulHanda
Active Contributor
0 Kudos

Hi Ray,

We have transaction where you can see BOM but for individual material example CS11/12/13/14. If you want to check for multiple materials you can create a query in SQ01 by linking tables STKO, STPO & MAST.

Regards

Rahul