query correction for SAP BUSINESS ONE HANA

[nikunjmehta2290]

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

[brunopbaffonso]

There is some materials in Internet about the PL/SQL for HANA Databases.

Follow some links very useful:

https://help.sap.com/doc/6254b3bb439c4f409a979dc407b49c9b/2.0.04/en-US/SAP_HANA_SQL_Script_Reference...

https://www.dngsystems.com/wp-content/uploads/2018/11/How_to_Convert_SQL_from_MS_SQL_Server_to_SAP_H...

[kothandaraman_nagarajan]

Hi,

What is the issue with above query?

Regards,

Nagarajan

[nikunjmehta2290]

How can i convert into HANA?

E.X.
Input

Codes : Business Partner Code1 , Business Partner Code2, ........... Upto N.. (Multiple separated by coma)

Form Date and To Date

Output:
Outstanding

500000 (Business Partner Code1 , Business Partner Code2, ........... Upto ) (Total of all as inputed)