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...
