SAP Business One SQL and HANA Prompt Variables

12/07/2016 By 1dash1 Off

/* SELECT FROM [dbo].[OSLP] T1 */
declare @slpName as varchar(155)
/*WHERE*/
set @SlpName = /* T1.SlpName */ ‘[%0]’

/* SELECT FROM [dbo].[OCRD] T2 */
declare @CardCode as varchar(15)
/* WHERE */
set @CardCode = /* T2.CardCode */ ‘[%1]’

/* select from [dbo].[OINV] T0 */

/* select from [dbo].[OSLP] T1 */

Declare FromDate timestamp;

Declare ToDate timestamp;

Declare SALESEMP char(155);

SALESEMP := /* T1.”SlpName” */ ‘[%0]’;

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

ToDate := /* T0.”DocDate” */ ‘[%2]’;

!! Remember to end your HANA SQL Script with a semicolon and replace the single and double quotes above which are enforced formatting !!

Login