The SAP Business One Integration tool has the ability to produce a structure from a flat database recordset known as ‘Recordset Shaping’. Provided below is an example of the recommended SQL structure…