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?
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.