Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
jayshrinipurte
Partner - Creator
Partner - Creator

SAP Report Connector Issue

Hello,

Any one please help to fetch data from SAP Report connector.

Headers of table are divided into 3 rows as you can see in the attachment. We also tried using Auto detect Column width and also skipped the rows by category, still we are facing issue.

 

SAP Report Connector.png

 

Labels (1)
4 Replies
Maria_Halley
Support
Support

@jayshrinipurte 

What product are you using?

jayshrinipurte
Partner - Creator
Partner - Creator
Author

Qlikview SAP Report Connector

Chip_Matejowsky
Support
Support

What is the issue/error?

Have you reviewed the SAP Report Connector log? Can you provide the log for us to review?

 

Best Regards

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
jayshrinipurte
Partner - Creator
Partner - Creator
Author

I am trying to fetch data in Qlik view through SAP Report Connector.

In image you can see that the headers of table divided into three rows. 

We can't fetch the columns in proper format. 

Could you please help.

[ZSDR_SO_DETAILS]:
Load [Field0_!Project!Tower !Flat no.!Sales order Number!Item No.!Customer Number!Booking Date!Carpet area!Saleable Area!Infrastructure Charges!Club House Membership!Agreement value!Applicant Name1 !Old Agreement Value!Sales Document Type!Input Tax Credit!Booking Year! WBS element!Booking month!WBS Description !Customer Outstanding!Material Code !Communication Date with Customer!Broker Name !Revised Broker Name !Comm Date with Customer (Rev)!Due Date for Balance RFR! Base Rate!Floor Rise! PLC!Infra Charges!Allotment Charges!Additional Allotment Charges!Apt. Furnishing Charges! @Rate!Car Park configuration!Car park nos.!Views !Configuration!Booking Source !Service Guarantee Clause!Customer classification!Permananet Address!];
Select SAPREPORT (REPORT (ZSDR_SO_DETAILS), VARIANT (PROJECT_2000), ROWS_PER_RECORD (1), SKIP (T (2), T (3), T (4), T (1), T (6), T (7), T (8), T (5), T (9), T (11)), HEADER (T (12), T (13), T (14)));
Store * from [ZSDR_SO_DETAILS] into ZSDR_SO_DETAILS_PROJECT_2000.QVD;
Drop Table [ZSDR_SO_DETAILS];