topic Re: how to create an extract program? in Application Development and Automation Discussions

how to create an extract program?

Former Member — Tue, 07 Apr 2009 22:52:00 GMT

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 — Wed, 08 Apr 2009 00:01:12 GMT

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 — Wed, 08 Apr 2009 00:54:00 GMT

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 — Wed, 08 Apr 2009 01:35:04 GMT

You should read this :

Former Member — Wed, 08 Apr 2009 04:03:36 GMT

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 — Thu, 09 Apr 2009 13:02:48 GMT

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

so please avoid to use it.