former_member728335
Explorer
Member since ‎2021 Feb 02

User Statistics

  • 12 Posts
  • 0 Solutions
  • 5 Kudos given
  • 3 Kudos received

User Activity

SAP Hana division by zero undefined

2021 Apr 08
This is my query in SAP Hana: ,ifnull((T0."AvgPrice" / (Select MAX("Price") from "TESTESREAL"."INV1" T3 inner join "TESTESREAL"."OINV" T4 on T3."DocEntry" = T4."DocEntry" Where T3."ItemCode" = T0."ItemCode" and T4."DocDate" <= CURRENT_DATE)) ,0) ...

How to get previous Week Data using Current_Date Function?

2021 Mar 24
Hi everyone! I need to know how i can get previous week using Current_Date -7 "days" This is my querie getting the Current Date: ,ifnull((Select sum("Quantity") from "TESTESREAL"."PDN1" T1 inner join "TESTESREAL"."OPDN" T2 on T1."DocEntry" = T...

Failed to retrieve data from the database. Details: [Database Vendor Code: 362]

2021 Feb 23
Hi everyone, This failure happens when I try to export a report and save it in some folder. I went to launchpad.support.sap and didn't find the "362" problem. Below is an image. Translation: "Failed to retrieve data from the database. De...

Create searchbox to showing in my filter

2021 Feb 22
Hi expert, Its possible creater a searchbox in my filter? inside my filter i have a lot of data, and i need a search box inside it to be able to search and select what I want. I try to search about this but im always getting information about ...

Hana ODBC Teste connection fail

2021 Feb 02
Hello everyone, I was trying to create ODBC System DNS connection. However while I was creating connection with Data source HDBODBC32, when i try adding the port of the HANA server and testing if the connection was successful, it gave me this error: ...