SAP BLOG Adding Additional Quantity Fields in Account Based CO-PA

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,426
Tepki puanı
7
Puanları
6
Learning Objective:

  • 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).​



Key Concept:

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.



Configuration:

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”

12-8.png




Step 1: Define Additional Quantity Fields

Customizing Path: Controlling • General Controlling • Additional Amounts• Define Additional Quantity Fields

11111.png


In the New Entries: Overview of Added Fields screen, you can select up to three additional quantities in the Additional Quantity Field column.

0001.png




-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.



BN.png


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.

2.1.png




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.

2.2.png


After activating BAdI, additional quantity fields become available in CO-PA reporting.

2.4.png




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.



Business Case:

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.

4.1.png




In material master, relationship is maintained between EA and KG.

4.2.png




When billing is posted, base UoM gets posted as billed quantity.

4.3.png




In addition to billed quantity (EA), additional quantity (KG) also get posted in CO-PA.

4.4.png




Conclusion:

Configuring additional quantity fields can be very useful in profitability reporting for industries (especially wholesale & distribution) where products are maintained in multiple UoMs.

Okumaya devam et...
 
Üst