Table maintenance for standard table

[Former Member]

Hi All,

There is a requirement for a program to maintain records in a standard table.

Can I generate a maintenance dialog for a standard table? I know that it needs Access key to generate Maintenance dialog for a standard table. But is this a good practice to generate maintenance dialog for standard table?

Please let me know your expert suggestions for creating this.

Thanks

Mark

[Former Member]

Hi All,

There is a requirement for a program to maintain records in a standard table.

Can I generate a maintenance dialog for a standard table? I know that it needs Access key to generate Maintenance dialog for a standard table. But is this a good practice to generate maintenance dialog for standard table?

Please let me know your expert suggestions for creating this.

Thanks

Mark

[Former Member]

Hi,

Please don't do this even if somebody force you to do this.

Regards.

[Former Member]

This is not a good idea.

1. Generated maintenance dialogs for a table will only update that table - not any other tables that may be updated when the standard SAP transaction is used. There can be a lot of hidden updates to extra tables to provide flow, history, audit, alternate index, BW extracts, etc which will not occur with a table maintenance dialog.

2. Generated maintenance dialogs for a table may bypass SAP security checks

3. Generated maintenance dialogs for a table may bypass Audit and other server level log updates

4. This could cause failure of other transactions if updates to the table have not (for example) kept number ranges up to date

I suggest you see if there is a BAPI available to do the updates, or resort to old reliable BDC processing using the standard transaction.

Andrew

[RaymondGiuseppi]

Don't do that, try to find the standard transaction which maintain the data, or build your own using BAPI or CALL TRANSACTION, regular way, to update the database.

Regards

[Former Member]

Hi Mark,

This is not recommended. Best practice is to use a BAPI or BDC to update the records.

Good Luck.....

Hope this helps.

Please reward if useful.

Thanks,

Srinivasa

[Maciej_DomagaBa]

All those guys are right.

But if you are sure that you won't damage data consistency by editing a standard table manually and your problem is just an access key for modifying standard table you may just create your own <u>view</u> based on that table and then generate the maintenance dialog for that view, not for the table.