How to remove fields from view V_QCMBSEG for table BSEG

[nandishm]

Hi

By mistake have appended 5 fields in standard table BSEG,  after that i have deleted that appended structure from table, while deleting from different views network got disconnected i lost connection from server.

So process get terminated and those fields left in view V_QCMBSEG.

Because of this table partially activated.... is there any way to delete it

Thanks

[former_member289261]

Hi,

Try reactivating the table through se11.

Reactivating will automatically take care of dependent objects.

Regards,

Ashish

[nandishm]

its not activating ...its displaying error

Field BSEG-ZZCHANNEL is still being used as a view field in view V_QCMBSEG

Field BSEG-ZZPROD is still being used as a view field in view V_QCMBSEG

Field BSEG-ZZPROJ is still being used as a view field in view V_QCMBSEG

Field BSEG-ZZRECODE is still being used as a view field in view V_QCMBSEG

Field BSEG-ZZSTATE1 is still being used as a view field in view V_QCMBSEG

[Former Member]

Hi,

I have a same issue.

Did you fix this?

Thanks in advance.

[Former Member]

Oh, I solved it.

I just add those fields having error into BSEG Append. (ex. ZZPROD in the above.)

and activate it again. then everything's fine.

Thanks.

[Former Member]

hi....i got the same problem....

But is there any other solution ?

Bcoz I want to delete the bseg Z fields .....

And i am stucked in dead lock .....the bseg not displaying added zfield ...and when i am activating the bseg it gives error that "Z field is used in V_QCMBSEG"......

But the View V_QCMBSEG is displaying Z fields ....

SO, I am not able to delete the Z field from Bseg and not able to activate to BSEG table .........

Any Solution ?

Thx in advance.....

[Former Member]

Hi, Kartik.

I just did repeat creating and active.

what's the matter while you're deleting or activating~?

[Former Member]

The error is "Field BSEG-yygltext is still being used as a view field in view V_QCMBSEG"...

while activvating bseg table  and the appended Z STructure ........

So, i am not able to activate,delete , modify the bseg table and the Z structure...

And the bseg is displaying partially active status ...

So., I think i am stucked in DeadLock ....

Please Suggest me what to do in this situation...

[Private_Member_7726]

Hi,

What is your SAP Basis version and SP level? Check if 1933582 - Data has errors after conversion of cluster table or pool table is relevant for your system. The note explains that V_QCMBSEG is a temporary object created during conversion. I'd probably be contacting SAP support for advice on how to solve this.

cheers

Jānis

[Former Member]

Hi janis,

thanks.

You required information is as below..

SAP_BASIS   release = 702  , Level  = 0011 , and database release is 11.2.0.3.0...

[Private_Member_7726]

Ok, then the Note is relevant for your system. I'd implement it, try activating BSEG once again and if the system still goes into dead-lock (does not succeed in activating BSEG changes), open incident with SAP support.

If the activation does succeed after Note is implemented, i'd be transporting Note implementation before transporting BSEG changes.

cheers

Janis