Download BOM processor Excel Add-in (V1.0)

This Excel VBA macro will help to read or update BOM information on SAP by RFC.

This tool does following things
A. Read BOM on SAP by RFC function module: CSAP_MAT_BOM_READ and put them in Excel sheet.
B. Update BOM on SAP by RFC function module: CSAP_MAT_BOM MAINTAIN.
@

To execute this macro, you need Microsoft® Excel®95 or higher version. In addition, this requires SAP GUI to be installed your PC with librfc32.dll.

So far, this macro function is tested only under Microsoft® Excel® XP, SAP GUI 6.20 and SAP 4.6D. In addition, as this macro accesses to SAP, you will need to have SAP access with good enough authorization to execute targeted transactions.

Open this Excel Add-in with enabling macro. As this is just an Add-in, will not contain any work sheet. When you open the Add-in, you will see the new menu 'Sapass'' added on the left edge of the menu bar.

From menu, select Create New Sheet. Then the new work sheet with header line will be added on the Active worksheet.

a) Create New Sheet then the following sheet will be added.

For reading BOM, you have to first specify the parameters - Plant, Usage and Change number. If you don't specify change number, BOM as of the execution date will be downloaded.

a) Create New Sheet then the following sheet will be added.

b) After that, specify the parameters and select Read BOM menu.

c) Pop up dialog screen appears and specify the parent number range that you want to download. (Here in example, $A$2:$A$3 is specified. - e.g. Assuming MAT0001 and MAT0002 are in the cells. Then the BOM: MAT0001 and MAT0002 will be downloaded.)

d) Download result will be like this.

For maintaining BOM, same as read BOM, you have to first specify the parameters - Plant, Usage and Change number. In this macro, it is mandatory to specify Change number.

a) Create New Sheet then the following sheet will be added to active sheet.

b) After that change the BOM values in the spreadsheet. (If you want to remove values, you can do it by specifying "!"). , specify the parameters and select Maintain BOM menu.

c) Then the SAP logon screen will appear, so logon to SAP system as you do by SAP gui.

d) Pop up dialog screen appears and specify the part number range that you want to maintain.

e) BOM will be maintained in the SAP. (At this moment, no messages will be appeared.)