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