topic Re: Database activation in Application Development and Automation Discussions

Database activation

Former Member — Tue, 29 Sep 2015 09:34:35 GMT

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

Re: Database activation

shadab_maldar — Tue, 29 Sep 2015 09:42:25 GMT

Hi Sridhar,

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

Regards,

Shadab.

Re: Database activation

nishantbansal91 — Tue, 29 Sep 2015 09:44:47 GMT

Hi,

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

THanks

Nishant

Re: Database activation

shadab_maldar — Tue, 29 Sep 2015 09:46:42 GMT

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.

Re: Database activation

Former Member — Tue, 29 Sep 2015 09:48:02 GMT

Hi Nishant,

I had changed existing field datatype.

Regards.

sridhar. A

Re: Database activation

Former Member — Tue, 29 Sep 2015 09:51:09 GMT

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

Re: Database activation

nishantbansal91 — Tue, 29 Sep 2015 09:52:08 GMT

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

Re: Database activation

RaymondGiuseppi — Tue, 29 Sep 2015 10:05:46 GMT

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

Re: Database activation

shadab_maldar — Tue, 29 Sep 2015 10:18:57 GMT

Hi,

Had you tried activating it through SE14.?

Regards,

Shadab.