alter table is not possible

[Former Member]

hi!

i've made some changes for table vbap (with adding structure zavbap) and now some active log there:

"TABL VBAP is inconsistent in active version

Check table VBAP

Classification 3 possible, but include or subtype is still unclassified

Field ZZ207: Type change

ALTER TABLE is not possible

Structure change at field level (convert table VBAP)

Check on table VBAP resulted in errors"

what am i gona doing? Please help!

[Former Member]

hi!

i've made some changes for table vbap (with adding structure zavbap) and now some active log there:

"TABL VBAP is inconsistent in active version

Check table VBAP

Classification 3 possible, but include or subtype is still unclassified

Field ZZ207: Type change

ALTER TABLE is not possible

Structure change at field level (convert table VBAP)

Check on table VBAP resulted in errors"

what am i gona doing? Please help!

[RichHeilman]

Please try to adjust and activate using transaction SE14. Remember to select the radiobutton for "Save Data".

Regards,

Rich HEilman

[former_member480923]

Hi

try the following

a) See if all the fieldds in the include structure is activated properly or not.

b) Go to SE14 and press activate and adjust database.

Hope it helps

Anirban

[Former Member]

Hi Denis,

Try adjust the table by clicking on the Menu in transaction SE11 itself by Utilities --> Database Utility and click on the button Activate and adjust database and see if it works.

Thanks & Regards,

YJR.

Message was edited by: YJR

[former_member404244]

Hi denis,

U are adding some fields in VBAP ryt.So i guess u r adding the fields via append structure?,whcih is there on the application tool bar.

If u r not doing.Then create append structure example zstructure and add fields in it.

Now ur new fields will be seen in vbap table along with ur append structure zstructure.

then activate the table vbap.Also use database utility(se14),adjust the table vbap.

hoping this will help u.

Regards,

Nagaraj

[Manohar2u]

Denis,

Even after adjusting thru se14, if is an error in runtime object check, then use RSDDCHECK report to make it consistent.

Regds

Manohar

[Former Member]

i've use se14 already. problem not solved. may i use native sql statment - alter table vbap drop zfield ? what syntax of alter table drop then?

[Former Member]

Hi,

you need to Adjust the Table

from the Menu <b>Utilities ->Database utility -> Activate and Adjust the Database</b>

and then now come back and Activate your Table.

Regards

vijay

[Former Member]

anyway there errors. i want to try to use native sql statment and delete customer field on database level.

How can i do it's? alter table drop, isn't it?

[Manohar2u]

Did the data exists in the table? you can see form se14 t code.

Note that if you drop the table you may loose the data, hence first try to get the backup data to load the same.

You can delete & Create table from se14 aswell.

Regds

Manohar

[Former Member]

when i've check table vbap with se14 i've got message - "Database object for VBAP is inconsistent: (Fields)

Fields: Inconsistent with the runtime object". in detail some fields does not exist in database. What am i gona do?

[Former Member]

Denis,

1. Check the custom data elements/domains (if you have created any) are activated.

2. Check whether you need to mention any reference fields or reference tables for amount fields (if you have any)

3. Last but not least...check for any dependencies (key relationships...I dont think this is would cause the error)

Thanks,

[Former Member]

I wouldn't use native SQL to drop and recreate VBAP. This is a standard SAP table and you wouldn't want to have any differences between the data dictionary and the actual database.

Rob

[hymavathi_oruganti]

go to se14, (data base utilities)

and click on the push button "activate and adjust data base" keeping the radiobutton "save".

[Former Member]

i don't wish to lose data of vbap, but recreate table with se14 without deleting data is no possible. May i store data in local file, for example in .xls and next to adjust table without saving data with se14, and later to load data from local file into table vbap?

[Former Member]

Denis,

If you wish to do so then you can do it with some programming effort.

[Former Member]

i want to explain in detail my trouble why i've got inconsistent vbap.

i've tryed to extend vbap with append structrure with too many fields and in result database object 'vbap' and runtime object 'vbap' is inconsistent. it's like "exclusive circle". I can't to recreate table vbap with saving data and when i change append structure i can't generate append structure because vbap generating simultineously. how can i eliminate this incositensy without deleting data.

[Former Member]

As I said, this is a standard SAP table, you shouldn't be writing programs to alter or update it. I think you should go to OSS and explain the situation.

Rob