Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Access SAP R3 reports through QV SAP Connector

Hello

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

Thanks.

V.

21 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

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.

suniljain
Master
Master

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.

disqr_rm
Partner - Specialist III
Partner - Specialist III

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.

suniljain
Master
Master

Thanking You,

This hepl me lot in further research.

Not applicable
Author

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?`

BR

Jani (newbie)

suniljain
Master
Master

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

disqr_rm
Partner - Specialist III
Partner - Specialist III

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.

suniljain
Master
Master

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

Not applicable
Author

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.

Not applicable
Author

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.