Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
What product are you using?
Qlikview SAP Report Connector
What is the issue/error?
Have you reviewed the SAP Report Connector log? Can you provide the log for us to review?
Best Regards
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];