how to create an extract program?

[Former Member]

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.

[former_member156446]

these steps looks ok , but depends on how you join... use all the indexes that available and write select statements for all entries in fine.

Check if you can find a BAPI which will get you all the info for the CM..and call that BAPI that would be more easier and simpler

[Former Member]

This is one of my doubts. How to join more than 2 tables with the FOR ALL ENTRIES?

Edited by: Rafael Lopez on Apr 8, 2009 2:54 AM

[former_member156446]

You should read this :

[babu_kilari4]

Rafeal,

Go to SE38 editor and press F1 on FOR ALL ENTRIES, you will get wonderful explanation on how to use it.

Alternatively, you can search SDN Forums always for these kind of basic questions.

Thanks,

Babu Kilari

[dhirendra_pandit]

I think for all enries degrades the performance for your program.

so please avoid to use it.