find_duplicates
Identifies duplicate SAP table entries by grouping rows with matching field values and returns the largest groups first for audit, reconciliation, or cleanup.
Instructions
Groups of rows sharing the same values on fields (comma list), computed in SAP, most frequent first. E.g. duplicate invoices: table=RBKP, fields=LIFNR,XBLNR,RMWWR. where: ABAP Open SQL. min_count default 2; top max 1000.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | ||
| table | Yes | ||
| where | No | ||
| fields | Yes | ||
| min_count | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |