Unable to fetch data using sap bapi connector - Qlik Community

sadiaasghar · ‎2020-12-18

I am unable to reload data from a Bapi function module using sap connector.

The following error is occuring:

/QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Forbidden words used)

I am unable to understand why this is not running. Script is attached. Please have a look @sunny_talwar @Kushal_Chawda

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST= HostIP; SYSNR=03;CLIENT=500;KeepCasing=1;NullDate=1;XUserId=fcYITYRNJbaMXUVMXTIB;XPassword=aHKZfZEMCLMSDbANWRUB;";

[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":"0000" },
{ "direction":"in", "length":15, "name":"KAGRU", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":4, "name":"KOKRS", "optional":true, "type":"CHAR", "value":" " },
{ "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":" " },
{ "direction":"in", "length":2, "name":"PERIO_TO", "optional":true, "type":"BCD", "value":" " },
{ "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 * FROM [ZAK_COST_ELEM_FM_OUTTAB] INTO $(vDirectoryPath)ZAK_COST_TABLE.QVD(qvd);
DROP TABLE [ZAK_COST_ELEM_FM_OUTTAB];

cwolf · ‎2020-12-23

You have to use the BAPI Connector:

CUSTOM CONNECT TO "Provider=QvSAPBAPIConnector.dll;ASHOST= HostIP; SYSNR=03;CLIENT=500;XUserId=fcYITYRNJbaMXUVMXTIB;XPassword=aHKZfZEMCLMSDbANWRUB;";

sadiaasghar · ‎2020-12-23

i am using sap BaPi connector. Now connection string is working. I have 4 required parameters in bapi I’m passing parameter cause through variable.one of the required field is fiscal year. For the first time I run it for a single fiscal year. I am unable to understand how to reload data For all fiscal years all at once. Please guide @cwolf as I am doing it for 1st time.

cwolf · ‎2020-12-28

You can use a loop, for example:

for gjahr=2010 to Year(Today())
	
	[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":"$(gjahr)" },
	.
	.
	.
	
next;