I'm submitting this question of behalf of a client who is trying to export data from B1 into csv (so he can upload into my system). I have no knowledge of SAP, but he sent me the query he is using and it looks like pretty standard sql. The problem is that when he exports the data the first column is labled # and contains the row number.
Any ideas how he can avoid outputting this column?
Here's the sql
SELECT T0.[CardCode] AS 'BeneficiaryID', T0.[CardName] AS 'BeneficiaryName', '="'T1.DflBranch'"' AS 'SortCode', '="'T1.DflAccount'"' AS 'AccountNo', T0.[TrsfrRef] AS 'Reference', CASE WHEN T0.DocTotalFC = 0 THEN T0.[DocTotal] ELSE T0.DocTotalFC End AS 'Amount' FROM [dbo].[OVPM] T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode
WHERE T0.DocDate >= [%0] AND T0.DocDate <= [%1]
AND T0.CardName LIKE [%2]+'%'