×

[PR]この広告は3ヶ月以上更新がないため表示されています。
ホームページを更新後24時間以内に表示されなくなります。




Sapass

 Simplify SAP R/3 development with Excel VBA/VB RFC  
Home> Download>Bom Processor by SAP RFC



Index

Bom Processor by SAP RFC

Usage of Bom Processor

17-Sep-2005


1. General


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.
@


18-Sep-2005


2. Prerequisite & Asssumption

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.

 


18-Sep-2005


3. Open macro

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.


18-Sep-2005


4. Create new sheet

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.


18-Sep-2005


5. Download BOM

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.


18-Sep-2005


6. Maintain BOM

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.)


18-Sep-2005