7 Replies Latest reply: Jul 19, 2017 2:41 PM by klayton Barros RSS

    SAP Report Error

    klayton Barros

      I'm having trouble configuring FIELD_AUTO_COLUMNS in sap report, because the category for the report header is ranging from 2 to 3.

      Does anybody experienced this and can  help me?

      Grateful!

        • Re: SAP Report Error
          Tomas Sommergyll

          Hi Klayton,

           

          In the Gui, was it possible to select the checkbox for "Auto Detect Column Width" ?

           

          If yes, what happens when doing a "Reload" ?

          If no, because it is disabled -  then it may not be possible to use the "Auto Detect..." feature.

           

          Can you add the script too?

           

          Br,

          Tomas

            • Re: SAP Report Error
              klayton Barros

              In the Gui, was it possible to select the checkbox for "Auto Detect Column Width" ?

              Yes, it was.

               

              *** Its DONT work ( see FIELD_AUTO_COLUMNS (2) )


              Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (2),

              OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161201, HIGH 20161201)

              (SELNAME  (S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005769548, HIGH 9005769548)))

               

              *** Its work ( see FIELD_AUTO_COLUMNS (3) )

               

              Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (3),

              OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161201, HIGH 20161201)

              (SELNAME S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005769548, HIGH 9005769548)))

               

              However

               

              *** Its work ( see FIELD_AUTO_COLUMNS (2) )

               

              Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (2),

              OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161125, HIGH 20161125)

              (SELNAME  (S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005750120, HIGH 9005796298)))

               

              *** Its DONT work ( see FIELD_AUTO_COLUMNS (3) )

               

              Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (2),

              OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161125, HIGH 20161125)

              (SELNAME  (S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005750120, HIGH 9005796298)))

               

              *** Note that only the parameters are modified ***

              • Re: SAP Report Error
                klayton Barros

                Hi Tomas

                 

                Yes,  "Auto Detect Columm Width" was able

                 

                Observe the clause FIELD_AUTO_COLUMNS  in the following instructions

                 

                Its dont work

                 

                Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (2),

                OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161201, HIGH 20161201)

                (SELNAME  (S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005769548, HIGH 9005769548)))

                 

                Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (3),

                OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161201, HIGH 20161201)

                (SELNAME S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005769548, HIGH 9005769548)))

                 

                 

                 

                However, its work

                 

                Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (3),

                OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161201, HIGH 20161201)

                (SELNAME  (S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005769548, HIGH 9005769548)))

                 

                Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (2),

                OPTIONS ((SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20161201, HIGH 20161201)

                (SELNAME S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9005769548, HIGH 9005769548)))

                • Re: SAP Report Error
                  klayton Barros

                  Hi Tomas,

                   

                  Another information, sometimes the result for the statement below shows the report header as an output and in other executions with the same parameters the result is another, without the header line

                   

                  Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1) , FIELD_AUTO_COLUMNS (2),

                  OPTIONS (

                    (SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW 20170523, HIGH 20170523),

                    (SELNAME S_VBELN, KIND S, SIGN I, OPTION BT, LOW 9006086872, HIGH 9006383819))

                    );

                   

                  SAPREPORT.png

                • Re: SAP Report Error
                  Tomas Sommergyll

                  Hi Klayton,

                   

                  Which version of the Qlik SAP Report Connector are you using?

                  When you first choose this Report, which number is shown in the FIELD_AUTO_COLUMNS - parameter in the script, is it '2' or '3' (or something else)?

                   

                  Reports are in nature tricky to handle for the connector as it depends on a spool file being generated from SAP when running the job. This spool file contains several control tables, like the Category, that are used by the auto detect feature. As it is implemented today, the auto detect feature needs a fairly straightforward report structure, although the content may be changing in width from one job to another, depending on the data.

                   

                  Having a more complex report, it may be necessary to build the script manually in the GUI (see Qlik online help for more info).


                  Br,

                  Tomas

                  • Re: SAP Report Error
                    neha shirsath

                    Hi Klayton,

                     

                    How frequently your width of that field get change??

                    Because I was facing the same issue then i was use to fix it manually calculating width of every fields.

                     

                    And it is customized Z report you are fetching?

                     

                    Thanks,

                    Neha

                    • Re: SAP Report Error
                      klayton Barros

                      Hi everyone, thank you all

                      I found the solution, developing the script manually in this way

                       

                      [ZSDR_MADAT_AUX]:

                      Load

                      SubField([Field0_],'!',2) AS 'Doc.fatur.',

                      SubField([Field0_],'!',6) AS 'Data',

                      SubField([Field0_],'!',13) AS 'Chave de tabela',

                      SubField([Field0_],'!',14) AS 'Prorrogação';

                       

                      Select SAPREPORT (REPORT (ZSDR_MADAT), ROWS_PER_RECORD (1),

                      SKIP (P(0,"┌──────────┬─────────┬──────────┬─────┬──────────┬────────┬────────────┬──────┬─────────────────────┬─────────┬─────┬────────────────────────┬──────────┬──────────┐"),

                           P(0,"!Doc.fatur.!TpDocFat.!Dt.fatur. !Empr.!Data      !Hora    !Usuário     !Objeto!Valor do objeto      !Nº doc.  !Campo!Chave de tabela         !Valor novo!Val.antigo!"),

                           P(0,"├──────────┼─────────┼──────────┼─────┼──────────┼────────┼────────────┼──────┼─────────────────────┼─────────┼─────┼────────────────────────┼──────────┼──────────┤"),

                           P(0,"└──────────┴─────────┴──────────┴─────┴──────────┴────────┴────────────┴──────┴─────────────────────┴─────────┴─────┴────────────────────────┴──────────┴──────────┘")),

                      OPTIONS (

                      (SELNAME S_FKDAT, KIND S, SIGN I, OPTION BT, LOW $(vDateMin), HIGH $(vDateMax))

                      (SELNAME S_VBELN, KIND S, SIGN I, OPTION BT, LOW $(vDocMin), HIGH $(vDocMax))));