CEWB-combine BOM header and BOM item

[Former Member]

Hello,

I'm new to this forum so I hope I placed my question on the correct place.

We use often CEWB (engineering workbench) to make downloads of all our BOM's. But we always have to do in 2 shots :

1) Download of all BOM headers

2) Download of all BOM items

Afterwards we combine BOM header and BOM item in Excel using VLOOKUP based on BOM number.

Is there a way to do in 1 shot? Or is there another transaction where we can easily make a BOM download.

We need this info :     - material

                                   - alt BOM number

                                   - BOM header

                                   - all components with sequence number, material number, quantity, unit of issue, component scrap, issue storage location

Many thanks,

           Jurgen

[sandeep_praharaj · Accepted solution]

HI,

You can go for custom development with the help of functional module.

CS_BOM_EXPL_MAT_V2.

or

CSAP_MAT_BOM_READ.

Import parameters are -

Material Number

Plant

Bom Usage

Valid From

Valid to

Thanks & Regards

Sandeep Kumar Praharaj

[solomon_macwan]

Hi Jurgen,

The simplest way is to create a Query SQVI

regards,

Solomon

[former_member185450]

Hello Jurgen,

you can use CS_BOM_EXPLOSION or 'CS_BOM_EXPL_MAT_V2 function modules to develop a new custom report to explode the multiple material multilevel BOM

Regards,

Venkatesh..

[former_member194456]

Hello

If you want to download the material BOM, have a look in the following T code

CS11

CS12

CSMB

Hope i get you correctly and this helps you

Regards

SS

[Former Member]

Hello,

Thanks for your answer.

But these transactions are only for individual BOM's, I want to download multiple BOM's.

Kind regards,

          Jurgen

[JL23]

If you download header and items and do VLOOKUP in Excel to get them together then you can replace this scenario easily with transaction SQVI where you can join header and items and can download the result easily

[sandeep_praharaj]

Hi,

In standard nothing is available to show all boms components

you have to go for custom development.

FM  CS_BOM_EXPL_MAT_V2 or CS_BOM_EXPLOSION.

Thanks & Regards

Sandeep Kumar Praharaj