topic Re: Changing table attribute in Application Development and Automation Discussions

Changing table attribute

Former Member — Tue, 30 Oct 2012 10:02:51 GMT

Hi,

I would like to change the table attribute for TKA3C from the current "display/maintenance allowed with restrictions" to "display/maintenance allowed". Am i allowed to make this change since this is SAP delivered table with C delivery class?

I also noticed that another SAP delivered table T030 is having "display/maintenance allowed" status. So i believe it is okay to change the above table to this status. Please advise.

Re: Changing table attribute

kerem_kayacan — Tue, 30 Oct 2012 11:58:12 GMT

Are you aware that it would be a repair? Why don't you build a small maintenance program for that table?

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 12:06:09 GMT

This Customizing table is managed via SE34 on cluster view V_TKA3 (transaction OKB9)

What is your exact purpose, if you want to be able to change the data in production, do not change table attributes but call transaction SOBJ and declare the objects of the cluster view as "Current Settings". Else could you explain the reason of your question ?

Regards

Raymond

Re: Changing table attribute

Former Member — Tue, 30 Oct 2012 12:42:52 GMT

Hi Both,

I have 2000 entries need to be updated in this table. I cannot use OKB9 because LSMW does not record the dialog structures found there. So i thought of creating an LSMW at the table level update using se16.

I have done it thru se16 for T030 because of the "display/maintenance allowed" status, however for TKA3C, the attribute is "display/maintenance allowed with restrictions" which means i cannot create new entries using se16 under this attribute.

So i am thinking of changing the attribute to "display/maintenance allowed" to create the new entries at the table level using se16 via LSMW recording.

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 12:51:54 GMT

IMHO creating a BDC on SE16 is not more correct than a direct OPEN-SQL statement, and will cause more effort/pain in development ?

You could try to use a FM like VIEW_MAINTENANCE_SINGLE_ENTRY (or other FMs of group SVIM) on view V_TKA3A with SUPPRESSDIALOG = 'X' and action = 'UPD' or 'INS' ?

Regards,

Raymond

Re: Changing table attribute

Former Member — Tue, 30 Oct 2012 13:08:54 GMT

Hi Raymond,

I tried that FM for V_TKA3C, but due to the structure of this table, it does not work.

Can i change the attribute of this table to the required setting display/maintenance allowed? Is it allowed?

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 13:19:59 GMT

I tried that FM for  V_TKA3C, but due to the structure of this table, it does not work.

Could you elaborate ?

Regards,

Raymond

Re: Changing table attribute

Former Member — Tue, 30 Oct 2012 13:38:44 GMT

Hi,

When i use the FM, the system will ask for a new entry for the input value but it asks for only one when in actual fact there are many input values that we need to enter.

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 14:36:54 GMT

READ DATASET/or/CALL FUNCTION 'GUI_UPLOAD'...
LOOP AT itab...
  ...
  CALL FM...
ENDLOOP.

Also : Pass the whole structure of the view to the FM, disable the transport request and dialog thru parameters. Also SELECT from database and use INS or UPD action depending on sy-subrc.

Regards,

Raymond

Re: Changing table attribute

Former Member — Tue, 30 Oct 2012 14:45:34 GMT

okay i will try that out but are you saying changing the table attribute is not an option at all?

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 14:53:15 GMT

Changing the standard is rarely the best solution, it can cause problems in the short term, but certainly generate some the next upgrade.

(And changing the standard to build a Batch Input on SE16, so without most check... )

Regards,

Raymond

Re: Changing table attribute

Former Member — Tue, 30 Oct 2012 15:00:37 GMT

Hi Raymond,

But i want to change the table attribute only temporarily in the dev client and then put it back to what it was earlier after i have finished creating the 2000 entries.

So in this case is it safe to change it?

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 15:08:03 GMT

In this case, not much risk, but as I wrote in one previous answer, you could directly update the database table (then generate transport request via OKB9) but

- don't forget to reset the table to original state

- you will require a sscr key for the object

- you have to check yourself the validity of input data

But I would not do it myself...

Regards,

Raymond

Re: Changing table attribute

Former Member — Tue, 30 Oct 2012 15:24:54 GMT

Hi Raymond,

So does this mean technically we can change the attribute of the table and the system will allow us to do that?

Re: Changing table attribute

RaymondGiuseppi — Tue, 30 Oct 2012 15:28:37 GMT

With a sscr key http://service.sap.com/sscr