topic Re: Suggestion for development. in Application Development and Automation Discussions

Suggestion for development.

ronaldo_aparecido — Tue, 18 Jun 2013 16:04:45 GMT

Hello everybody.

I need a suggestion for development.

I have an excel file with many columns and filters.

In this file there are 4 columns, the first has the old data and the new data in the next.

I need to select all tables in sap with the old company code and select in excel this code and replace with the new code that is in the excel file modifying tables.

What would you suggest for good performance?

Thanks.

Re: Suggestion for development.

Former Member — Tue, 18 Jun 2013 17:30:26 GMT

Hi Ronaldo,

This is what i understand of your requirement.

You have an excel file whose first two columns have company code data, Specifically

Column 1 has Old Company Codes and Column 2 has new ones.

Now you need to replace the old company codes with new ones in your Z tables.

Solution -

1) Read the Excel using FM ALSM_EXCEL_TO_INTERNAL_TABLE

2) Create an internal table with all the old company codes and new company codes.

3) Say you have 5 Z tables to be modified, Select the data of these 5 tables into internal table of corresponding types doing a For All Entries on the internal table of step 2 with company code field.

4) Loop at the individual Internal tables of the Z tables using a field symbol/work area.

5) Inside Loop , read the internal table of step 2 to know what value of new company code should replace the old company code value.

6) If read is successful , then modify the values in the work area/field symbol.

7) Append the changed values to new internal table if using a work area. If using a field symbol skip this step.

😎 Update Your Z table from the Internal table of Step 7.

Ask further if not clear.

BR.

Re: Suggestion for development.

FredericGirod — Tue, 18 Jun 2013 18:03:06 GMT

Hi Ronaldo,

the "All tables in SAP" afraid me, really.

First of all, I hope the new company code never have been used, if "yes", forgot that, find another job

if I never have been used, you could start with the DD03L table (I'm not sure) to find all the field of the table that used the data element BUKRS (but, for me, that's not enough)

If it's only 5 specific tables you could make like explain Ankit : http://scn.sap.com/message/14135570#14135570

good luck

Fred

Re: Suggestion for development.

ronaldo_aparecido — Tue, 18 Jun 2013 18:32:59 GMT

ALSM_EXCEL_TO_INTERNAL_TABLE dont exist in my version

Re: Suggestion for development.

ronaldo_aparecido — Tue, 18 Jun 2013 22:25:09 GMT

OK i copy from other environment the function and worked but how make the function return blank fields?Is any parameter?

Re: Suggestion for development.

ronaldo_aparecido — Wed, 19 Jun 2013 00:00:36 GMT

OK isee in other post and worked now .all is worked thanks guys.

Thanks.