TeamcenterKnowledge

Configuring Systems Engineering > Customizing Excel export templates

Defining rules for filtering properties

The following key fields can be specified in the rule table and are applied to the properties being exported:

Key field Syntax Example Description
Level {%L-Level} {%L-2} Filters data based on the hierarchical level of the object. E.g. when 2 is the argument, objects at the second level in the structure are exported.
Relation {%R-Relation-Name} {%R-FND_TraceLink} Filters data based on the relation traversed to the object found.
Type {%S-Type-Name} {%S-Requirement} Filters data based on workspace object type.
Transfer Mode {%T-Transfer-Mode-Name} {%T-Req_default_TM} If a transfer mode is found that matches the one specified in the template, the secondary objects associated with the object are also exported.

Example

For a Relation key field: assume the row contains property tags for a primary object, and one of the property tags is {%R-name}, which calls the names of all relation objects for the primary object. To export only the names of the object's trace links, enter the {%R-FND_TraceLink} rule tag in the Relation column — the export process filters the relations and passes only trace link names to the output file.

Source: https://docs.sw.siemens.com/en-US/doc/282219420/PL20251212545240207.plm00038/key_fields · retrieved Fri Jul 10 2026 00:00:00 GMT+0000 (Coordinated Universal Time)