topic Re: Convert table MARA -- Help Me Please!! in Application Development and Automation Discussions

Convert table MARA -- Help Me Please!!

Former Member — Tue, 21 Apr 2009 10:54:59 GMT

Hi all,

I was to experiment if bapi extension works for currency field or not. As such added two fields ( one CURR other CUKY) in a Z-STRUCTURE already appended in MARA table.

After experimenting, I deleted these fields from the Z-Structure and tried activating the Z-structure. It ended up in partial activation of the Z-Structure and an Error message saying

Structure change at field level (convert table MARA)

Now though the fields have been deleted from the structure ZST_MMNEW, The MARA table still has these fields.

What should I do to remove these field from MARA? These fields are blank for all the records in MARA.

Have I done something wrong with the Standard SAP table? Can this be corrected?

Please help

Thanks in advance,

Re: Convert table MARA -- Help Me Please!!

Former Member — Tue, 21 Apr 2009 11:04:43 GMT

Hi,

Delete the same structure from MARA table and then add the modified structure again.

Regards,

Raju.

Re: Convert table MARA -- Help Me Please!!

Former Member — Tue, 21 Apr 2009 11:06:09 GMT

After deleting the fields from the z structure, go to SE14 transaction and click on Activate and Adjust database.

Regards,

Ravi

Re: Convert table MARA -- Help Me Please!!

ThomasZloch — Tue, 21 Apr 2009 11:07:37 GMT

Adjust MARA with tx SE14, keeping the existing table entries.

Depending on the table size this might take some time to finish, afterwards it should be OK.

Thomas

Re: Convert table MARA -- Help Me Please!!

Former Member — Tue, 21 Apr 2009 11:17:51 GMT

Ravi and Thomas,

Please tell me whether these steps will correct the problem

1. go to se14

2. Enter object name as MARA and Click EDIT.

3. Click "Activate and Adjust database" with the Save Data radio button checked.

Is it all? The current records in the table won't be deleted, right?

At present the mara table has 65K records. Will it take more than half hour to run this process?

Kindly confirm,

Thanks in advance,

Re: Convert table MARA -- Help Me Please!!

ThomasZloch — Tue, 21 Apr 2009 11:21:46 GMT

Yes, that's how it works. 65K is not much, could be a few minutes or even less. Maybe it even finishes after a few seconds, because you are deleting fields that were added last.

Thomas

Re: Convert table MARA -- Help Me Please!!

Former Member — Tue, 21 Apr 2009 11:47:33 GMT

Ravi and Thomas,

Thanks a lot,

Points awarded

Thanks,

Kumar Gaurav.