/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
Some functionalities / aspects of the query are not migrated automatically . Corresponding manual steps have to be performed to achieve the same results in the new projection view.
After following the migration process described in 3603185 - Migration of Queries to Projection Views - Custom Analytical Queries and Services - SAP S/4HANA Cloud Public Edition 2508 - SAP for Me, here you can check the most common rework tasks after migration.
Note:
Environment
SAP S/4HANA Cloud Public Edition 2508
Resolution
1. Dimension Format feature for dimensions will not be migrated. Please maintain values in CAQS (Custom Analytical Queries and Services) App.
2. Below changes required for migrating calculated measure:
- The function CURR_TO_DECFLOAT_AMOUNT converts a currency field of data type CURR into a currency field of data type DECFLOAT34
- Use this function if there is a measure of type curr is used in expression.
- If a literal is used anywhere in the expression, it should be written as:
- DECFLOAT34|<number>|
- Result Type should be selected based on the result of the expression.
Examples:
-
- Expression: CURR_TO_DECFLOAT_AMOUNT (<measure of type curr>) * DECFLOAT34| 32 | , then result type must be “Amount”.
- Expression: <measure of type Quan> * 100, the result type must be Quantity.
3. In Parameter, default value for user input filter will not be migrated. Please maintain values in the CAQS app.
4. If there is a field of type curr added in field selection, then its reference field must also be added. Example: If there is a field amount, then reference field currency must be added.
See Also
Custom Analytical Queries | SAP Help Portal
Keywords
KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Product Enhancement
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)