Where clause for SAP Report Connector

ngsg_sit — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using SAP Report Connector to load a report. I tried searching but couldn't find a post to about Where clause in SAP report connector. I tried putting in at LOAD statement but my resulting qvd is empty.

E.g.

LOAD [Field9_Funds Ctr]

Where [Field9_Funds Ctr] = 'S01001';

My script as follows:

[RFFMED_DRILLDOWN]:

Load

[Field0_Doc Year],

[Field1_Entry Docu],

[Field2_Line],

[Field3_Version],

[Field4_Doc. Type],

[Field5_Process],

[Field6_Year],

[Field7_Budget Type],

[Field8_Fund],

[Field9_Funds Ctr],

[Field10_Cmmt Item],

[Field11_Funded Program],

[Field12_Amount LC],

[Field13_C];

Select SAPREPORT (REPORT (RFFMED_DRILLDOWN), VARIANT (QLIK), ROWS_PER_RECORD (1), FIELD_DELIMITER_POSITIONS (0, 9, 20, 27, 35, 45, 56, 61, 76, 81, 91, 101, 117, 134, 138), SKIP (P (0, "┌──────────────┬─────┬──────┬────────┐"), P (0, "!Sort criteria !Ascdg!Descnd!Subtotal!"), P (0, "├──────────────┼─────┼──────┼────────┤"), P (0, "!FM Area ! X ! ! !"), P (0, "!Document Year ! X ! ! !"), P (0, "!Entry Document! X ! ! !"), P (0, "└──────────────┴─────┴──────┴────────┘"), P (0, "┌───────────────┬─────────┐"), P (0, "!Data statistics!Number of!"), P (0, "├───────────────┼─────────┤"), P (0, "!Records passed ! 1,412!"), P (0, "└───────────────┴─────────┘"), P (0, "FM area 1000"), P (0, "Currency SGD"), P (0, "Budget Category Payment"), P (0, "┌────────┬──────────┬──────┬───────┬─────────┬──────────┬────┬──────────────┬────┬─────────┬─────────┬───────────────┬────────────────┬───┐"), P (0, "├────────┼──────────┼──────┼───────┼─────────┼──────────┼────┼──────────────┼────┼─────────┼─────────┼───────────────┼────────────────┼───┤"), P (0, "└────────┴──────────┴──────┴───────┴─────────┴──────────┴────┴──────────────┴────┴─────────┴─────────┴───────────────┴────────────────┴───┘")), HEADER (P (0, "!Doc Year!Entry Docu!Line !Version!Doc. Type!Process !Year!Budget Type !Fund!Funds Ctr!Cmmt Item!Funded Program ! Amount LC!C !")));

Store * from [RFFMED_DRILLDOWN] into QVD\RFFMED_DRILLDOWN_QLIK_SG_TEST.QVD;

Drop Table [RFFMED_DRILLDOWN];

EXIT Script;

Re: Where clause for SAP Report Connector

Anil_Babu_Samineni — Thu, 06 Apr 2017 16:06:08 GMT

Can you try here, The variant might doesn't consider as preceding load. I am assuming you are not the person who created this variant. Try this

[RFFMED_DRILLDOWN]:

Load

[Field0_Doc Year],

[Field1_Entry Docu],

[Field2_Line],

[Field3_Version],

[Field4_Doc. Type],

[Field5_Process],

[Field6_Year],

[Field7_Budget Type],

[Field8_Fund],

[Field9_Funds Ctr],

[Field10_Cmmt Item],

[Field11_Funded Program],

[Field12_Amount LC],

[Field13_C] Where [Field9_Funds Ctr] = 'S01001'; // Here, S01001 Case Sensitive

Select SAPREPORT ( ......

Re: Where clause for SAP Report Connector

ngsg_sit — Fri, 07 Apr 2017 01:11:45 GMT

Thanks, it works. Weird that i tried previously it can't...

Re: Where clause for SAP Report Connector

Anil_Babu_Samineni — Fri, 07 Apr 2017 02:14:22 GMT

Could be Even this case i doubt why Preceding load won't consider while loading from SAP. Will check this and update you

Re: Where clause for SAP Report Connector

Anil_Babu_Samineni — Thu, 11 May 2017 05:32:18 GMT

JFU - It's working even pull data from SAP

topic Re: Where clause for SAP Report Connector in QlikView

Where clause for SAP Report Connector

Re: Where clause for SAP Report Connector

Re: Where clause for SAP Report Connector

Re: Where clause for SAP Report Connector

Re: Where clause for SAP Report Connector