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;