Adding Additional Quantity Fields in Account Based CO-PA
- Define Additional Quantity Field in Account-based COPA
- Implement the logic to fill additional Quantity fields through BAdI (FCO_COEP_QUANTITY)
- Display Additional Quantity in COPA/Margin Analysis reports (KE24N).
SAP S/4HANA Finance allows the transfer of up to three different units of measure to account-based Profitability Analysis, which can then be used in Reporting, Top-Distribution, and CO-PA Assessment cycle.
For example, in the chemical industry, it is common to report quantity not just in the Base UoM (i.e. DR/EA) but also in the base unit of measure that is common across all product lines (KG/L). By defining additional quantity fields, both UoM can be displayed & used in Account-Based CO-PA.
There are two configurational steps involved in configuring alternative UoM:
- Define Additional Quantity Fields
- Write derivation to fill Additional Quantity fields through “BAdI: Interface for Additional Quantities”
Step 1: Define Additional Quantity Fields
Customizing Path: Controlling • General Controlling • Additional Amounts• Define Additional Quantity Fields
In the New Entries: Overview of Added Fields screen, you can select up to three additional quantities in the Additional Quantity Field column.
-In the COAr (controlling area) column, you maintain the Controlling Area.
-In the Dimension column, you can enter a dimension for the additional quantity field.
-In the Std. UoM (standard unit of measure), you maintain the additional unit of measure in which the quantity field is supposed to be stored.
For our example, we have defined “KG” as additional UoM with dimension “Mass”.
Step 2: Write derivation to fill Additional Quantity fields through “BAdI: Interface for Additional Quantities”
Customizing Path: Controlling • General Controlling • Additional Amounts• BAdI: Interface for Additional Quantities
To maintain the BAdI, you require a developer key and programming know-how. Usually, this step is completed by technical resource.
In this step, logic is written to derive and populate additional UoM.
In our example, we have written logic that base UoM (EA) must be converted into additional UoM with relationship maintained in material master and then transferred to additional UoM field.
BAdI must be activated after writing logic.
After activating BAdI, additional quantity fields become available in CO-PA reporting.
In some cases, an additional quantity field might not get appeared in CO-PA reporting. By implementing SAP note 3069579, this issue can be resolved.
For our example, we are using material (1400000351) with base UoM “EA”. It is also reported in alternative UoM that is “KG”. A relationship is maintained in material master between EA and KG i.e. 1 EA=25 KG.
For Material 1400000035, base UoM “EA” is maintained.
In material master, relationship is maintained between EA and KG.
When billing is posted, base UoM gets posted as billed quantity.
In addition to billed quantity (EA), additional quantity (KG) also get posted in CO-PA.
Configuring additional quantity fields can be very useful in profitability reporting for industries (especially wholesale & distribution) where products are maintained in multiple UoMs.