topic How to Activate and adjust database structure in Application Development and Automation Discussions

How to Activate and adjust database structure

former_member295881 — Thu, 31 Jul 2008 15:18:18 GMT

Hello Experts!

I am working on a screen-exit u2018PPCO0012u2019. In u2018EXIT_SAPLCOKO1_002u2019 function exit & there is a structure given u2018CI_AUFKu2019. I did implement this structure but now I donu2019t need this user-exit anymore. How can I delete this field from structure? Because when I try to delete the field and check this structure it gives me error message

u2018Structure contains no fieldu2019.

Also like as we can u2018Activate and adjust databaseu2019 table through database utility is there anyway to do the same for structure?

Thanks a lot in advance.

Re: How to Activate and adjust database structure

Former Member — Thu, 31 Jul 2008 16:56:07 GMT

HI,

Before your are deleting this Append structure, first using the WHERE USED LIST delete all the references to it, then

delete the fields in the structure and then delete the structure and then save n activtate.

IF you still geting the problems then, In the Menu oif SE11->

Database Utility-> Activate and Adjust the table,

Now save n Activtae the table.

Hope this will solve your issue.

Regards

Chandralekha.

Re: How to Activate and adjust database structure

former_member295881 — Thu, 31 Jul 2008 19:04:22 GMT

Hello Kamesh

In our system there is a short dum on t-code VA02,VA03,ME22N,ME23N,MM02,MM03 and always this message showup

'Inconsistency in the Dictionary for the structure "VBDKL".'

Then I went to check VBDKL (structure). When I checked it I get this message

'Field NAME1 in table VBDKL is specified twice. Please check'

I looked many time but NAME1 is not repeating at all. Not even in include structures.

Can you think of anything what causing it?

Re: How to Activate and adjust database structure

Former Member — Thu, 31 Jul 2008 19:25:41 GMT

Did you add any custom fields to the table or included structure? If yes then check the fields again.

If you getting the error after an upgrade or Support pack...Look for OSS notes.

Re: How to Activate and adjust database structure

former_member295881 — Thu, 31 Jul 2008 19:38:52 GMT

Yes I did add a feild to a custome structure COCI_AUFK. But I used for component I sued ZZNAME and component type is NAME2. Now I donno is this causing problem?

But what I've done it i deactive my this project thought cmod.

Still having short dum becuase of VBDKL

this is error:

'Inconsistency in the Dictionary for the structure "VBDKL".'

Then I went to check VBDKL (structure). When I checked it I get this message

'Field NAME1 in table VBDKL is specified twice. Please check'

I looked many time but NAME1 is not repeating at all. Not even in include structures

Re: How to Activate and adjust database structure

Former Member — Thu, 31 Jul 2008 21:19:29 GMT

Goto to transaction SE14

give the structure Name

and then u have the push button activate and Adjust Database i think that will be fine

Regards

Devanand

Re: How to Activate and adjust database structure

former_member295881 — Fri, 01 Aug 2008 11:01:34 GMT

Thanks a lot everyone who respond on my query. I found what causing the problem. Actually during a modification I create a custome structure in which i used this field NAME1. And this field was causing the problem becuase I have the same component and component type as structure "VBDKL" . Now I've changed it and everything is looking good. Devanand speciall thanks to you. Now I got 1 more transaction under my belt which will come handy later down the road.

Edited by: zero cool on Aug 1, 2008 1:02 PM

Edited by: zero cool on Aug 1, 2008 1:03 PM

Edited by: zero cool on Aug 1, 2008 1:04 PM

Re: How to Activate and adjust database structure

former_member295881 — Fri, 01 Aug 2008 11:02:19 GMT

Thanks for everybody for repling on my query