User guide

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.”
b.
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.
c.
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.
d.
Save the file as tab-delimited text.
e.
Upload the saved file to your
caps
home directory with a
partnumber
.txt
filename (e.g. 123456-A.txt)
f.
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.
g.
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.
h.
Run
/dra/utils/bom_upload
to complete the process.