Symptom
- The quantity is duplicated in the 'Product and Service Margins' Custom Report.
- There is no quantity field in app 'Product and Service Margins'.
Environment
SAP S/4HANA Cloud Public Edition
Cause
This is a technical issue related to limitations; margin analysis reporting is calculated based on semantic tags.
Resolution
When there are multiple semantic tags, it leads to duplicate quantities.
Hence, the field quantities in not available in the standard APP W0164 - 'Product and Service Margins'.
In case the quantities field is needed, it is suggested to use the conditional case "when SemanticTag = 'BILL_REV' then ValuationQuantity" to display non-duplicate quantities.
Keywords
Product and Service Margins, W0164, quantity, duplicated quantity , KBA , CO-FIO-PA-2CL , Margin Analysis (Public Cloud) , Problem