SAP queries

SAP queries require at leastone one SAP user and one SAP server.

Queried SAP objects must be linked to a dynamic Documentum query or to a repository folder. The query is either a query through SAP CAD Interface, PLM Interface, or a BAPI or SAP table query.

To create, view, or edit a new query:

  1. Connect to WebAdmin.

  2. Click to expand the SAP subnode and select the Query subnode.

    The Query screen appears.

  3. Select File > New > SAP Query from the menu at the top of the Query screen.

    The SAP Query Properties screen appears.

  4. Enter the query name in the Query Name field.

  5. Choose an SAP query type from the SAP Query Type list box, as described in Table 25.2.

  6. Build the query condition.

    For each query condition you want to define:

    1. Choose a parameter from the Query Condition composer list box and enter a value for the parameter in the text box.

    2. Click the down arrow to add the parameter and value to the Query Condition field.

      Note

      Highlight an entry in the Query Condition field and click ’x’ to delete an entry.

    3. Continue to choose parameters and enter values to build the query condition.

      Note

      The conditions are AND linked.

  7. Click OK to save SAP Query configuration.

    The Query screen reappears with the SAP query.

  8. Highlight the newly created SAP query and select File > Test from the menu at the top of the Query screen.

  9. Choose a Server and a User on which to test the query, and click the test button.

    Note

    You must save any amendments before you implement any changes. If the query execution on the SAP System takes too long, WebAdmin timeout.

    The window shows the test results and is blank until the query results are returned.

Table 25.2. Query types

Query types for SAP R/3 version 4.6cQuery types for SAP R/3 version 4.7 and 4.6c

Document info record

No Object PLM (Formerly Document info record)

Equipment by short text

Equipment by short text PLM

Functional location by text

Functional location by text PLM

Material by description

Material by description PLM

Note

The Material by description PLM query type has three query conditions:

  • MATERIALSHORTDESCSEL_low

  • MATERIALSHORTDESCSEL_Sign

  • MATERIALSHORTDESCSEL_Option

All three query conditions are required if the query is to return a result.

Archive data

Archive data

Cost center

Cost center

Financial document

Financial document

Personnel links

Personnel links

Personnel master

Personnel master

Purchasing document

Purchasing document

Customer

Customer Table PLM

Print list

Print list

Vendor

Vendor Table PLM

WBS Element

WBS Element PLM

Asset Master

Asset Master GetList PLM