Problem with the conversion between a db2 database and sap hana and function module

[geogou1973]

Hello,

I have the following problem.

I read a db2 database from as/400 system. After that i take a field and i put it in a variable.

So far all it is OK. Then i put this variable in the function module that i call from a BAPI connector and i don't take any result.

When i put manually the name of the file from the field i have results.

DB2:

LOAD 
MEMBLE
WHERE MEMBLE= 'AP1933202';

SET bpcsvar="=MEMBLE";

IF I PUT SET bpcsvar='AP1933202'; MANUALLY THE FUNCTION MODULES I TAKE RESULTS

SAP_HANA_FUNCTION_MODULE:
[Z_TOTALS_BPCS_FILE_LT_TOTALS]:
LOAD *;
SQL {
"function":"Z_TOTALS_BPCS_FILE",
"output":"LT_TOTALS",
"parameters":
[
{ "direction":"out", "name":"LT_TOTALS", "optional":false },
{ "direction":"in", "length":70, "name":"LV_FILENAME", "optional":false, "type":"CHAR", "value":"$(bpcsvar)" }
]
};

I think that is conversion between the db2 and sap hana.

Have anyone an idea how can i fix this problem ?

Thank you in advance.

[geogou1973]

I think the problem is in the variable.

The value that i can see is  bpcsvar="=MEMBLE" from the variable overview and in the other hand the value is bpcsvar='AP1933202' that i see in the the variable overview.

How can i solve this ?

[Sue_Macaluso]

@geogou1973 Hi, are you using QlikView or Sense?  I would like to move this into the correct product forum.