UI5 List report application with header and items using odata service with expandedentityset

[venu_001]

Hi Experts,

I have requirement to display UI5 List report with header and items, i have searched all blogs but i did not get suitable solution.

i have created odata service with associations and navigations with deep structure, i am not able map to UI5 list report to consume odata service, kindly help with step by step process

List output should in below format

header1 Name1 Date1 Total price1 Total Qty2

...item1 .....unitprice1 ....qty1 ....prctr1 ....slg1

....item2 .....unitprice2 ...qty2 .....prctr2 ...slg2

header2 Name2 Date2 Total price2 Total Qty2

...item11 ...unitprice1 ....qty1 .....prctr1 ....slg1

....item2 ....unitprice2 ...qty2 ......prctr2 ....slg2

Thanks in advance,

[maheshpalavalli]

You mean to say that you want to show the items and header directly when you run the list report application without click on the item in the worklist and navigating to the object page?

[maheshpalavalli · Accepted solution]

Hi venugopalreddy sagamredi,

Yes correct, We cannot show header and items at the same time. We need to show headers in the worklist and on click of the header in the worklist page it will navigate to object page where we can show the items.

There are couple of blogs and answers for your quesiton. You have to use the UI annotation for this.

https://blogs.sap.com/2018/06/08/sap-fiori-element-list-report-for-beginners/

You need to use UI.SelectionFields annotations for this.

To make the filter as drop down instead of F4 help, you need to use

https://help.sap.com/doc/saphelp_nw751abap/7.51.0/en-US/2a/0a630e50c7472b803fb94dab922d18/frameset.h...

you can explore the Ui annotations in the annotation modeler for more information.

BR,
Mahesh

[venu_001 · Accepted solution]

Hi Mahesh,

I am struck up with issue date format, i have date in odata with for format Edm.DateTime in UI it shows date and time together, for our requirement we need only to show date. is there any option to display date only? i am using smart template list report and local annotations.

Thanks,

Venu.

[maheshpalavalli · Accepted solution]

Hi Venu,

You can find some already answered questions regarding your issue in google

https://answers.sap.com/questions/705464/date-format-in-fiori-elements-list-report-using-lo.html

For new issues create a new question and close this one.

BR,

Mahesh

[venu_001]

Hi Mahesh,

I am able to find out the issue, i missed out to mention both fields in properties. thanks for help.

[maheshpalavalli]

You are most welcome.

PS: You can click on the comment and reply. No need to reply as an answer.

You can also close this question if it is answered.

https://blogs.sap.com/2013/04/03/how-to-close-a-discussion-and-why/

BR,

Mahesh

[venu_001]

Hi Mahesh,

Thanks for reply, I tried to find the way to display header and items together but i couldn't. finally items are getting displayed on object page.

I have struck with two more issues.

1. Display filters on filter bar when application launched and default to fixed value? currently i have to click on adopt filter button from application to select filter fields.

2. One filter field needs range input and F4 help

I am not using CDS view but using odata service to extract data and local annotations are defined in web ide.

Kindly help.

Thanks.