SAP BW BEx Query Connector has the following known limitations:
•You cannot extract a large volume of data in SAP BW BEx Query mappings.
• You cannot read a large number of columns and rows. You can read less than 10 to 15 columns and 45,000 rows without performance degradation.
To know more about the performance details of SAP BW BEx Query Connector, see KB article 000160936.
•You cannot read data from the SAP BW BEx query that contains more than one key figure structure. The value of each key figure must be in a single currency.
•You cannot read data from free characteristics. Even though the free characteristic fields appear in the response structure, the data from the free characteristics is not fetched in the output.
•You cannot read data from the SAP BW BEx query that contains the following components:
- Characteristic hierarchies
- Characteristic structures
•You cannot perform an SAP BW BEx query data extraction when the technical name of the variable in the BEx Query Designer exceeds eight characters.
•You can only configure characteristics as rows and key figures as columns in the SAP BEx Query mapping.