SAP Report Connector - Multiple rows per records

[jbeierschmitt]

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

[suniljain]

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

[suniljain]

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

[jbeierschmitt]

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]

Pls try in qlikview sap connector latest version.

[#6]

Hi jbeierschmitt,

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