2015
Theobald Software · .NET · C# · WPF · WinForms · SAP · ABAP
In 2015 I developed a visual table join query builder as part of the Xtract IS product suite. It lets a developer design table joins across SAP tables: select tables, define the relationships, add output fields and limit the result with a criteria designer that builds the WHERE and HAVING clauses. The criteria can be grouped in any way.
On the SAP side I developed a custom BAPI function module (Z_XTRACT_IS_TABLE_JOIN) that processes the join definition and generates a dynamic SAP Open SQL statement, inner and outer joins included. The module also packages the data with a definable package size, for plain queries and for queries with the aggregate functions AVG, COUNT, MAX, MIN and SUM.
Xtract IS connects SAP and SAP BW systems with SQL Server Integration Services. Mass data is extracted with a few clicks, and the suite offers nine components for the different SAP interface technologies. The table join query builder is one of them.
The builder is written in WPF (C#) and sits inside a WinForms dialog. The designer window can be zoomed, and the table fields can be filtered.
Twelve screens, from the table selection to the criteria designer.
