Database activation

[Former Member]

Hi,

I am changing field datatype and length (i,e..QUAN len 4 ) to char 4.After changing i am activating the table .But while activating the table i am not able to activate the table.Please help in resolving this....

Regards.

Sridhar . A

[shadab_maldar]

Hi Sridhar,

Goto SE14 -> activate and adjust the database table with the radio button on save data.

Regards,

Shadab.

[shadab_maldar]

And also you can press continue adjustment which is showing in your second screen shot.

But what is the requirement to change the data type of a standard table.? I think it is not advisable to change the data type, because of this many standard transaction may go  dump.

Regards,

Shadab.

[Former Member]

Hi Shadab,

I had press continue adjustment but it is throwing dump.

WBS_ELEMENT	PS_POSID	CHAR	24
.INCLUDE	CI_PRPS	0
ZGROUP	KOSTL	CHAR	10
ZSKILL	CHAR40	CHAR	40
PO_ITEM	NUMC3	NUMC	3
ZDATE1	ZDATE1	DATS	8
ZDATE2	ZDATE2	DATS	8
ZDATE3	ZDATE3	DATS	8
ZDATE4	ZDATE4	DATS	8
ZDATE5	ZDATE5	DATS	8
ZFTA	CHAR40	CHAR	40
ZDATE6	ZDATE6	DATS	8
ZCOMP	ZCOMP	CHAR	20
ZCOUNTRY	ZCOUNTRY	CHAR	50
ZPROJTYPE	ZPROJTYPE	CHAR	20
ZPROJTYPE2	ZPROJTYPE2	CHAR	20
ZPROJLEVEL	ZPROJLEVEL	NUMC	2
ZPROJGRP	ZPROJGRP	CHAR	50
ZNATURE	ZNATURE	CHAR	20
ZPROJTYPE3	ZPROJTYPE3	CHAR	40
ZCONRATE	ZCONRATE	QUAN	4
ZPROJTYPE4	ZPROJTYPE4	CHAR	10
ZIPO	ZIPO	CHAR	10
ZCUSTGRP	ZCUSTGRP	CHAR	50
ZREVCOUNTRY	ZREVCOUNTRY	CHAR	30
ZREVREGION	ZREVREGION	CHAR	50
ZSOURCE	ZSOURCE	CHAR	8
ZLOCATION	ZLOC1	CHAR	12
CUSTOMER_ID	ZCUSTOMER_ID	CHAR	10
CUSTOMER_DEC	ZCUSTOMER_DEC	CHAR	40
CUSTOMER_GRP	ZCUSTOMER_GRP	CHAR	4
CUSTOMER_GRPDEC	ZCUSTOMER_GRPDEC	CHAR	20
CUSTOMER_GEO	ZCUSTOMER_GEO	CHAR	10

I need to change the zconrate field as Bapi_extensionin structure cannot accept QUAN so i had changed it to as char 4.

Regards.

Sridhar. A

[RaymondGiuseppi]

I'm not sure many database will accept conversion from packed (QUAN) to CHAR and in any case shouldn't CHAR field be at least twice longer than original QUAN, so CHAR 8?

-> Check log (SM21) and dumps (ST22) in your system for more information.

If incrementing CHAR field length is ok, return, else:

You could try to first add a new field, and build a small report to map data to new field (add the report to transport request as a R3TR XPRA so it will be executed during import, also in this report use CLIENT SPECIFIED option in SELECT/UPDATE statement, as import will run in client 000)

If you want to keep the original name, you may require more transport requests

• create new ZZfield and copy Zfield values to ZZfield thru XPRA report
• delete Zfield
• create Zfield with new definition and copy ZZfield values to resurrected Zfield thru XPRA report
• delete ZZfield

Beware : Insure not to transport two requests together (do you guess what will happen ?)

Question: Are there already data in production in this field ?

Regards,

Raymond

[shadab_maldar]

Hi,

Had you tried activating it through SE14.?

Regards,

Shadab.

[nishantbansal91]

Hi,

Have you added new field or you have changed the existing one.??

THanks

Nishant

[Former Member]

Hi Nishant,

I had changed existing field datatype.

Regards.

sridhar. A

[nishantbansal91]

Hi,

It's not recommended to change the standard table, add the field in ci_Prps include and use the same.

Because it could happen that field must use in many standard program. Never change the SAP standard field.

Be careful.

Thanks

Nishant