Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sasghar12
Contributor
Contributor

Table not found when creating qvd file in qlikview

This is my script for incremental load. Its work fine without store statement but with store statement it is giving error table not found. I don't get what i am doing wrong here.

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

let vDateFrom='20130701';
let vDateTo= Date(Today(), 'YYYYMMDD');


[CAP_STAT]:
LOAD *;
SQL {
"function":"ZAK_CAP_STAT_RPT_FM_PAR",
"output":"OUTTAB_CAP_STAT",
"parameters":
[
{ "direction":"in", "length":12, "name":"AR_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":12, "name":"AR_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":8, "name":"BUD_HEAD_HIGH", "optional":true, "type":"NUM", "value":"00000000" },
{ "direction":"in", "length":8, "name":"BUD_HEAD_LOW", "optional":true, "type":"NUM", "value":"00000000" },
{ "direction":"in", "length":8, "name":"GR_DATE_HIGH", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"GR_DATE_LOW", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"PO_DATE_HIGH", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"PO_DATE_LOW", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":10, "name":"PO_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"PO_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":8, "name":"PROJ_DEF_DATE_HIGH", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":8, "name":"PROJ_DEF_DATE_LOW", "optional":true, "type":"DATE", "value":"00000000" },
{ "direction":"in", "length":24, "name":"PROJ_DEF_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":24, "name":"PROJ_DEF_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"PR_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":10, "name":"PR_LOW", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":24, "name":"WBS_HIGH", "optional":true, "type":"CHAR", "value":" " },
{ "direction":"in", "length":24, "name":"WBS_LOW", "optional":true, "type":"CHAR", "value":" " },
{
"direction":"tables",
"name":"OUTTAB_CAP_STAT",
"optional":true,
"table":
[
{ "field":"PD_PSPNR", "length":8, "type":"NUM", "values":[] },
{ "field":"PD_PSPID", "length":24, "type":"CHAR", "values":[] },
{ "field":"PD_POST1", "length":40, "type":"CHAR", "values":[] },
{ "field":"PD_OBJNR", "length":22, "type":"CHAR", "values":[] },
{ "field":"PD_VERNR", "length":8, "type":"NUM", "values":[] },
{ "field":"PD_VERNA", "length":25, "type":"CHAR", "values":[] },
{ "field":"PD_ERNAM", "length":12, "type":"CHAR", "values":[] },
{ "field":"PD_ERDAT", "length":8, "type":"DATE", "values":[] },
{ "field":"WBS_PSPNR", "length":8, "type":"NUM", "values":[] },
{ "field":"WBS_POSID", "length":24, "type":"CHAR", "values":[] },
{ "field":"WBS_POST1", "length":40, "type":"CHAR", "values":[] },
{ "field":"WBS_OBJNR", "length":22, "type":"CHAR", "values":[] },
{ "field":"WBS_VERNR", "length":8, "type":"NUM", "values":[] },
{ "field":"WBS_VERNA", "length":25, "type":"CHAR", "values":[] },
{ "field":"WBS_PRART", "length":2, "type":"CHAR", "values":[] },
{ "field":"WBS_PRART_DES", "length":40, "type":"CHAR", "values":[] },
{ "field":"WBS_ERNAM", "length":12, "type":"CHAR", "values":[] },
{ "field":"WBS_ERDAT", "length":8, "type":"DATE", "values":[] },
{ "field":"AUFNT_FULL", "length":12, "type":"CHAR", "values":[] },
{ "field":"AUFNT", "length":12, "type":"CHAR", "values":[] },
{ "field":"AR_REL_DAT", "length":8, "type":"DATE", "values":[] },
{ "field":"WBS_SUP_PSPNR", "length":8, "type":"NUM", "values":[] },
{ "field":"WBS_SUP_POSID", "length":24, "type":"CHAR", "values":[] },
{ "field":"WBS_SUP_POST1", "length":40, "type":"CHAR", "values":[] },
{ "field":"APRV_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"APP_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"ACT_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"COMM_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"BELNR", "length":10, "type":"NUM", "values":[] },
{ "field":"BLDAT", "length":8, "type":"DATE", "values":[] },
{ "field":"GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"AUFNR_FULL", "length":12, "type":"CHAR", "values":[] },
{ "field":"AUFNR", "length":12, "type":"CHAR", "values":[] },
{ "field":"SN_REL_DAT", "length":8, "type":"DATE", "values":[] },
{ "field":"BANFN", "length":10, "type":"CHAR", "values":[] },
{ "field":"BNFPO", "length":5, "type":"NUM", "values":[] },
{ "field":"PR_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"MATNR", "length":18, "type":"CHAR", "values":[] },
{ "field":"TXZ01", "length":40, "type":"CHAR", "values":[] },
{ "field":"PREIS", "length":10, "type":"BCD", "values":[] },
{ "field":"EBELN", "length":10, "type":"CHAR", "values":[] },
{ "field":"EBELP", "length":5, "type":"NUM", "values":[] },
{ "field":"PO_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"PO_KNTTP", "length":1, "type":"CHAR", "values":[] },
{ "field":"NETWR", "length":10, "type":"BCD", "values":[] },
{ "field":"EFFWR", "length":10, "type":"BCD", "values":[] },
{ "field":"GR_BELNR", "length":10, "type":"CHAR", "values":[] },
{ "field":"GR_GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"GR_BUZEI", "length":4, "type":"NUM", "values":[] },
{ "field":"GR_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"GR_MENGE", "length":7, "type":"BCD", "values":[] },
{ "field":"GR_WRBTR", "length":10, "type":"BCD", "values":[] },
{ "field":"INV_BELNR", "length":10, "type":"CHAR", "values":[] },
{ "field":"INV_GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"INV_BUZEI", "length":4, "type":"NUM", "values":[] },
{ "field":"INV_DATE", "length":8, "type":"DATE", "values":[] },
{ "field":"INV_MENGE", "length":7, "type":"BCD", "values":[] },
{ "field":"INV_WRBTR", "length":10, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_1", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_1", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_1", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_2", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_2", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_2", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_3", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_3", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_3", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_4", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_4", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_4", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_5", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_5", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_5", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_6", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_6", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_6", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_7", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_7", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_7", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_8", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_8", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_8", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_9", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_9", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_9", "length":8, "type":"BCD", "values":[] },
{ "field":"CARRY_BELNR_10", "length":10, "type":"NUM", "values":[] },
{ "field":"CARRY_GJAHR_10", "length":4, "type":"NUM", "values":[] },
{ "field":"CARRY_AMT_10", "length":8, "type":"BCD", "values":[] },
{ "field":"PR_KNTTP", "length":1, "type":"CHAR", "values":[] },
{ "field":"PR_COM_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PR_COM_QTY", "length":8, "type":"BCD", "values":[] },
{ "field":"PR_COM_GJAHR", "length":4, "type":"NUM", "values":[] },
{ "field":"PO_COM_AMT", "length":8, "type":"BCD", "values":[] },
{ "field":"PO_COM_QTY", "length":8, "type":"BCD", "values":[] },
{ "field":"PO_COM_GJAHR", "length":4, "type":"NUM", "values":[] }
]
}
]
};

*****

store [CAP_STAT] into $(vDirectoryPath)CAP_STAT.qvd(qvd);

Labels (1)
5 Replies
sasghar12
Contributor
Contributor
Author

I am retrieving data from SAP using  SAP BAPI connector. Kindly look into it. It is urgent.

jonathandienst

Either the CAP_STAT query is returning nothing, or CAP_STAT is getting autococatenate to a previously loaded table the same set of fields.

If you think its the latter, add NoConcatenate to the load

CAP_STAT:
NoConcatenate

.....

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sasghar12
Contributor
Contributor
Author

I have deleted previously loaded data using drop table statement and when i run this script without store it is showing data in tabular view that means table is present in memory so why error is occuring. 

 

sasghar12
Contributor
Contributor
Author

Actually it was working fine before but when i added script again to generate qvd it keeps on giving me error.

Brett_Bleess
Support (Former)
Support (Former)

Best thing in these cases is to start with the Script/Document log:

How to enable Script/Document Log 

Without, bit difficult to say what is going on, so I would start there and if you have the log, attaching that should help us try to help you figure things out.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.