Skip to Content
avatar image
Former Member

Direct insert in standard database table

Hello Experts,

What are the implications to make direct insert on standard SAP database table which has attribute of Display/maintenance allowed with restrictions.

I know we are not allowed as per the SAP guidelines. Please give me your suggestions on this.

Thank you...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Apr 21, 2017 at 01:47 PM

    If you directly maintain a standard SAP database table you may be in violation of your warranty If you manage to screw up your data, SAP are not under any obligation to help you fix it, and certainly won't help you for free.

    The fact that the table is marked as "Display/maintenance allowed to limited extent" does not change this. This is a technical setting - not an opening up of the table so customers can modify it directly.

    What table is being considered for direct update?

    Who thinks it is a good idea - a developer?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 20, 2017 at 06:44 PM

    The basic meaning of the restrictions is explained here.

    https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/index.htm?file=abenddic_database_tables_maint.htm

    In self written ABAP programs none of these restrictions are checked automatically.

    The rest is almost a philosophical question. Are you able to estimate the consequences of your doings? Do you know all the relations that must be maintained?

    Add comment
    10|10000 characters needed characters exceeded

    • Horst,

      Why not SAP stop developers from doing direct database update on Standard tables by throwing an exception or Syntax errror ?

      Isn't that a feasible option or such a feature is not made available for some valid reasons ?

      K.Kiran.

  • Apr 21, 2017 at 08:14 AM

    How is the question of doing a "direct update" in a SAP standard table, related to the flag "Display/maintenance allowed with restrictions"? I don't understand. Doing a "direct update" will bring a risk of corrupting the database integrity. You should use BAPIs and a few other supported methodologies for doing database updates.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 21, 2017 at 10:37 AM
    I' sure no one will not recommend to take this approach unless it is something really business critical and cannot do what you want though the BAPI.
    • Data Inconstancy
    • Relevant documents will not be updated , SAP has a complex database structure you don't know where and what technical fields needs to be updated.
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2017 at 10:19 AM

    Hello All,

    Thank you for your suggestions. We got some FM to update the table.

    Thank you...

    Bhagavan Boppa

    Add comment
    10|10000 characters needed characters exceeded