10-30-2019 5:00 AM
Hello Everyone,
I am pulling 100 crore records from my HANA DB using AMDP method but my internal table in the report where the AMDP method is called is not capable of handling huge data . how to overcome this scenario?
Thanks,
bala Krishna T,
9176208032
10-30-2019 6:18 AM
I think there are 2 options for tackling this scenario :
1. Consult your Basis Consultant whether Memory can be increased to handle this big number of records or not.
2. Try to chunk the data pulling by applying more filters.
As an example in one my previous Client's we had an AMDP Method which pulled whole Customer Master records and the program was to be run in background mode. Later we tuned it in such a way that we added Customer Group as one of the filter condition and we scheduled jobs for this program Customer Group wise. So it distributed the execution process.
Like this you also need to come up with some work around for gettng through this challenge.
Thanks,
Sijin