On the B.20.01.44 List Download screen, you can download BOM data (nodes, positions, attributes) to an Excel file.
The DBA settings BOM_EXCEL_MPV_EXPORT_TEMPLATE, BOM_EXCEL_SPV_EXPORT_TEMPLATE, BOM_DOWNLOAD_DEST,
and BOM_DOWNLOAD_URL must be set before starting a list download.
Open this screen from B.20.03 Adv. Maintain BOM and select the List Download option from the shortcut menu in the BOM tree. The B.20.01.44 List Download screen opens, with the selected node shown in the BOM Path field on top.
In the Into Export File section, select the Excel Export option. The download path assigned to the DBA setting BOM_DOWNLOAD_DEST is displayed in the Physical Path field, but is not needed for Excel export.
In the BOM Data Options section, select the with Structure check box to export the BOM structure also. Select the with Position check box to export the BOM positions assigned to the selected nodes.
Use the with Positions options to determine the complexity of the download. Select one of these options:
-
without Assemblies - The assembly structures present in the BOM positions are not downloaded.
-
with BOM-Assemblies - Assemblies are exploded and downloaded according to the BOM Copy rule assigned to the ZB_COCP project default.
-
with Assemblies by Requisition Rule - Assemblies are exploded and downloaded according to the BOM Copy rule assigned to the ZR_COREQ project default.
-
with Assemblies by Construction Rule - Assemblies are exploded and downloaded according to the BOM Copy rule assigned to the ZB_COCON project default.
Select an option from the Issue Status radio group. The available options are listed below.
-
Selected - You must select a particular issue status from the LOV in the Issue Status field. Only this selected issue status of the positions is exported.
-
Highest - Only the highest issue status of the positions is exported.
-
Lowest - Only the lowest issue status of the positions is exported.
-
All - The positions are exported with all issue statuses, and re-import of the exported data is not possible.
In the BOM Attribute Options section on the right, you define which attributes are exported. The available options are:
-
With Attributes for Re-Import - With this option, attributes directly assigned to each position are exported. To prevent import processing performance being negatively affected, no attributes are downloaded in duplicate within the path.
-
With directly assigned Attributes in User BOM View - Only node and position attributes that were directly allocated through the node type or the discipline allocation are exported.
-
With all Attributes in User BOM View - The node and position attributes that are defined in the current BOM view, used by the user who called this function, are exported.
-
With all Attributes - With this option, all variable attributes for each selected node and each position are exported.
To start the list download, click Start. After downloading, you can open or save the file. An example file appears in the picture below.
For more information, see List Download.