Symptom
APP Project Profitability only shows value in company code currency.
Another currency type other than company code currency is needed as per using requirement.
Environment
SAP S/4HANA Cloud Public Edition
Cause
APP 'Project Profitability' can only supports company code currency,
Resolution
As a workaround, create a custom query to add the additional measures based on I_GLAccountLineItemSemTag.
Following steps in Extending/Creating Queries with New Semantic Tags
Step 4. On the New Query Field panel, make the following required changes:
- In Measures, select the relevant measure, such as Amount in CC Crcy (AmountInCompanyCodeCurrency).
- In the Fixed Values section, choose Add Restriction and select Semantic Tag as the dimension that will appear in Fixed Value For. Add "= <your new semantic tag>" as an Include filter. Note that you also need to remove the default restriction.
In this way, the new field is created. By default, it sums up all amounts of the FS items or G/L accounts that are assigned with your new semantic tag.
For example, adding 'Object currency' for measure 'Billed Revenue', see below screenshot for more information.
Choose measures 'Amount in Object Currency', define Fixed value for 'Semantic Tag' = 'BILL_REV'.
Besides, always remember to remove 'Account Assignment' field as it's the default one when creating new measures.
Keywords
Project Profitability, Semantic Tags, currency, object currency, global currency, company code currency. , KBA , CO-FIO-PA-2CL , Profitability Management (Public Cloud) , Problem