Profit Center Derivation in Sales Documents
Hi everyone, I am a Sales consultant for SAP S/4HANA Cloud, public edition. I would like to introduce one of the useful new features of 2308.
As of 2302, profit centers should be derived from Material master with a key combination of Material code and Plant code. However, required profit center structures may be often complex and derivation from Material master could not cover business requirements. From the 2308, you can derive profit centers with various key fields, such as product groups, customer groups, sales regions, or distribution channels with using the app Manage Substitution / Validation Rules – Journal Entries. Additionally, this implementation is possible without ABAP coding.
Before you implement the Profit Center Derivation, you need to check the profit center determination access sequence described in the following link for the Help Portal page:
Profit Center Determination in Sales Documents
Example of Business Requirement
A customer defines profit centers for different geographical areas belonging to different segments.. Therefore, profit centers can be derived in accordance with Sales Districts.in sales orders.
|Segment||Profit center||Sales district||Description|
Steps to set up Profit Center Derivation
- Access the app Manage Substitution / Validation Rules – Journal Entries with the role SAP_BR_BPC_EXPERT.
- Click on “Create Rule” then pop-up appears
- Select “Profit Center Derivation in Sales Documents” for the field Business Context
- The field Event is automatically fulfilled with “Sell from Stock and Advanced Intercompany Sales”. Otherwise, you need to select the event.
- Close the pop-up with clicking on “Create” .
- New Substitution area appears. Fulfill Rule Name and Description
- Set up Precondition.- refer to the section Setting up Substitution: Alternative 1 & 2
- Set up Substitution.- refer to the section Setting up Substitution: Alternative 1 & 2
- Click on “Save”
- Click on “Activate”
The app is commonly used in Sales Accounting. For further information refer to the following Help Portal link:
Manage Substitution/Validation Rules
Setting up Substitution: Alternative 1
In order to realize the example of business requirement, simpler way is this alternative 1 which creates the logic for profit center determination on the app. However, it has lower flexibility. If you usually use derivation from material master and you have some specific case you need to overwrite a profit center derived from material master. This could be nice option.
You can use any field in the CDS view: I_SLSDOCPROFITCENTERDERIVATION for the Field/Function. Additionally you can use functions such as CONCATENATE(), SUBSTRING() and getWBSInternalId() which is the function to map WBS external ID to WBS internal ID. You have many choices for the Operator such as Equal To, Greater Than, Between and etc,.
You can only select ProfitCenter for the Target Field and other fields are not shown in the selection screen.
Available Substitution Types are following:
Substitution with Constant
Substitution with Field / Function
In order to realize the case of example, choose “Substitution with Constant” and fulfill Source with target value of profit center.
The checkbox Overwrite should be checked if you have a profit center derived from material master.
Setting up Substitution: Alternative 2
When you return to the main screen, you need to check the checkbox: Overwrite, if you want to overwrite the profit center input from other method.
Click on Save.
This substitution enables SAP customers to be more flexible in defining profit centers and defining plants.
I hope you find this blog helpful.
I also appreciate your questions and your feedback.