Skip to Content
author's profile photo Former Member
Former Member

can i change or modify or insert the data in standard tables

hi gurus

can i change /modify/insert the data in standard tables

witout using module pools

plz send the progem lines also

it ll be very helpful to me

thank you

kals.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2007 at 01:56 PM

    While you can do this in code, you should NEVER do so. Direct update of standard tables will bypass authorisation checks, change / audit logging, any cascaded updates to other tables, and SAP data validation.

    Doing direct updates can corrupt the data integrity of the system - and be against tax / audit requirements of the company.

    Look for SAP supplied BAPI functions, use BDC or IDOCS, and similar methods only to update SAP standard tables.

    Andrew

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 09, 2007 at 02:49 PM

    Hi Kalyan,

    It is not advisable to update standard tables directly or through your own module pool programs also. The reasons are,

    1. It is difficult to find out how many tables are updated through the transaction. if we leave one table also as Mr.Andrew said data integrity will be lost.

    2. Authorization objects and profiles will be totally bypassed if data is inserted through custom programs.

    3. Complete data validation is not possible. There are certain validations that are executed through code and appropriate errors and warnings are shown in the transactions. If we insert data directly to the tables anything can be inserted into the table field violating all the validations unless we have field level check constraints on the tables at database level.

    4. User Exits and BADIs that are implemented for specific business requirements and checks will not function on the data.

    5. Update & Transaction locks will not work properly.

    Due to above reasons, definitely you should avoid updating standard tables directly.

    There are many tools such as LSMW Recordings, BDCs, BAPIs, IDOCs, Upload Interfaces available in SAP through which bulk data can be updated without using relevant transactions.

    You can collect data from end users in text or excel sheets or through custom programs in required format and upload at once through above mentioned tools.

    Regards,

    Hema

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.