Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor
Contributor

Re: Table not found when creating qvd file in qlikview

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

Highlighted
MVP
MVP

Re: Table not found when creating qvd file in qlikview

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
Highlighted
Contributor
Contributor

Re: Table not found when creating qvd file in qlikview

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. 

 

Highlighted
Contributor
Contributor

Re: Table not found when creating qvd file in qlikview

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

Highlighted
Digital Support
Digital Support

Re: Table not found when creating qvd file in qlikview

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.