dspCompose

Enter a Where Clause

If a user enters a Where clause, the Where clause will be used verbatim when either selecting from the source or deleting from the target. If the Where clause is set, no other fields on the Template Role (Finish – Columns) page need be set and all other fields, if set, will be ignored.

NOTE: The Where clause takes precedence over any other Source and Target Filter settings.

To enter a Where clause:

  1. Click Team on Navigation pane.
  2. Click Templates for a team.
  3. Click Roles for a template.
  4. Click Vertical View for the Post role.
  5. Click the Approve and Finish Settings tab.
  6. Click FinishTables.

  7. Click Add.

    View the field descriptions for the Template Role (Finish) page.

    NOTE:If no records exist, the page displays in add mode. Otherwise, click Add.  

  8. Select a Collect source from the SOURCE list box.
  9. Select a Collect target from the TARGET list box.
  10. Select the name of the table to download from the TABLE NAME list box.
  11. Select None – Do not run any rules from the RUN RULES AFTER DOWNLOAD list box.
  12. Click Save.
  13. Click Source Filter Columns or Target Filter Columns depending on whether the where clause should be applied to the target or source table.
  14. Click the Where Clause Filter tab.

  15. Enter the Where clause in the Where Clause field.

    NOTE: If the package type in Collect tables is set to SAP Data Services, add the Client value to the Where clause field. For example, add
    #ColumnName# IN (#Data#) AND MANDT = 'XXX'
    where 'XXX' is the value of the specific client.

  16. Click Save.

NOTE: The data posted in the target system and downloaded in the table as part of the finish process both use this Where clause.