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: 
marniedc
Contributor
Contributor

Qlik Sense using SAP Report connector questions

Hi all,

We have installed Qlik Sense SAP connector in our Qlik sense server and started using the SAP Report connector by following the workaround to use SAP report connector in a Qlik Sense environment.

We are able to pull the data from a SAP report but we are facing some issues on the formatting options. We have not installed Qlikview desktop as suggested by some posts found online to serve as scripting guide while using the report connector. This was a decision made since we are using a production Qlik Sense environment  hence we are using trial and error in scripting.

Now back to the issue we are facing: errors when using the parameter FIELD_AUTO_COLUMNS ()

Below is the script we are using:

[ZMMR002]:
Load *
;
Select SAPREPORT (REPORT (ZMMR002), VARIANT (QLIKTEST), ROWS_PER_RECORD (1), FIELD_AUTO_COLUMNS (9))
;

exit script;

 

Below is function module output from SAP:

marniedc_0-1633506992080.png

We have tried using parameter with the following options but all are failing:

FIELD_AUTO_COLUMNS (9)

FIELD_AUTO_COLUMNS (7)

FIELD_AUTO_COLUMNS (5)


What should be the correct value that comes with the parameter FIELD_AUTO_COLUMNS () to get the data part of the SAP report output?

Appreciate your help. 

Regards,

Marnie

Labels (1)
2 Replies
micheledenardi
Specialist II
Specialist II

Dear Marniedc,

is ZMMR002 a SAP standard report? Which tcode are you using from SAP to run it?

Can you post an example of the error you're getting?

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
marniedc
Contributor
Contributor
Author

Hi @micheledenardi ,

It is a customised report in SAP. Here you will see the error that appears whenever the parameter FIELD_AUTO_COLUMNS is added:

marniedc_0-1636593407511.png