Skip to Content
0
Jan 29, 2021 at 11:15 AM

query correction for SAP BUSINESS ONE HANA

101 Views

Dear all,

declare @string nvarchar(255) = '';

declare @fdate DATE = ''

declare @tdate DATE = ''

select sum("DocTotal") from OINV where OINV."CardCode" like '%'+ 'CFA0001' +'%'

and cast(@fdate as 'date')

between cast(@fdate as 'date') and cast(@tdate as 'date')

Help me on query for SAP Business One HANA

Regards,

Nikunj