Skip to Content
0
Former Member
Apr 07, 2009 at 10:52 PM

how to create an extract program?

13 Views

Hi guys!,

-I'm trying to create a program to extract data from Customer Master tables.

-I need to join 7 tables with 64 fields in total.

-What is the better way to create the program? (Using FOR ALL ENTRIES statement?)

1. I'm thinking create 8 structures. (1 for each CM table and other for the final Internal table)

2. Then create 8 internal tables (1 for each CM table and other for the final Internal table), and using the FOR ALL ENTRIES statement for join them.

3. Then I'll create the Selects for populate the internal tables.

4. Final CALL FUNCTION = GUI_DOWNLOAD to download the data into a file.

But I don't know if it is the most efficient way, and I have doubts in step 2 and 3.