07-12-2006 11:18 AM
hi,
i got one problem.
req is in vbak table one zfield there length is 3.
i have to change it 2.that field is country.
how can i change the length to 2 with affeting database table.ie is zfield added by append structure.
any one suggest me what r the possible ways to do that.
thanks&redards
suneetha.
07-12-2006 11:20 AM
If your zfield has been added using an .Append, you should see the field come up in a different colour (blue)in SE11. The .append structure name will be above it.
Changing the field length may require you to adjust the database during activation.
Sudha
Message was edited by: Sudha Mohan
07-12-2006 11:21 AM
if it is SAP standard field inside a SAP database, you will be needing an access key, and it is done through SE11.
If it is a Zfield in a Zdatabase then you can direclty go to SE11, change in se11 and save and activate.
(here it will give some warning --
saying that goto se14 and proceed.
hence, ignore this warning
then goto se14 and from there do the 'Activate and Adjust database'
07-12-2006 11:22 AM
Hello Rani,
The country key will always have length 3.
Eventhough if u want to change it to 2. Then Create a domain with length 2 and attach it to the dataelement.
Reward points.
Regards,
Vasanth
07-12-2006 11:22 AM
go to the append structure and alter the length of the field. and activate it.
You need to go to se14 to activate and adjust the database.
Regards,
Ravi
07-12-2006 11:27 AM
Hi Suneetha!
Maybe you just change the display length in the transaction and still use the standard 3 places for saving the country code. Then you are able to link the table T005 as check table, which gives the nice F4-help.
Regards,
Christian
07-12-2006 11:28 AM
Hi,
once you change the field length , you need to activate and Adjust the Database. But just take care of the program where the field is used.
Regards
vijay