Skip to Content
0
Feb 10, 2016 at 04:46 PM

SAP HANA query to return Invoices that do not have UDF Advice filled in after 30 days

42 Views

Experts,

I have a customer who wants a query to show only Invoices that after 30 days of posting do not have a UDF filled in. This is on SAP HANA could and I started this query with the generator, which added the ".

The red part is which gives me errors, without that the query is correct.

SELECT T0."DocNum", T0."DocDate", T0."CardName", T0."U_L", T0."U_ACC_02", T0."U_ACC", T0."U_ACC_01", T0."PaidToDate", T0."DocTotal" FROM OINV T0

WHERE T0."DocDate" >= dateadd(day,datediff(day,30,GETDATE()),0)

AND T0."DocDate" < dateadd(day,datediff(day,0,GETDATE()),0)

AND T0."U_ACC_01" IS NULL

Your help would be appreciated,

Marli