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:
Connect to WebAdmin.
Click to expand the SAP subnode and select the Query subnode.
The Query screen appears.
Select File > New > SAP Query from the menu at the top of the Query screen.
The SAP Query Properties screen appears.
Enter the query name in the Query Name field.
Choose an SAP query type from the SAP Query Type list box, as described in Table 25.2.
Build the query condition.
For each query condition you want to define:
Choose a parameter from the Query Condition composer list box and enter a value for the parameter in the text box.
Click the down arrow to add the parameter and value to the Query Condition field.
Highlight an entry in the Query Condition field and click ’x’ to delete an entry.
Continue to choose parameters and enter values to build the query condition.
The conditions are AND linked.
Click OK to save SAP Query configuration.
The Query screen reappears with the SAP query.
Highlight the newly created SAP query and select File > Test from the menu at the top of the Query screen.
Choose a Server and a User on which to test the query, and click the test button.
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.6c | Query 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 NoteThe Material by description PLM query type has three query conditions:
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 |