Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
I am retrieving data from SAP using SAP BAPI connector. Kindly look into it. It is urgent.
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
.....
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.
Actually it was working fine before but when i added script again to generate qvd it keeps on giving me error.
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