Where condition in SAP REPORT

fkeuroglian — Mon, 26 Jan 2026 21:26:37 GMT

Hi, i would like to know if it is posible to do a filter or where condition in a SAP REPORT, using sap report connector

I have script to extract info from a sap report but the where condition i try to put does not function ok , and bring all the information

i put the code of the extract table

thank you a lot

Fernando

[RKAEP000]:

Load [Field0_Fecha doc.],

[Field1_Fe.contab.],

[Field2_Centro de coste],

[Field3_Cl.coste],

[Field4_Val./MI],

[Field5_Valor/Mon.tr.],

[Field6_MonT],

[Field7_CCtaCP],

[Field8_Cta.CP],

[Field9_Denominacion cuenta contrapartida],

[Field10_!],

[Field11_Texto de pedido],

[Field12_!],

[Field13_Doc.compr.],

[Field14_!],

[Field15_Texto cab.documento],

[Field16_!],

[Field17_Denominación],

[Field18_!],

[Field19_Denominación objeto],

[Field20_!];

Select SAPREPORT (REPORT (RKAEP000), VARIANT (ZQVIEW3), ROWS_PER_RECORD (1), FIELD_DELIMITER_POSITIONS (0, 11, 22, 40, 51, 65, 87, 93, 101, 114), FIELD_START_POSITIONS (150, 151, 191, 192, 202, 203, 232, 233, 283, 284, 304), SKIP (T (2), T (1), T (3), T (4), T (5), T (6), T (7), T (9)), HEADER (P (0, "!Fecha doc.!Fe.contab.!Centro de coste !Cl.coste ! Val./MI! Valor/Mon.tr.!MonT !CCtaCP !Cta.CP !Denominacion cuenta contrapartida !Texto de pedido !Doc.compr.!Texto cab.documento !Denominación !Denominación objeto !")));

where i have to put the correct filter or where...

Re: Where condition in SAP REPORT

dirk_konings — Wed, 12 Mar 2014 13:59:03 GMT

Hi Fernando,

In the latest release of SAP Connector, you could use 'parameters' and not a Variant. In that case, you can 'filter' on a value just like you do in SAP Client session.

This could be a solution for you.

Otherwise you can do a Resident Load afterwards and put your 'Where' over there.

Dirk

Re: Where condition in SAP REPORT

Fri, 21 Mar 2014 12:23:20 GMT

Hi Fernando,

If you want to have a better extraction time you should create a Variant so the SAP report takes shorter.

Anyway Dirk's second solution it's perfectly fine and even better than putting the where on the extraction.

Adrián F. Leiro

topic Where condition in SAP REPORT in QlikView

Where condition in SAP REPORT

Re: Where condition in SAP REPORT

Re: Where condition in SAP REPORT