dspCompose

Use Custom Syntax

The Template Role (Finish – Columns) page for the source and target also allows a user to enter custom syntax in the case that the schema cannot be determined for either the source or the target. When setting the custom settings, the user must mark the settings as Custom by enabling the Custom check box.

To add custom syntax:

  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 Source Filter Columns or Target Filter Columnsdepending on whether the where clause should be applied to the target or source table.
  8. Click the Custom check box to enable it.
  9. Click Custom Settings to expand it.
  10. Enter the beginning qualifier, if any, to place around the values in the Beginning Qualifier field.
  11. Enter the ending qualifier, if any, to place around the values in the Ending Qualifier field.
  12. Enter the separator to use for data values in the Separator field.
  13. Enter the format of the Where Statement in the Where Statement field.

NOTE: dspCompose™ allows two dynamic substitution values to be used in the where statement: #ColumnName# is the name of the column. #Data# is a comma-separated list of the data.

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.
Refer to Enter a Where Clause for more information.