topic Re: SAP Report Connector - Multiple rows per records in QlikView

SAP Report Connector - Multiple rows per records

jbeierschmitt — Mon, 26 Jan 2026 21:26:37 GMT

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

Re: SAP Report Connector - Multiple rows per records

suniljain — Thu, 27 Oct 2011 07:10:32 GMT

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

Re: SAP Report Connector - Multiple rows per records

suniljain — Thu, 27 Oct 2011 08:55:30 GMT

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

Re: SAP Report Connector - Multiple rows per records

jbeierschmitt — Fri, 28 Oct 2011 22:22:00 GMT

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.

SAP Report Connector - Multiple rows per records

suniljain — Tue, 01 Nov 2011 05:35:34 GMT

Pls try in qlikview sap connector latest version.

SAP Report Connector - Multiple rows per records

Mon, 05 Dec 2011 07:36:15 GMT

Hi jbeierschmitt,

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