Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Custom Tables

0 Kudos

Hi Group,

I have requirement of receiving 1 million records in to SAP daily through interface we are planning to use custom table for storing this data, can any body suggest if there is any performance issues if we store 1 million records/day in to custom tables.


Former Member
0 Kudos

Hi Rajiv,

In the Technical Settings of table creation give the  value 9 for the size category.

Then the memory will get extended dynamically with the same amount if it is completely filled.

Let me know if any clarification/help required.

Thanks & Best Regards.

Pavan Neerukonda.

Active Contributor
0 Kudos

Hi Rajiv,

there are many possible performance issues.

You need a fast table input program. Don't forget  to call fm 'DB_COMMIT' for releasing system lock table entries many times.

You need large drive space and a huge SAP tablespace where your database table is located.

Any SELECT requests on this table will slow down every day. Therefore you will need several matching secondary indexes for fast acess to the requested data.

It sounds like a great quest.