SAP Knowledge Base Article - Public

3616085 - Calculation of COGS fixed amounts in app Product Profitability Review Booklet (F8348)

Symptom

In 2508, new booklet app is delivered – Product Profitability Review Booklet (F8348).

The booklet will be the successor for the app Product Profitability with Production Variances (W0182).

Both apps contain the product margin view. However, the amounts of COGS fixed might have minor differences in these two apps if the UCB is active.

Environment

SAP S/4HANA Cloud Public Edition

Resolution

Calculation Approach of the COGS Fixed Amounts

App Product Profitability with Production Variances (W0182)
In the past, although there can be situations where the fixed/variable split ratio can differ per currency.
We persist the fixed amounts only in one currency, which is the global currency, in Journal Entry Item. 
Journal Entry Item Table
Item      Amount in CC Currency            Amount in Global Crcy                              Fixed Amount in Global Crcy
1             100                                                        120                                                                        24

We can only simulate the fixed amount in other currencies base on fixed amount in global currency, like below:

COGS Fixed Amount in CC Currency = Amount in CC Currency * (Fixed Amount in Global Crcy / Amount in Globa Crcy)

In above example, COGS Fixed Amount in CC Currency = 100 * (24 / 120) = 20

-------------------------------------------------------------------------------------------------------------

App Product Profitability Review Booklet (F8348)

With UCB based cost breakdown, we persist the fixed amount per currency in the cost breakdown components behind the journal entry item.
Cost Component            Amount in CC Currency              Fixed Amount in CC Crcy            Amount in Global Crcy                 Fixed Amount in Global Crcy
1                                             40                                                           6                                                             48                                                           8
2                                             60                                                           12                                                           72                                                           16
Sum                                      100                                                        18                                                           120                                                        24
Now we can calculate the COGS fixed amount more accurately based on the persisted fixed/variable split values in the breakdown table.
COGS Fixed Amount in CC Currency = sum(Cost Component Fixed Amount in CC Crcy)

Keywords

COGS, fixed amount, W0182, F8348, Product Profitability, Product Profitability , KBA , CO-PA-IS-2CL , Information System (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions