Hi,
I am trying to understand the Feasibility of this Requirements solution from SAP WebDynpro Java perspective.
Requirements-
1) Design a SAP WebDynpro Java screen. On click of upload button read an Excel sheet which contains Part no1 & Part no2 records. In an excel sheet there is 6,000 records.
2) Whenever a record is read from the Excel it will search the unique combination of Part no1 & Part no2 in the database (in this case SAP MDM Data Manger). The database contains 7,00,000 records which is not indexed/ sorted..
3) 6000 times (excel sheet records) step 2 is repeated
4) For each record the output can be zero, one or more records. The output need to be displayed/ generated in Excel sheet
5) Concurrently this functionality is used by 5 users.
Question-
a) Do this requirement can be achieved using SAP WebDynpro Java ? If yes, then from performance perspective how much time it take to upload the excel sheet & create a new Excel sheet functionality?
b) If No, then why ?
I am trying to understand whether this requirement is Feasible (Y/ N) with valid reasons?
Any valid inputs will be highly appreciated!
Thanks,
Kumar