bw_update_dtp
Update an SAP BW DTP's filter selections, extraction mode, description, or semantic group. Set complete filter values per field, replace or clear selections, or switch between full/delta extraction.
Instructions
Update DTP properties: description, the value selection of one filter field, extraction mode (Full vs Delta), and/or the semantic group. Use this for setting filter values on existing filter fields. A filter is written per field as a complete selection — a second call on the same field replaces the first, it does not add to it, so pass the whole value set at once. Note: switching extraction mode between Delta and Full (and back) has BW delta-init implications — a later delta load may require re-initialization of the delta on the source.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dtp_name | Yes | DTP name to update (e.g. "DTP_..."). | |
| transport | No | Transport request number. Required on systems with transport obligation. | |
| description | No | New description text for the DTP. | |
| filter_field | No | Filter field to set. Use the exact field name from bw_get_dtp; a name that does not exist is rejected. Requires filter_value or filter_selections. | |
| filter_value | No | One or more values for an Equal selection, comma-separated (e.g. "VAL1,VAL2,VAL3"). REPLACE semantics: the list is the complete selection of that field, so pass all values in one call. An empty string selects the BW initial value (not the literal "#"). For ranges, patterns, exclusions or values containing a comma, use filter_selections. Look values up with bw_get_filter_values first — a wrong value activates cleanly and filters everything away. | |
| extraction_mode | No | Switch the DTP extraction mode. "full" sets extractionMode="F"; "delta" sets extractionMode="D" (only valid for delta-capable sources). Switching modes has delta-init implications — see the tool note. | |
| filter_excluding | No | If true, all values of filter_value are excluded instead of included. Default false. Applies to filter_value only; filter_selections carries a sign per entry. | |
| filter_selections | No | Full selection vocabulary for one filter field, equivalent to an ABAP RANGE table. REPLACE semantics like filter_value, and mutually exclusive with it. Each entry is validated against the operators the field itself publishes, so an unsupported operator is an error instead of a silently ignored setting. | |
| filter_clear_fields | No | Comma-separated list of field names whose value selections are removed. The field is deselected as well unless it carries a filter routine, which then stays the active filter. | |
| semantic_group_fields | No | Comma-separated list of field names that form the semantic group (e.g. "FIELD_NAME,/BIC/FIELD_NAME"). Replaces the current selection completely: the listed fields become the semantic group, all others are deselected. Pass an empty string to clear the semantic group. Use bw_get_dtp to read the available group field names — they must match exactly, including any /BIC/ prefix. | |
| transport_lock_holder | No | Transport lock holder. The transport request that currently owns the object lock. Required on some systems when updating an existing object. |