adding some fields to ztable.

[Former Member]

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

[Former Member]

Hi Bikash,

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

Hope this helps you.

Cheers,

Murali Krishna T

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.