Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ E3D Design

MATERIALLIST

  • Last UpdatedAug 19, 2025
  • 8 minute read

Function:

Allows the user to control whether the material list is shown on the isometric, and alter the display format if required.

Description:

The MATERIALLIST command allows the user to control:

  • Whether or not the list is shown on the drawing at all. The default is for the list to be plotted.

  • The position of the list on the drawing sheet. The default is left-hand side.

  • Whether the characters used for plotting the list are small, medium or large. The default is medium.

  • The spacing between the lines in the list, relative to the default of 100.

  • The order that columns of details are shown on the list, and whether columns are displayed at all.

  • The width of the itemcode column in characters. Default is 8 characters and the maximum length is 29 characters. Both lengths exclude the leading / in the AVEVA E3D Design name.

  • Whether or not component descriptions are included in the list. By default, all descriptions are included.

  • Whether part numbers created in the Spool module are used, or whether part numbers are generated automatically in Isodraft and held in the Design database (using the PARTNUMBERS FROMDB command), or part numbers generated by Isodraft (using the PARTNUMBERS GENERATED command).

  • If the user is using totalled database part numbers, multiple part numbers will be output, separated by spaces, in a single entry in the material list, wrapping round if the column width is exceeded. The user should make sure that the part numbers column is wide enough to display several part numbers (say, eight characters) or the material list will be just as long. The quantity column will show the total of like items. Part number tags will still be individual.

  • How the overflow of long lists is to be handled, and if extra sheets are needed, how they are to be numbered.

  • Whether or not a weight column is added to the list providing a summary tool for the fabrication and erection material along with an overall isometric weight.

Formatting the Material List

If the user leaves Isodraft to its default settings (as described below), the material list will always be produced on the left hand side of the drawing sheet, using medium size characters to a standard linespacing. The itemcode column will be eight characters wide, and material descriptions will be included in the list. A separate material list will be plotted for every drawing sheet listing only the items on that sheet, with any continuations being plotted on a blank, dummy sheet.

These default settings will probably be appropriate for many uses of Isodraft. However, if needed, the user can change these settings to their own requirements. Examples of how to do this are included below.

For the total weight, a new text element is optionally placed below each material column.

A ‘--’ string is displayed when a weight cannot be found for the component.

The weight column and extra weight text is output to the MATLISTFILENAME file if selected.

Command Syntax:

Column c OTHER Heading ‘WEIGHT’ WEIGHT with WIDTH www [TOTAL FABRICATION] [TOTAL ERECTION] [TOTAL COMBINED] Factor f

Long Material Lists, and Sheet Numbering

If a material list is too long to fit onto one sheet it will normally be continued on a dummy sheet. This sheet will be identified DRG n OF m and will contain only the overflow of the material list. This is the default.

Alternatively, the user can specify that the material list will be continued in a second area beside the first one. This will result in a non-standard size for the drawing sheet, which will exceed the normal width by the amount needed for the second material list.

Inclusion of Database Part Numbers

The Spool module allows the user to set part numbers on: piping components; sections of tubes; bolts, and additional items. If this feature is used, it applies to an individual pipe, individual branch or to a drawing as defined in the Spool module.

The PARTNUMBERS FROMDB command allows the user to include part numbers from the Design database in the material list. If Isodraft finds any unnumbered parts, it will display an error message and halt the drawing of the isometric. The user can specify SEParate part numbers, which will generate an entry for each item; TOTalled part numbers, which will create a single entry for each item with a quantity or PIPEonlyseparate, which will list all pipes separately but will generate a totalled list of other components.

If this part numbering feature of Model has not been used, Isodraft will produce part numbers according to its own system defaults.

If the user is using the PARTNUMBERS FROMDB option, the user can define their own material list format. The user can specify which items appear on the list, and in what order they appear. The TABLEDEFINITION command allows the user to control the content, nature and order of standard column details in the material list. The user can also define additional columns (using the commands TABLEDEFINITION COLUMNNUMBER text attribute). In this fashion, the user can define the additional column title, which SPCOM or component attribute or UDA will be used as data to fill the column, the column width and the order will be shown on the list. A remarks column may be included for the cutting list remarks, since each piece of tube is listed separately.

Headings can optionally be specified as part of the TableDefinition Column syntax for standard columns by the following immediately after specifying the column contents, similarly to the previous syntax for non-standard columns.

Heading ‘NEW HEADING‘

Similarly to the non-standard columns, NoHeading can be specified, resulting in a blank column title. This is achieved by adding the following immediately after specifying the column contents.

Heading NoHeading

Not specifying the heading will result in the alternative text for that column being used.

The PARTNUMBERS PER command displays part numbers separately for each spool.

Note: If the attribute of a chosen SPCOM is a reference UDA referring to a text element, then the value of STEXT for that text appears in the column.

Examples:

Material list formatting

MATE OFF

Material list not shown on drawing.

MATE RIGHT CHARH 2.0

Material list plotted on right-hand side of drawing sheet, using 2.0mm high characters.

MATE LEFT CHARH 2.5

Material list plotted on left-hand side of drawing sheet, using 2.5mm high characters.

MATE LSPA 105

Increases the line spacing by 5%

MATE CODE 12

Itemcode column 12 characters wide.

MATE NODESC

Material descriptions omitted from list.

MATE DESC

Material descriptions included in list.

MATE GRIDlines ON

Show the horizontal and vertical lines on the Material List.

MATE GRIDlines OFF

Do not show the horizontal and vertical lines on the Material List.

MATE TRUN/nionplatecategory FITT/ing

Trunnion Plates are to be shown under FITTINGS category on the Material List.

MATE TRUN/nionplatecategory SUPP/ort

Trunnion Plates are to be shown under SUPPORTS category on the Material List.

MATE TABLED COL 1 QUANT

Defines column 1 in the material list as ‘Quantity’.

MATE TABLED COL 2 EMP

Sets column 2 as an empty column.

MATEriallist DRWG

Plots a separate material list on every drawing sheet, listing only items drawn on that sheet.

MATEriallist LINE

Plots, on the first drawing sheet, a single material list for the whole pipe line or system.

Long material lists

MATE DUMMY

Long list continued on separate drawing sheet, with no isometric plot on it. Single sheets not numbered. Multiple sheets numbered ‘1 of n’, ‘2 of n’ This is the default.

MATE DUMM SING

Long list continued on separate drawing sheet, which has no isometric plot on it. Single sheets numbered ‘1 of 1’. Multiple sheets numbered ‘1 of n’, ‘2 of n

MATE DUMM SUFF

Long list continued on separate drawing sheet, which has no isometric plot on it. Single sheets not numbered. Multiple sheets numbered ‘1 of n’, ‘1A of n’ (for the sheet with the material list only), ‘2 of n’ etc

MATE OVER

Long list continued to the right of the preceding list on the same drawing sheet. Single sheets are not numbered.

Note: This may produce non-standard drawing sizes.

MATE OVER SINGle

Long list continued to the right of the preceding list on the same drawing sheet. Sheets numbered ‘1 of n’, ‘2 of n’ Single sheets numbered ‘1 of 1’.

The default is:

MATE ON LEFT CHARH 2.45 LSPAC 100 CODE 8 DESC DUMMY DRWG

Related Commands:

ITEMCODE MTEXTS DTEXTS RESERVE

Command Syntax:

                  .---------------------------------<-----------------------------------.
/                                                                      |
 >-MATEriallist-*- ON* -.                                                               |
                |       |                                                               |
                |- OFF -+---------------------------------------------------------------|
                |                                                                       |
                |- LEFT* -.                                                             |
                |         |                                                             |
                |- RIGHT -+-------------------------------------------------------------|
                |                                                                       |
                |- CHARHeight - value --------------------------------------------------|
                |                                                                       |
                |- LSPAcing - integer --------------------------------------------------|
                |                                                                       |
                |- CODE - integer ------------------------------------------------------|
                |                                                                       |
                |- DESCriptions* -------------------------------------------------------|
                |                                                                       |
                |- NODEscriptions ------------------------------------------------------|
                |                                                                       |
                |- GRIDlines -+- ON* -.                                                 |
                |             |       |                                                 |
                |             ‘- OFF -+-------------------------------------------------|
                |- TRUNnionplatecategory -+- FITTING* -.                                |
                | | | |
                |                         ‘- SUPPORT --+--------------------------------|
                |- TABLEdefinition -+---------------------------------------------------|
                |                   |                                                   |
                |                   ‘- COLumn val -+- PARTnumber --------------------.  |
                |                                  |                                 |  |
                |                                  |- DEScription -------------------|  |
                |                                  |                                 |  |
                |                                  |- BORe --------------------------|  |
                |                                  |                                 |  |
                |                                  |- ITEMcode ----------------------|  |
                |                                  |                                 |  |
                |                                  |- QUANtity -+- IN -+- <munits> --|  |
                |                                  |            |                    |  |
                |                                  |            ‘--------------------|  |
                |                                  |                                 |  |
                |                                  |- REMarks -+- AND -+- <remarks> -|  |
                |                                  |           |                     |  |
                |                                  |           ‘---------------------|  |
                |                                  |                                 |  |
                |                                  ‘- <other> -----------------------+--|
                |- PARTNumbers -+- PERSPool -.                                          |
                |               |            |                                          |
                |               ‘------------+-- FROMDB ---+-- SEParate ----------.     |
                |                            |             |                      |     |
                |                            |             |-- TOTalled ----------|     |
                |                            |             |                      |     |
                |                            |             ‘-- PIPEonlyseparate --+-----|
                |                            |                                          |
                |                            ‘ - GENerated -----------------------------|
                |- DUMMy* --.                                                           |
                |           |                                                           |
                |- OVER ----+-----------------------------------------------------------|
                |           |                                                           |
                |           |--- SUFFix ---+--------------------------------------------|
                |           |              |                                            |
                |           ‘--------------+--- SINGle ---------------------------------|
                |- DRWG* --.                                                            |
                |          |                                                            |
                ‘- LINE ---+------------------------------------------------------------+-->

where <munits> is

meters or MILlimeters.

This lets the user to set the metric units to be used for pipe lengths in the Quantity column.

Note: That this affects metric isos only.

<remarks> is

    .------------------------------------------------------------------------.
   /                                                                         |
--*- attribute -+- FROMSPcom -.                      .-----------.           |
                |             |                     /            |           |
                ‘-------------+- ON -+- component -*             |           |
                                     |             |             |           |
                                     |- TUBE ------|             |           |
                                     |             |             |           |
                                     |- BOLT ------+- component -|           |
                                     |             |             |           |
                                     |             |- TUBE ------|           |
                                     |             |             |           |
                                     |             |- BOLT ------’           |
                                     |             |                         |
                                     ‘- ALL -------+- nl  -------------------|
                                                   |                         |
                                                   ‘-------------------------’

This allows attributes or UDAs to be taken from the catalogue or from the component, where component is one of the following:

BEND

ELBOw

CAP

CLOSure

COUPling

CROSs

FBLInd

FLANge

FTUBe

INSTrument

LJSEnd

OLET

TEE

PCOMPonent

REDUcer

SHU

TRAP

TUBE

UNIOn

VALVe

VFWAy

VTWAy

WELD

GASKet

SUPPort

ALL

<other> is

 -+- HEADing -.
            |           |
            |-----------+- text -.
            |                    |
            ‘- NOHeading --------+- attribute -+- FROMSPcom -|
                                 |             |             |
                                 |             ‘-------------|
                                 |
                                 ‘- WEIGHT -+- TOTAL FABRICATION -.
                                            |                     |
                                            ‘---------------------+--.
                                                                     |
      .-----------------------------<--------------------------------’
      |
      ‘--+- TOTAL ERECTION -.
         |                  |
         ‘------------------+- TOTAL COMBINED -.
                            |                  |
                            ‘------------------+- Factor --value --|
                                               |                   |
                                               ‘-------------------+--.
                                                                      |
      .-----------------------------<---------------------------------’
      |
      ‘--+- TubeFactor -- vale --.
         |                        |
         ‘------------------------+-- WROUND OFF --.
                                  |                |
                                  +-- WROUND ON ---|
                                  |                |
                                  ‘----------------|

where WROUND ON indicates that, if a tube length is rounded-up, the corresponding tube weight is rounded-up accordingly.

Column width can be specified as part of the TABLEDEFINITION COLUMN syntax by adding:

- WITH WIdth value -+- nl -|
                    |      |
                    ‘------’

Querying:

Q MATEriallist

Q OPTions

Q MaterialList TableDefinition - will result in the headings being output in the expected format along with the rest of the column data.

TitleResults for “How to create a CRG?”Also Available in