CPQ Reporting Module - Query Usage Question

[SAPSupport]

Dear SAP,

We would like to use the reporting module available in CPQ, specifically to build data sources using the “Query” type, which allows custom SQL queries for data selection. We’d like to confirm that when using SQL queries in the reporting module, only SELECT operations are allowed, and any SQL operations that modify data or table structures are prohibited on the system level.

Could you please confirm this? 

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Yes, your understanding is absolutely correct. In the SAP CPQ Reporting Module, when creating custom data sources using the "Query" type, only read-only SQL operations (SELECT) are supported. The system strictly prohibits any SQL commands that modify data or database structures—such as INSERT, UPDATE, DELETE, ALTER, etc.—to ensure data integrity and security.

The reporting module is designed specifically for data retrieval, supporting features like filtering, grouping, and aggregations. This read-only approach aligns with best practices and helps safeguard against unauthorized data manipulation or structural changes.