Changing table attribute

[Former Member]

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.

[kerem_kayacan]

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

[RaymondGiuseppi]

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

[Former Member]

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.

[RaymondGiuseppi]

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

[Former Member]

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?

[RaymondGiuseppi]

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

Could you elaborate ?

Regards,

Raymond

[Former Member]

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.

[RaymondGiuseppi]

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

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

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?

[RaymondGiuseppi]

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

[Former Member]

Hi Raymond,

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

[RaymondGiuseppi]

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