Access SAP R3 reports through QV SAP Connector

[#1]

Hello

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

Thanks.

V.

[disqr_rm]

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]

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]

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]

Thanking You,

This hepl me lot in further research.

[#6]

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]

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]

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]

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

[#10]

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.

[#11]

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.