Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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?
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: