Bay Networks Baystream 7 Guide de l'utilisateur télécharger pdf (Page 113)

PCN Process User Guide (301945-A)

FAQ: C-5

1. In SAP, select Materials-Management->Engineering->BOM

Component detail report.

2. Enter BOM details.

3. Select “Sort by Item” and “Single Line Download.”

Download the Excel macro at

http://edmse.corpeast.baynetworks.com/

bom_import.html

and run this to import the file (from Step A) into

Excel. Edit the part number that has changed.

Remove all headings and format each line as 3 cells, each with a pipe

character, then the part number, then 4 cells, each with a pipe character,

then the quantity, then a cell with a pipe character, and then a cell with the

reference designators.

Save the file as tab-delimited text.

Upload the saved file to your

caps

home directory with a

partnumber

.txt

filename (e.g. 123456-A.txt)

Run

/dra/utils/xcelbom

on the uploaded file and exit at the step where it

asks you if you want to run the BOM upload.

The resulting

partnumber

.sap

file produced in Step F will have removed

the original item number and added a new item number, which must now

be edited back to its original item number. Note: Since the .

sap

file Item

Number field is used for sorting, the order of lines is irrelevant.

Run

/dra/utils/bom_upload

to complete the process.

1 2 ... 108 109 110 111 112 113 114 115 116 117 118 ... 161 162

Pas de commentaire

Bay Networks Baystream 7 Guide de l'utilisateur Page 113