Skip to Content
0
Former Member
Apr 05, 2011 at 09:54 AM

Export Data - first column is row#

14 Views

Hi Experts,

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]+'%'

Cheers