Maximum number of ROW capacity in WDJ Table

[Former Member]

Hi Experts,

Looks for advice and guidance in WebDynpro Java Table.

We have a requirement, where-in we have to fetch record from ECC (which is around 2 Lacs).

So could you please advice if WDJ Table UI element can hold 2 lacs record in runtime and disply it to the user?

What is the maximum row limitaion at present for it.

I am using Portal 7.3 server for app developments.

Thanks & Regards,

Pankaj

[Sharathmg · Accepted solution]

Pankaj,

Apart from the technical feasibility, if would never be desirable to show such a huge amount of data to be shown on portal.

The performance will definitely be poor.

Negotiate with the customer to split the data and probably give the complete data in an excel.

Note: Even an excel will 2 lakh records takes time to open. SO, imagine the impact on WD view.

Regards,

Sharath

[Sharathmg · Accepted solution]

In my opinion, rows in a table are linked to the elements in the context node bound to the table.

You can explore if there is any such limit on number of elements that a context node can hold.

Pagination in a table can handled easily by restricting the number of rows visible(property) of the table.

Regards,

Sharath

[former_member219975]

Hi Pankaj,

Just follow the below steps,

1. Take one "int" variable.

2. Assigned total number of records to it.

3. Take this int variable in one integer type content attribute.

4. Assign this context attribute to table property named as "Visible Row Count".

I am sure, you will get it resolved.

Regards,

Bhavin Anajwala

[junwu]

buddy, what's is for? are you dreaming?

[Former Member]

Hi Guys,

Could anyone of you have an idea of maximum number of row weddynpro java Table can hold at runtime?

I have read a thread where they say about 30000 row can be hold easily. http://scn.sap.com/thread/1712462

But i am looking for the maximum number of row limit, as i have to display around 2 lac record in table and then export it in excel sheet.

Please provide your precious input.

Thanks & Regards,

Pankaj

[junwu]

as long as you have enough memory in your server you can do it. wdj won't limit you.

if not enough memory, you have to use pagination.

[Former Member]

Hi Jun,

Thanks for your inputs. I was checking for the paging concepts and found below link, which say its applies to Web Dynpro Java, SAP NetWeaver 04, 7.0, 7.01, CE 7.10, CE 7.11 EhP1.

URL:-   http://scn.sap.com/docs/DOC-2702

Currently I am using 7.3 CE portal version, so i am not sure if the above can be apply here. Do you have an idea of it?

Regards,

Pankaj

[junwu]

i believe it is also applicable to 7.3