SAP B1 Hana Query with Date parameter in Variable

6 days ago 4

Hi. 

I request enactment regarding instauration of a query successful SAP b1 Hana Query generator, that tin instrumentality Date arsenic parameter and walk it successful variable. And past fetch information connected that basis.

This is working:

Declare DateF Date;
DateF := '20241022';
Select "DocNum" From OINV Where "DocDate" = DateF;

One that is not moving and is required.

Declare DateF Date;
DateF := [%0];
Select "DocNum" From OINV Where "DocDate" = DateF;

Read Entire Article