How to Download all BOMS of a Plant in one time

[Former Member]

Hi All ,

Using CS12 I can download individual BOM's but this will literaly take weeks to do for the number of BOM's we have. Is it

possible to download the detail of all BOM's. ?

Is ther any alternate way to Download all BOMS of a plant at one time ? Or is not Possible as per standared SAP ?

Regards

Piyush

[former_member196530]

Dear

You can go to SQVI and developed a query based MAST ,STPO ,STPU,STKO .Or you can use Functional Module CS_BOM_EXPL_MAT_V2 / CSAP_MAT_BOM_READ to build a report on the same .

Hope it helps

Regards

JH

[former_member184574]

There is no report in standard SAP. You have to go for Z report with help of your ABAP consultant for this

[Former Member]

Hi,

You can get the by using the standard Logical data base in Quary. T-code is SQVI.

In this screen, enter name for the quary, press create button. In next screen select Data source as Logical data base and enter the logical data base as CMC.

[Former Member]

thanks for the guidline ...

[former_member184670]

Piyush,

Yes I agree with Mangalraj's reply,

1. Are you extracting all BOM from one plant to other Plant? You need to check with your Client.

2. You can't extract all the Assembly if its multi level BOM through query.

3. Get help from your ABAP person to proceed further.

Regards,

Sundhu

[former_member184655]

Dear Piyush,

1.What is the business requirement?what is the business going to do after downloading all the BOM's from the system?

2.I will not suggest you to try to create a query,because it is not possible to get a multilevel BOM by linking the tables.

3.Use the FM CS_BOM_EXPL_MAT_V2 BOM explosion for material for developing a report,but you have to discuss with your

ABAP consultant for giving a direct provision to download it into the system.

Regards

S Mangalraj

Edited by: Mangalraj.S on Oct 6, 2010 2:54 PM

[Former Member]

Hi Piyush,

1. In SE16 Put MAST table and in next screen select plant you will get all BOM for that perticular plant

2 . If you want details of all BOM write a Queary in SQVI by joining the Tables - MAST , STPO and STKO if datd is huge it will give you dump . Also Check Queary in SQ01 with help of your ABAPER

Regards,

Girish

[muthusamy_sankaran]

Hi,

There is no std option for this this requirement

You can create a Query or Customised Program & TCode using the given tables in the same sequence MAST, STKO,STAS & STPO.( STAS is required if u have alternative boms). Give the required fields in the output format of the qurey, Execute the qurey or TCode.

or

use below function module

CALL FUNCTION 'CS_BOM_EXPL_MAT_V2'

EXPORTING

ftrel = c_checked

altvo = c_space

aufsw = c_checked

capid = c_application

datuv = v_datum "DATE VALID FROM

mktls = c_checked

mdmps = c_checked

mehrs = c_checked

mtnrv = t_mapl-matnr "MATERIAL NUMBER

svwvo = c_space

werks = p_werks "PLANT

mdnot = c_checked

TABLES

stb = t_itab_stb "TO HOLD BOM DATA

EXCEPTIONS

alt_not_found = 1

call_invalid = 2

material_not_found = 3

missing_authorization = 4

no_bom_found = 5

no_plant_data = 6

no_suitable_bom_found = 7

conversion_error = 8

OTHERS = 9.

Regards,

Sankaran

[Former Member]

Hi <

Thanks for the reply ,

Can you please Guide me how to write the query for this ,

Give me each step by step instruction to develop a query .

Will that query provide me all BOms OF a plant in one execution ?

Regards

Piyush

[former_member1035213]

If there is CN change in the BOM, then the delete BOMs are mixed with the new one. Is it possible to remove them from the table-MAST, STKO,STAS & STPO?

[lenastodal]

I saw your posted comment. Please raise your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. The author of the original question is no longer active in the community and won't receive your query. With the help of our Q&A tutorial: https://developers.sap.com/tutorials/community-qa.html, you'll be able to prepare questions that draw responses from our members.

Thank you!