topic Re: please check script in QlikView

please check script

Mon, 22 Dec 2014 12:25:10 GMT

hi,

I Have this script.

Plz tell me where I am wrong.

let vFromDATE = '20130101';
let vToDATE= '20131231';

[VBRK]:

Load


   [VBELN] as [Billing Document_VBELN.VBRK],
   [FKDAT] as [Billing date_FKDAT.VBRK];

SQL Select VBELN FKDAT from VBRK

WHERE FKDAT >= '$(vFromDATE)'and FKDAT <= '$(vToDATE)'
;

Left join([VBRK])

[VBRP]: // Billing Document: Item Data
Load

[VBELN] as [Billing Document_VBELN.VBRK].....

SQL Select VBELN from VBRP
;
STORE * FROM [VBRP] INTO F:\...............................\VBRP2013.QVD(qvd);
DROP TABLE [VBRP];

thanks

Re: please check script

anbu1984 — Tue, 23 Dec 2014 06:14:45 GMT

SQL Select VBELN , FKDAT from VBRK //Add comma between fields

Is format of FKDAT same like the format of variables vFromDATE and vToDATE ?

Re: please check script

Tue, 23 Dec 2014 06:25:30 GMT

Think the date format is correct, even though the output might have diff format.

Think it might be due to the lack of "space" between the date and "and" as per the bold below

SQL Select VBELN FKDAT from VBRKWHERE FKDAT >= '$(vFromDATE)'and FKDAT <= '$(vToDATE)'

Give it a try.

Re: please check script

its_anandrjs — Tue, 23 Dec 2014 06:26:55 GMT

Hi,

Try this your complete SQL SAP script.

[VBRK]:
Load
[VBELN], //Create this another field for table joining
[VBELN] as [Billing Document_VBELN.VBRK],
[FKDAT] as [Billing date_FKDAT.VBRK];
SQL Select VBELN,FKDAT from VBRK //And you left comma here also
WHERE FKDAT >= '$(vFromDATE)' and FKDAT <= '$(vToDATE)';

Left join([VBRK])

[VBRP]: // Billing Document: Item Data
Load
[VBELN], //Create this another field for table joining
[VBELN] as [Billing Document_VBELN.VBRP]; //check this field also i rename here suppose it is from VBRP
SQL Select VBELN from VBRP;
STORE * FROM [VBRP] INTO F:\...............................\VBRP2013.QVD(qvd);
DROP TABLE [VBRP];

Regards

Anand

Re: please check script

Tue, 23 Dec 2014 06:27:12 GMT

SQL Select VBELN FKDAT from VBRK

WHERE FKDAT >= '$(vFromDATE)'and FKDAT <= '$(vToDATE)'

Re: please check script

Tue, 23 Dec 2014 06:39:04 GMT

Hi Shrivas,

in the end of your script you are left joining VBRP to VBRK and then you are storing VBRP table using store command.

once left join is done you will not be able to find the table Named VBRP to Store

check whether it is either VBRK .

Thanks

Re: please check script

alkesh_sharma — Tue, 23 Dec 2014 07:03:29 GMT

Mr. Srivas,

I told you to to use use SQL Join to fetch the data from SAP server.

In which universe, do you use LEFT JOIN(TABLE) in SQL Query???

Read syntax for Joins in SQL and copy paste that statement..

Re: please check script

Tue, 23 Dec 2014 10:02:39 GMT

Hi all,

Thanks everybody for your replies.

Got my solution.

Used where subquery after vbrp. And it worked fine.

Thanks ,

S Shrivas