PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

350+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

How to Use Custom Parameter on Query Manager in HANA

SAP Business One Tips Indonesia Custom Parameter on Query Manager on HANA

In the previous tips, we have shown how to add custom parameters in Query Manager in SQL.

This time we will show you how to add custom parameter criteria to the Query Manager on HANA. Here is an example of a simple query that will be changed into an element of its selection criteria.

With [Date From] – [Date To] in the OINV Table

Declare FromDate timestamp;
Declare ToDate timestamp;

FromDate := ‘20200101’;
ToDate := ‘20200131’;

SELECT * FROM “OINV”
WHERE “DocDate” BETWEEN FromDate AND ToDate

Then, you can change the query into a query with selection criteria as enhancements as below:

/*SELECT * FROM “OINV” T0*/

Declare FromDate timestamp;
Declare ToDate timestamp;

FromDate := /* T0.”DocDate” */ ‘[%0]’;
ToDate := /* T0.”DocDate” */ ‘[%1]’;

SELECT * FROM “OINV”
WHERE “DocDate” BETWEEN FromDate AND ToDate;

You can use the basic composition to declare variables and increase the use of selection criteria for custom queries in the Query Manager feature earlier on the HANA database.

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , ,