fetching data from function module using sap bapi connector in qlikview

sadiaasghar — Thu, 24 Dec 2020 08:53:21 GMT

I am using sap bapi connection to reload data from a function module. I want to create a qvd. Function module have four required input parameters which I have to pass. I am passing them through variable but the problem here is one of the required parameter is fiscal year and we have to pass a single year. I want to fetch data from 2005 till 2021. Please guide me how I can do this. The below script is working fine for a single year. @Kushal_Chawda @Brett_Bleess @sunny_talwar

CUSTOM CONNECT TO "Provider=QvSAPBAPIConnector.dll;ASHOST=HOSTIP;SYSNR=00;CLIENT=500;XUserId=eaCeMGdJUKVGVPBGRZDB;XPassword=MZOHXEZJJCVSUARJTKQAFEB;";

let vPeriodFrom='1';
let vPeriodTo='12';
let vCompany='ABC';
let vFiscalyear='2019';

[ZAK_COST_ELEM_FM_OUTTAB]:
LOAD *;
SQL {
"function":"ZAK_COST_ELEM_FM",
"output":"OUTTAB",
"parameters":
[
{ "direction":"in", "length":4, "name":"GJAHR", "optional":true, "type":"NUM", "value":"$(vFiscalyear)" },
{ "direction":"in", "length":15, "name":"KAGRU", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":4, "name":"KOKRS", "optional":true, "type":"CHAR", "value":"$(vCompany) " },
{ "direction":"in", "length":10, "name":"KOSTL_FROM", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"KOSTL_TO", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":15, "name":"KSGRU", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"KSTAR_FROM", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"KSTAR_TO", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":2, "name":"PERIO_FROM", "optional":true, "type":"BCD", "value":"$(vPeriodFrom) " },
{ "direction":"in", "length":2, "name":"PERIO_TO", "optional":true, "type":"BCD", "value":"$(vPeriodTo)" },
{ "direction":"in", "length":3, "name":"VERSN", "optional":true, "type":"CHAR", "value":" " },
{
"direction":"tables",
"name":"OUTTAB",
"optional":true,
"table":
[
{ "field":"KAGRU1", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU1_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU2", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU2_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU3", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU3_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU4", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU4_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU5", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU5_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU6", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU6_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU7", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU7_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU9", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU9_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU10", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU10_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU11", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU11_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU12", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU12_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU13", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU13_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU14", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU14_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRU15", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRU15_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KAGRUL", "length":15, "type":"CHAR", "values":[] },
{ "field":"KAGRUL_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSTAR", "length":10, "type":"CHAR", "values":[] },
{ "field":"KSTAR_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KOSTL", "length":10, "type":"CHAR", "values":[] },
{ "field":"KOSTL_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU1", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU1_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU2", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU2_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU3", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU3_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU4", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU4_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU5", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU5_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU6", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU6_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU7", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU7_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU8", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU8_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU9", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU9_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU10", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU10_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU11", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU11_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU12", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU12_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU13", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU13_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU14", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU14_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRU15", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRU15_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"KSGRUL", "length":15, "type":"CHAR", "values":[] },
{ "field":"KSGRUL_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"ACT_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PLAN_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PREV_ACT_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PREV_PLAN_AMT", "length":8, "type":"BCD", "values":[] }
]
}
]
};

//*****

STORE ZAK_COST_ELEM_FM_OUTTAB INTO $(vDirectoryPath)COST_ELEMENT_GROUP.qvd(qvd);
DROP TABLE ZAK_COST_ELEM_FM_OUTTAB;

Re: fetching data from function module using sap bapi connector in qlikview

settu_periasamy — Tue, 29 Dec 2020 05:31:22 GMT

Hi @sadiaasghar ,

Can you try with for loop?

Let vStart=2005;
Let vEnd=2021;

For vFiscalYear = vStart to vEnd

//Trace $(vFiscalYear);

Load Statement;

Re: fetching data from function module using sap bapi connector in qlikview

sadiaasghar — Tue, 29 Dec 2020 08:55:26 GMT

I made it work by for loop. But is there a way to provide dynamic values to
vStart and vEnd instead of hard coded ones?

Re: fetching data from function module using sap bapi connector in qlikview

settu_periasamy — Tue, 05 Jan 2021 04:48:29 GMT

Hi @sadiaasghar ,

Yes. You can use your Date field to identify the max year and min year and assign those value into variable.

topic Re: fetching data from function module using sap bapi connector in qlikview in QlikView

fetching data from function module using sap bapi connector in qlikview

Re: fetching data from function module using sap bapi connector in qlikview

Re: fetching data from function module using sap bapi connector in qlikview

Re: fetching data from function module using sap bapi connector in qlikview