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

after modifiying the Z Table - It is not getting activated

hi Experts.

I am facing a problem after updating the table.

I hv changed one field from INT4 to DEC.

While activating, it shows the msg : Structure change at field level (convert table ZSIILPM001)

The structure of the table changed at field level. This change requires

a conversion of the table. This situation can occur for example if the

data type or field length of the domain upon which the field is based

was changed. A conversion is also generally necessary if the key of the

table changed.

Convert the table using the Database Utility (SE14).

In transaction SE14, while m adjusting the table, then It also shows the msg that : table is inconsistance, correct thr' SE11.

Inconsistencies between the database object and the runtime object of

the table were found when you checked the database object for the table

to be converted. You therefore cannot correctly access the database

table. You cannot convert the table in this status.

Using Transaction SE11 (Extras->Database object-> Check) determine the

type of inconsistency and correct it. Then activate the table again and

execute the conversion.

hw can i resolve this problem???

Regards,

Jimit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2009 at 05:02 AM

    Hi,

    Have you modified the table with data in it ? ... if so then that's why you have encountered the error

    what you can do is ... goto SE14 and then activate the table....

    Regards,

    Premal

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI...

      I hv tried to activate using SE14, But in SE14 i m getting Tabel incosistant.

      It's giving some problem like,

      Runtime object and Database objects are not matching.

      e.g.

      I go to : utilities > Database Objects > check.

      I m getting following inconsistancies

      Fields: Inconsistent with the runtime object

      Runtime Object Database Position Data Type Length Decimals Not null Default

      LTHTA 26 NUMBER 10 X 0

      LTHTA 3 ( <----


      Red colored )

      I have converted

      LTHTA form INT4 (length 10) to

      LTHTA DEC (lenght 10 with decimals 3 )

      regards,

      JImit

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2009 at 05:04 AM

    hai form se14 use the option activate and adjust database option

    and ur table will be activated

    as u changed in dictinonary it shoud also reflect in database

    just use tha toption

    m.a

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2009 at 05:04 AM

    Hi,

    The table might have some entries and as u change the data type of field some of entries might got null.

    Try to pass simple dot or some value to those entries and then activate it.

    Regards,

    Deepak.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2009 at 05:13 AM

    HI...

    I hv tried to activate using SE14, But in SE14 i m getting Tabel incosistant.

    It's giving some problem like,

    Runtime object and Database objects are not matching.

    e.g.

    I go to : utilities > Database Objects > check.

    I m getting following inconsistancies

    Fields: Inconsistent with the runtime object

    Runtime Object Database Position Data Type Length Decimals Not null Default

    LTHTA 26 NUMBER 10 X 0

    LTHTA 3 ( <----


    Red colored )

    regards,

    Jimit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2009 at 05:15 AM

    I have converted

    LTHTA form INT4 (length 10) to

    LTHTA DEC (lenght 10 with decimals 3 )

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 15, 2010 at 07:58 AM

    se14 finally solved the issue

    thanks,

    Jimit Vadher

    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.