2025 Apr 03 7:44 PM - edited 2025 Apr 04 11:17 AM
I've created an RAP APP ( on adt side ) to show an list report fiori app with option to navigate for detail ( also a list report ).
I neeed to have totals and subtotals so I put the anotaion @Aggregation.default: #SUM in the projection view.
When I preview the APP using Service bindiing preview option I've the totals:
When I go to details ( using associations ) I also have de totals:
After I deploy the APP using BAS I lost totals in the main view:
So I assumed that some limitation in BAS side. But if I go to the details ( in the deployed app ), I have the totals:
Since I have parameters, I'm using oDataV2 protocol.
I saw in Browser that the request that doesn't have totals have in the select all fieds, like:
GET ZC_COMPT_MAIN(p_date_from=datetime%272015-03-26T00%3a00%3a00%27,p_date_to=datetime%272025-04-04T00%3a00%3a00%27)/Results?sap-client=100&$select=Supplier,VATRegistration,tipoproc,SumAmountInCompanyCodeCurrency,DispCodeCurrency,SumTaxBaseAmountInCoCodeCrcy,SumTaxAmountInCoCodeCrcy,SumNetAmount,SumPurchaseRequisitionPrice,computo,ID&$filter=((((CompanyCode%20eq%20%27I001%27))%20and%20((Supplier%20eq%20%272018%27))))&$orderby=Supplier%20asc&$top=120&$inlinecount=allpages HTTP/1.1
The request that has totals, just select the fields with values:
GET ZC_COMPT_MAIN(p_date_from=datetime%272015-03-26T00%3a00%3a00%27,p_date_to=datetime%272025-04-04T00%3a00%3a00%27)/Results?sap-client=100&$select=SumAmountInCompanyCodeCurrency,DispCodeCurrency,SumTaxBaseAmountInCoCodeCrcy,SumTaxAmountInCoCodeCrcy,SumNetAmount,SumPurchaseRequisitionPrice,computo&$filter=((((CompanyCode%20eq%20%27I001%27))%20and%20((Supplier%20eq%20%272018%27))))&$top=100&$inlinecount=allpages HTTP/1.1
Can you please help me identifying what could be the problem? Is there an option to afect the OData request ? Thanks
Request clarification before answering.
I found that, in the BAS I should use Analitical Table instead of responsive table. I changed this option and deploy the app again and the totals appers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.