after modifiying the Z Table - It is not getting activated

[Former Member]

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

[premal_mistry2]

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

[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

[Former Member]

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

[Former Member]

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.

[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 )

regards,

Jimit

[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

[premal_mistry2]

Hi,

Goto SE14, enter you Z-Table and then click on EDIT. On the next screen click on Activate and Adjust Database. This will solve your problem. I myself have tried this and it is working fine.

[Former Member]

I have converted

LTHTA form INT4 (length 10) to

LTHTA DEC (lenght 10 with decimals 3 )

[Former Member]

se14 finally solved the issue

thanks,

Jimit Vadher