Put a variable with SAP BAPI connector

Wed, 16 Dec 2015 13:12:51 GMT

Hi everybody, I have the sap bapi connector to use the sap function: [CIF_GUID_CONVERT_EV_GUID_C32]

I need declare a variable, called vGUID to put in the LOAD/SQL and convert the value of vGUID.

How can I do?

This is my script:

CUSTOM CONNECT TO "Provider=QvSAPBAPIConnector.dll;ASHOST=192.168.111.12;SYSNR=10;CLIENT=100;XUserId=BROIWIRJJaSMVEVIXaKA;XPassword=SILQABJNOJMCFLBOOTNaA;";

LET vGUID = "CA00E54BB5AB1EE589E5EEDF";

[CIF_GUID_CONVERT_EV_GUID_C32]:

LOAD *;

SQL {

"function":"CIF_GUID_CONVERT",

"output":"EV_GUID_C32",

"parameters":

[

{ "direction":"out", "length":22, "name":"EV_GUID_C22", "optional":false, "type":"CHAR", "value":" " },

{ "direction":"out", "length":32, "name":"EV_GUID_C32", "optional":false, "type":"CHAR", "value":" " },

{ "direction":"out", "length":16, "name":"EV_GUID_X16", "optional":false, "type":"BYTE", "value":" " },

{ "direction":"in", "length":22, "name":"IV_GUID_C22", "optional":true, "type":"CHAR", "value": $(vGUID) },

{ "direction":"in", "length":32, "name":"IV_GUID_C32", "optional":true, "type":"CHAR", "value":"" },

{ "direction":"in", "length":16, "name":"IV_GUID_X16", "optional":true, "type":"BYTE", "value":"" }

]

};

topic Put a variable with SAP BAPI connector in QlikView

Put a variable with SAP BAPI connector