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.
Cloud Price and Tax Team