Skip to Content
0
Former Member
Aug 02, 2016 at 11:09 PM

Calc view using sql script question

30 Views

Hi All

I need to get report output using 2 tables based on left outer join. Report prompts/parameters are based on left table which is table 1,

Table 1: Around 50 million records, but for given user selection we get around 100 or 200 records for single date.

Table 2: Around 50 million records.(No parameters from user selection)

Issue: Did couple of options using calc view based on graphical view / sql script using left outer join but below is the problem.

From table 1 it fetched 100 records in this example.Invoice date for single day. (Invoice date is not in table 2)

From table 2 it is fetching all 50 million into memory, then eliminating all records using table 1 join. (Simple join PO#/Item for both tables)

Question: Is there any way to avoid 50 million records into memory ? Just fetch only required 100 or 200 records based on table 1 PO#/Item

Generally in ABAP we use for all entries of first table output and then get only required records from table 2 based on table 1 join condition.

Thanks

Raghu