CPQ Package Architecture

Owned by Jana Volencová (Deactivated)
Sept 01, 2023
2 min read

Library Dependency

  • ApprovalWorkflow

  • FormulaEvaluator

Data Structures

Mandatory Tables

Table Type

Table Name

Mandatory Fields

Optional Fields

Description

Table Type

Table Name

Mandatory Fields

Optional Fields

Description

Product Extension

ProductCosts

  • Product Id

  • Cost

  • Currency

  • Target Date

  • Valid To Date

  • Additional dimensions filter

Contains cost per product which is used in the CPQ cost output element.

Product



  • Product Id (SKU)

  • Label





Customer



  • Customer Id

  • Name





Optional Tables

Table Type

Table Name

Mandatory Fields

Optional Fields

Description

Table Type

Table Name

Mandatory Fields

Optional Fields

Description

Product Extension

PriceGuidance

  • Product Id

  • Target

  • Floor

  • Stretch

  • Additional dimensions

  • Target date

Contains price guidance per product, included target price, floor price and stretch price.

Product Extension

PriceCompetitors

  • Product Id

  • Competitor

  • Price

  • Target date

Contains a competitor price per product.

Customer Extension

CustomerCashDiscount

  • Customer Id

  • Discount

  • Target date

Contains discount information per customer (customer ID).

Pricing Parameter

StandardDiscount

  • Key1 – Key6

  • Discount

  • Value Type

  • Target date

Standard discount configuration. There are six keys to configure to what discount a value belongs. It can also be defined if the discount value is a percentage or absolute value.

Pricing Parameter

ExceptionDiscount

  • Customer (key1)

  • Product (key2)

  • Discount (attribute1)

  • Target date

Exception for the discount configuration. The exception discount is defined for customer/product pairs. Values for the customer and product can be an attribute in the customer/product data or in PX/CX.

Pricing Parameter

CPQInputConfiguration

  • Name

  • Label

  • Input Type

  • Source table

  • Source type

  • Source field

  • Value options

  • Default value

  • Value hint

  • Required

  • Level

  • Customer Filter

  • Product Filter

  • Value options filtered by customer

  • Value options filtered by product

Contains configurations for custom inputs.

Pricing Parameter

CPQOutputConfiguration

  • Name

  • User group

Contains configurations for outputs.

Product Extensions

  • PriceByCustomer – Contains a price per product per customer which is considered to be a list price of the product.

    • Product Id (SKU)

    • Customer (attribute1): customer ID/number

    • Price (attribute2)

  • PriceByCountry – Contains a price per product per country which is considered to be a list price of the product.

    • Product Id (SKU)

    • Country (attribute1)

    • Price (attribute2)

  • PriceByRegion – Contains a price per product per region which is considered to be a list price of the product.

    • Product Id (SKU)

    • Region (attribute1)

    • Price (attribute2)

  • PriceBySegment – Contains a price per product per segmentation which is considered to be a list price of the product.

    • Product Id (SKU)

    • Segment (attribute1)

    • Price (attribute2)

Components

  • Calculation Logics

    • CPQ – CPQ quoting logic

    • CPQ_SharedLib

    • CPQ_Publishing_Template_Data_Provider

    • CPQ_header – CPQ header logic

    • CPQ_header_discounts_configurator – Configurator logic for the discount type input

    • CPQ_CustomerFilter

    • CPQ_ProductFilter

    • HeaderInputs_Configurator

    • LineInputs_Configurator

    • CPQ_Output_Configuration_Wizard

    • CPQ_Output_Configuration_Wizard_Executor

  • Publishing Template

    • publishingTemplates_Q_CPQTemplate.docx

  • Message Template

    • Quote_approvalRequired_en.html

  • Workflow Formula

    • CPQ_Quote – Workflow formula based on the ApprovalWorkflow library, with the data map extended for the quote summary.

  • Quote Type

    • CPQ – Dedicated quote type for CPQ, with logic, header logic and workflow logic setup.