cancel
Showing results for 
Search instead for 
Did you mean: 

maintenance view on the standard table

Former Member
0 Kudos

Hi,

We need to have a maintenance view on the standard XYZ table .

Since it is a std table. we would not be able to create a maintenance view since we need an access key.

So we have to :

1. Copy the table XYZ into a Z_table. (just the structure alone).

2. Create a table maintenance generator on this table.

3. When the data is being saved in the maintenance view, update the record in the XYZ.

How we can populate the XYZ when the Z_table is populated with data?

Can anyone help in this regard.

Thanks and regards,

Kapil

Accepted Solutions (0)

Answers (1)

Answers (1)

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

Doing a direct database update on a standard table is not recommended. Which table are you referring to?

Regards,

RIch Heilman

athavanraja
Active Contributor
0 Kudos

you could also write a program to call function

call function 'VIEW_MAINTENANCE_CALL'

exporting

action = 'U'

view_name = '<name of the table for which maintenance is required>'.

Regards

Raja

Former Member
0 Kudos

Hi Rich,

Thanks for your reply.

I am referring to standard table "comc_settyp_attr" in SAP-CRM system . I have copied it and created a z_table. But its not allowing me to create a maintainance view. Its giving an error :

GUID in table key (Field name CUSTINFO) not supported.

But when i create the z_table without the GUID(char 32) as key field, it generates table maintenance. But the key field is required.

Can you help me in this regard.

Regards,

Kapil

Former Member
0 Kudos

Hi Raja,

Thanks for your reply.

I am referring to standard table "comc_settyp_attr" in SAP-CRM system . I have copied it and created a z_table. But its not allowing me to create a maintainance view. Its giving an error :

GUID in table key (Field name CUSTINFO) not supported.

But when i create the z_table without the GUID(char 32) as key field, it generates table maintenance. But the key field is required.

Can you help me in this regard.

Regards,

Kapil