Q

Changing key fields in transparent tables

We had a custom transparent table with a lot of data in it. Recently we needed one of the keys to be expanded. And the key is in the first field of the table. I want to know it won't impact the data after I change it. What's the steps to do it? What should I be careful for? I will appreciate your time.

We had a custom transparent table with a lot of data in it. Recently we needed one of the keys to be expanded. And the key is in the first field of the table. I want to know it won't impact the data after I change it. What's the steps to do it? What should I be careful for? I will appreciate your time.


You change the key field in SE11. When you generate the table, you'll be prompted to adjust the table in the database (this is the same as transaction SE14). For making a key larger, say from NUMC1 to NUMC2, this adjustment ensures the integrity of your data.

However, in cases like this, where there is a lot of data, I'd suggest making a copy of your table, without data, in your development instance. Add a few representative records, then change the key field, and adjust the table. Check the conversion has worked.


This was first published in October 2001

Dig deeper on SAP ABAP

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close