Skip to Content
0
Former Member
May 08, 2014 at 05:35 AM

how i can pass this sy-mandt value in HANA XSJS File

130 Views

Dear Colleagues,

I am using an ABAP Managed Database Procedure in a HANA XSJS Service.

The system i use has HANA as its Primary DB.

I need to pass the client (sy-mandt) and bp id to this procedure and get the customer info.

This client can vary depending depending on the system.

I want to know how i can pass this sy-mandt value in HANA XSJS File or would i need to hardcode it in the xsjs file for the systems .

Code as below:

var body = '{';

var bpid = $.request.parameters.get("BPID");

var conn = $.db.getConnection();

try{

var client = '800';

var pc = conn.prepareCall('CALL "SAPTEST"."CL_CUST_OPEN_INVOICES=>GET_CUST_INFO"(?,?,?) WITH OVERVIEW');

// var cst = conn.prepareCall(pc);

pc.setString(1, client);

pc.setString(2, bpid);

pc.execute();

Please suggest.

Thanks,

Ipsita