topic Access SAP R3 reports through QV SAP Connector in QlikView

Access SAP R3 reports through QV SAP Connector

Mon, 26 Jan 2026 21:26:37 GMT

Hello

I was wondering if it is possible to access reports (not just tables) in SAP R3 though QV SAP Connector!

Thanks.

Access SAP R3 reports through QV SAP Connector

disqr_rm — Sun, 11 Oct 2009 07:30:24 GMT

No, with SAP Connector you can only access Tables/Views. Now, if you write a "Z" program which submits your report then imports output list from memory and writes to a "Z" table, then you can read that "Z" table via SAP Connector into QV.

Access SAP R3 reports through QV SAP Connector

Tue, 20 Oct 2009 00:43:57 GMT

With the latest version, 5.3, you can also access SAP queries.

Access SAP R3 reports through QV SAP Connector

Tue, 20 Oct 2009 14:21:38 GMT

Hi QlikView masters,

I'm new in QlikView but our company has this BI Tools for several years. Since we have to migrate our ERP to SAP, so I have to migrate also our QlikView reporting to access the SAP database. I have read several article, the possible way is to install a SAP Connector in our QLikView environment.

I have installed the SAP 5.0 connector, before that I installed QlikView 8.5 Enterprise Edition to our Development Server. I also Installed .net Framework 2.0 and .net Framework 2.0 SP1 as the requirement. but unfortunately I don't have the SAP login WIndow to access the SAP Server after I click Connect.

Do you have any idea to resolve the problem, or is there any missing step of installation which is mandatory to be done? Since I'm new here, consider this question as my introduction in this community. Thanks in advance for the big help, I appreaciate it.

Access SAP R3 reports through QV SAP Connector

Tue, 03 Nov 2009 18:52:12 GMT

Hi!

please check Xtract QV on this page:

http://www.theobald-software.com/oe/cms/website.php?id=/en/index/products/xtractqv/sapr3access.htm

Just scroll down. Xtract QV supports ABAP reports as data source...

Kind regards,

Patrick

Access SAP R3 reports through QV SAP Connector

Thu, 26 Nov 2009 12:21:29 GMT

Hi Blueilham

It might be an idea to have .NET 3.0 or newer and you have to select the data source as SAPDSO (or SAPOLAP) before you hit the connect button to get the pop up sign-on box, once filled in this creates the conection string and then you can hit the DSO button (the 3rd button, script builder will change to DSO something) then you can go and find your ODS or cubes to extract from.

Regards
Greenee

Access SAP R3 reports through QV SAP Connector

Wed, 10 Feb 2010 13:38:54 GMT

With the latest connector, due to be released soon, we will be able to access SAP reports.

Access SAP R3 reports through QV SAP Connector

Thu, 18 Feb 2010 10:46:53 GMT

i've solved the proble in two way:

1) create on sap a webservice and after invoke it fron qlik

2) create a query on R/3 and import the result in qlik ( only with 5.3 connector)

both you can use abap code

Access SAP R3 reports through QV SAP Connector

disqr_rm — Thu, 18 Feb 2010 17:33:36 GMT

I saw a demo of next version of SAP Connector coming in a month or so (I think April, or sometime close to it). Pretty smart. It can run the report in SAP and grab the result list, then you can parse it as you want before you do the actual load in QVW.

Nice work done by QV-SAP group, once again.

Access SAP R3 reports through QV SAP Connector

suniljain — Fri, 09 Jul 2010 16:52:08 GMT

Dear

SAP R/3 Does not allow any external tool to acess the SAP report excluding SAP BI.

You Can Use SAP Method through JCO Connector but Can't Acess Report.

Regards,

Sunil Jain

Access SAP R3 reports through QV SAP Connector

disqr_rm — Fri, 09 Jul 2010 22:05:06 GMT

Not entirely correct. The latest versio of SAP Connector ffrom QV allows you to run any report in SAP and grab it's output as source of data for your QV application. The entire process gets triggered by reload button in QV application.

Access SAP R3 reports through QV SAP Connector

suniljain — Sat, 10 Jul 2010 08:12:52 GMT

Dear Rakesh,

Can You Give me version details ?. It will help me in further research .

Because SAP Does not allow any tool or vendor to run run customize report in outside environment of SAP.

Access SAP R3 reports through QV SAP Connector

disqr_rm — Sat, 10 Jul 2010 13:13:04 GMT

Dear Sunil,

This feature is introduced in Connector v 5.4. See enclosed screen-shot of 5.4 release notes. 🙂

Another enhancement I really love in this version is the parameter in the connection sctring where you can set a flag so all the initial date values '00000000' are converted to 'null' when extracted from SAP. Earlier, these values were stored as 00000000 screwing up the field format, and other logic. No need to say "if(ERDAT = '00000000', null(), ERDAT) as ERDAT. 🙂

Hope this helps.

Access SAP R3 reports through QV SAP Connector

suniljain — Sun, 11 Jul 2010 16:30:23 GMT

Thanking You,

This hepl me lot in further research.

Access SAP R3 reports through QV SAP Connector

Fri, 20 Aug 2010 10:23:44 GMT

Hi Rakesh,

And thank you for information. DOes the new version support also SAP report transactions, lets say for example MD04 - Display Stock/Requirements Situation or FBL1N - Vendor Line Items, or do you need to create a separate Z-query using FM etc. in order to get the data to show in QlikView reports?`

Jani (newbie)

Access SAP R3 reports through QV SAP Connector

suniljain — Fri, 20 Aug 2010 13:02:37 GMT

You can Access Standard and Customize report through SAP Connector.

You can Access SAP Standard Reprot like MB51,MB5B,.... Through SAP Connector.

If you have "Z" Report . it is also accessible from SAP Connector.

Regards

Sunil

Access SAP R3 reports through QV SAP Connector

disqr_rm — Sat, 11 Sep 2010 14:11:44 GMT

Hi Jani,

If it's a report type program (type 1 in the program attribute) and throws a list output, you should be able to call via connector. Otherwise, as Sunil mentioned, you can create a simple "Z" program or an ABAP query to be able to pull that data into QV via QVC.

Access SAP R3 reports through QV SAP Connector

suniljain — Fri, 31 Dec 2010 11:22:41 GMT

Yes , You can extract data from FBL1n and MDO4 by Making variant of thar report.

Access SAP R3 reports through QV SAP Connector

Thu, 06 Jan 2011 22:33:31 GMT

Hello Rakesh

I need to extract data (a lot of data from MB51) this transaction calls an abap program or report RM07DOCS we started a test project with SAP Qlikview Connector 5.30 now that I see that since version 5.40 and current 5.5 QV SAP Connector does have a way to access this programs. I wonder do you have a clue how to get this working maybe a small how to?

Many thanks in advance.

Access SAP R3 reports through QV SAP Connector

Thu, 06 Jan 2011 22:42:51 GMT

Hello Rakesh

Many thanks in advance.