topic Re: OData Bseg Loop in Application Development and Automation Discussions

OData Bseg Loop

umayaraj — Fri, 17 Jan 2020 09:57:02 GMT

Hi i have performance issue with BSEG table querying & loop with from and to .

actually i take all entries from BSEG then loop (with from & to) after i export info via odata.

is there any other way to increase performance,if you know please guide me how to solve this issue.

Re: OData Bseg Loop

FredericGirod — Fri, 17 Jan 2020 10:29:07 GMT

You could play with OPEN CURSOR if you want to send by block of data.

But I think, first, you have to give the full explanation of the goal. Why do you read BSEG ? You are not on S/4 ? Are you sure you nee the full BSEG ?

Re: OData Bseg Loop

umayaraj — Thu, 23 Jan 2020 12:41:25 GMT

Hi sorry for late reply,i try build some graph apps in ui5 that's why it need and i already i use open cursor in my fm,it's not get any run time error while access large amount of data but performance very slow .

Re: OData Bseg Loop

FredericGirod — Thu, 23 Jan 2020 15:12:31 GMT

If you are playing with UI5, did you check if you have a CDS view based on ACDOCA table with Odata service generated ? (I hope you are using S/4)