SAP Knowledge Base Article - Public

3028318 - How to Adjust Queries and Formulas Referencing UseCustomPricing Column

Symptom

The UseCustomPricing column will be removed from the PRODUCTS table in the database and the new column PricingType will be used in its place as part of 2102 release. Currently, the column PricingType exists in parallel with UseCustomPricing. However, only PricingType will be used starting with 2102. If any Iron Python scripts, SAP CPQ formulas or report module views were using this column in queries towards the PRODUCTS database table, they should be properly adjusted.

Environment

SAP CPQ

Reproducing the Issue

You have any Iron Python scripts, SAP CPQ formulas or report module views using the column UseCustomPricing of PRODUCTS table.

Cause

The UseCustomPricing column will be removed from the PRODUCTS table in the database as of 2102 release.

Resolution

You will have to adjust the script, formula or report to point to the correct column.

e.g.:

  • Any formulas that can call a custom query and are referencing the UseCustomPricing column. Examples are LIST and TABLE tags.
    • Before: <*TABLE(Select top 1 UseCustomPricing from PRODUCTS)*>
    • After: <*TABLE(Select top 1 PricingType from PRODUCTS)*>

ParseString can also be used to perform the table tag from this example. Additionally, the AUX tag, which is an older version of the TABLE tag, should be considered when correcting formulas.

  • Any Iron Python scripts referencing the UseCustomPricing column (such as SqlHelper scripts).
    • Before: SqlHelper.GetList(“Select top 1 UseCustomPricing from PRODUCTS”)
    • After: SqlHelper.GetList(“Select top 1 PricingType from PRODUCTS”)
  • Any custom queries in the report module referencing the UseCustomPricing column.

The SAP CPQ team will create the appropriate SQL queries to fix stored procedures and database views, which can’t be edited by clients.

The new PricingType column can also have the following values:

  1. Pricebook Lookup
  2. Custom Pricing
  3. Subscription Pricing
  4. Variant Pricing

See Also

 SAP CPQ 2102 What's New

Keywords

CPQ, UseCustomPricing, PricingType , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Product Enhancement

Product

SAP CPQ 2021