5 Replies Latest reply: Sep 16, 2014 4:10 AM by Matthias Steiling RSS

    Qlikview -SAP

      I am new and have recently started development in Qlikview.Basically i am looking for creating reports ,dashboards from SAP.At present i donot have a SAP connector in place,so what i am doing is exporting the required tables in excel from SAP for practise.I am working on creditors aging report.What i observed is in SAP there is FM which calculates the due date.How will i do this in excel also wanted to know  using SAP connector howhis would work. I wnated to know whether i am on right direction or is there anything else i need to consider

        • Re: Qlikview -SAP
          s j

          You have to knock of credit amount against each and every debit amount based on first in first out manner .

            • Re: Qlikview -SAP

              Hi Sunil,

              Thanks for the response, can you elaborate more on what you have posted.

                • Re: Qlikview -SAP
                  s j

                  Hi Ashish,

                   

                  I will suggest you to refer QlikView SAP Connector manual . I have broad details on QlikView SAP integration .

                  Still if you have any doubt , let me know .

                   

                  Regards;

                  Sunil

                    • Re: Qlikview -SAP
                      Matthias Steiling

                      Ich bin bis 30.09.2014 abwesend

                       

                      Ich werde Ihre Nachricht nach meiner Rückkehr beantworten.

                      Bei einer kurzfristigen Lösung bitte ich Sie die Mail an Herrn Pohlschmidt

                      (fpohlschmidt@heristo.com/ Tel:-139) oder Herrn Kruschke

                      (akruschke@heristo.com/ Tel:-132) weiterzuleiten oder telefonisch zu

                      kontaktieren.

                       

                       

                      Hinweis: Dies ist eine automatische Antwort auf Ihre Nachricht  "Re:

                      - Qlikview -SAP" gesendet am 16.09.2014 09:31:18.

                       

                      Diese ist die einzige Benachrichtigung, die Sie empfangen werden, während

                      diese Person abwesend ist.

                • Re: Qlikview -SAP
                  Yaniv Feldman

                  In order to get the Due Date you need to use a Function Module.

                  It may be used in the SAP BAPI Connector.

                   

                  another option is to check if the Data is loaded to BW system (assuming you have BW in your company).

                  If yes, there may be a chance that the due date is written in the BW tables for the AR.

                   

                  Otherwise, I don't see other options to calculate it properly.

                   

                  Yaniv