To search for free numbers via tables T077S or SKA1. Attention: Only numeric number ranges are supported. Beispiel This example searches for free G/L account numbers for the first 3…
Reduces the result to a unique subset using one or more column lists. It thus offers a similar functionality as GROUP BY or DISTINCT. Example In the following, a result table…
Removes characters in result columns on the specified side. Example In this example, a ClientQuery generates 2 result rows on which the filter removes leading zeros. — !ClientQuery Id: TwoAgents…
Fills values of result columns with characters up to the specified length. Example In this example, a ClientQuery generates 3 result rows, on which the filter inserts leading zeros until…
The EmbedQuery filter executes a separate query tree for each incoming row and appends the result in a new column as a record. This makes it possible, for example, to obtain the…
Appends a line to the result if the node itself does not return a result. Attention: There is no check if the column names from the node match the column names from…
Optionally, ResultFilters can be attached to the SapQuery, ClientQuery or FirstWithResult nodes for processing the node result. The filters are processed in the specified order. Overview: The following filters are available…
