Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jbeierschmitt
New Contributor III

SAP Report Connector - Multiple rows per records

We are using the SAP Report Connector 5.50 SR3 and can successfully retrieve the data from transaction MB5T: Display Stock in Transit (Program RM07MTRB) using a LAYOUT where we select a single material with a single purchase order in the data.  The challenge is that there is a header and position data (columns) in this report.

My problem is that the data will not always come in as 2 rows per record as there could be any number of purchase orders (i.e., rows) for the material listed (see example). 

Has anyone come up with a method to extract this type of SAP Report dynamically?

Thanks

Jim

Tags (1)
5 Replies
suniljain
Honored Contributor

Re: SAP Report Connector - Multiple rows per records

you have to add only required column in layout of variant.

suniljain
Honored Contributor

Re: SAP Report Connector - Multiple rows per records

qlikview report connector is unable to format your data if one record occupy two rows.

jbeierschmitt
New Contributor III

Re: SAP Report Connector - Multiple rows per records

We did find a workaround for this situation - skip the first header row by reference to the string with a specific value (4-digit Plant field in this case).  We then just brought in all rows and then integrated with ECC data to find the other master data elements.

One challenge with SAP Report Connector is to remember that it is a different connection string than the standard ECC or CRM connection.

suniljain
Honored Contributor

SAP Report Connector - Multiple rows per records

Pls try in qlikview sap connector latest version.

Not applicable

SAP Report Connector - Multiple rows per records

Hi jbeierschmitt,

Kindly change the Paper Setting to 1024 as mximum  in SAP report backround layoutand check the spool .it will work .

Community Browser