2 Replies Latest reply: Mar 21, 2014 8:23 AM by Sistemas Inveravante RSS

    Where condition in SAP REPORT

    Fernando Keuroglian

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