Skip to Content
author's profile photo Former Member
Former Member

Update values for additional (new) keyfield in database table

Hi All,

Here in our firm we have a Z table with data in it. As part of the new requirement I had to add a new key field in it.

Now I have to maintain values for these key fields in the already existing data.

I cannot maintain it though SM30 as the maintenance view grays that field in SM30.

Is there any way of updating this new key field data in database.

Thanks,

Kajal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2008 at 09:06 PM

    You should be able to do this through an ABAP update program. It may depend on your database though, to change key fields.

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2008 at 09:07 PM

    You can write a custom program with an Update query on the table.

    Regards,

    Sudhir Atluru

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 07:00 PM

    This question is unanswered till the UPDATE statement is succesfull.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.