topic Re: adding some fields to ztable. in Application Development and Automation Discussions

adding some fields to ztable.

Former Member — Sat, 20 Feb 2010 06:03:35 GMT

Hi friends,

i want to add menge from mseg table and lbkum from mbew table into my ztable which has MANDT TEMPLATE ITEM PHASE

MATERIAL MFRNR these fields but at the appending it is giving error that Error in ALTER TABLE generation for table ZPSYS

can you please tell me how can i rectify this error?

Regards,

bikash

Re: adding some fields to ztable.

Former Member — Sat, 20 Feb 2010 09:06:27 GMT

Hi Bikash,

Try with adjusting the database table in the Database Utility in TCode se14.

Hope this helps you.

Cheers,

Murali Krishna T

Re: adding some fields to ztable.

Former Member — Sat, 20 Feb 2010 18:28:10 GMT

Hello Bikash,

I understand that you hadn't added the fields menge and lbkum when you were creating you ztable, so in order to able to transfer these values, you must redifine your ztable. You can do that by running transaction SE11, and adding the required fields.

Regards,

Manish.

Re: adding some fields to ztable.

Former Member — Sun, 21 Feb 2010 07:27:44 GMT

Hi Bikash,

Go to database Utility SE 14 and click on adjust table.

Also u can check before doing this that whether there is any data being maintained in your table if yes please delete all the firelds.

hope this helps.

Sumeet

Re: adding some fields to ztable.

Former Member — Sun, 21 Feb 2010 11:18:53 GMT

Hi in SE11 ,

Use menu as below.

UTILITY----

>DATABASE OBJECT......>DATBASE UTILITY......>ACITIVATE NAD ADJUST DATABSE.

then Click on YES

Press F3 and acivate your table.

Cheers,

Pravin

Re: adding some fields to ztable.

Former Member — Thu, 25 Feb 2010 09:16:01 GMT

Hello Bikash,

Use T-Code SE 14 to adjust your table. You have to perfrom this operation every time when you add or remove fields from your database table.

Please also give the reference field from quantity (menge) field.