Pricing on Identifier Fields: extension fields of type Identifiers cannot be added in ByD : Possible Solution/workaround via Studio

SAP Business by Design is often contacted by Partners , to enable pricing for Identifier fields . one of the scenario is explained below:

Scenario / Customer Usecase:     

              Customer want to determine price / discount based on “Ship To Party” (field of type Identifier) in Transactional document (Sales Order , Service Order, Invoice …)

Example: In Invoice Request based on Account (Ship To Party) ID – MC9785 , the price / discount is determined from relevant Price / Discount List

Price Determined in Invoice request , based on Ship To Party – MC9785

Restriction with Standard ByD Solution to support above customer scenario:

    pricing cannot be done in ByD for Standard Fields of type Identifiers ( Ship To Party, other master data Identifiers ) , which are not part of standard SAP delivered field catalogue . and extension fields of type Identifiers cannot be added in ByD.

Solution Proposed: for adding Price relevant extension fields of type identifiers.

Steps 1: Add Extension field into customer invoice request

Step 2: Create custom extension scenario: To
push extension field from “Customer Invoice Request” -> “Price List” , For
details refer to Help Center Documentation “Pricing with Extension Fields”

Step 3: Add the Extension field to Custom Extension Scenario.

Step 4: Copy “Ship To Party” data from standard field to ->  Ship To Extension field.

Step 5:  Create Custom Price List meta data using Business Configuration :

For details refer to Help Center Documentation “Pricing with Extension Fields”

Step 6:  Create Custom Price List master data in “Product and Service Portfolio” Work Center

Step 7: Create Transactional data referring to above master data , then prices determined / picked from custom price list.

For more details refer to attached solution snapshots.

Regards

Cloud Price and Tax Team