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

is it possible to update a sap standard table's value with a small program

Hi all,

Friends I need to update a sap table called QALS, the paendterm of this table have to be updated and I do not know any way to update an sap standard table.

Is there any way?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    Posted on Dec 04, 2007 at 12:08 PM

    Hi,

    U can directly update the table by UPDATE statement but SAP recomends not to go for this,instead use BDC and update the field...check if this field is not affecting with other tables...then u can use UPDATE statement..

    Regards,

    Nagaraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:15 PM

    yes it is possible but if you do not exactly know what you are doing here, or what other data could be affected, then DONT do it!

    the question if it is possible, shows clearly you SHOULD NOT go for this way.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:18 PM

    hi Deniz,

    You can use the following commands to create, change or delete entries of a databse table.

    UPDATE,

    INSERT,

    MODIFY,

    DELETE.

    Thaks,

    Kasiraman R

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:09 PM

    HI

    Yes you can update the standard sap tables by small report program

    modifying datbase table useing internal table

    advises before updating this datbase table plz lock that table to avoid incosistency

    write the logic for modifying

    • Modify the database table as per new dunning procedure

    MODIFY fkkvkp FROM TABLE lt_fkkvkp .

    and finally unlock the table

    example

    *To lock table for further operations

    constants: lc_tabname TYPE rstable-tabname VALUE 'FKKVKP' . "FKKVKP

    CALL FUNCTION 'ENQUEUE_E_TABLE'

    EXPORTING

    tabname = lc_tabname

    EXCEPTIONS

    foreign_lock = 1

    system_failure = 2

    OTHERS = 3.

    IF sy-subrc EQ 0.

    • To fetch all the contract accounts for customers of the segment

    • Households/SME.

    PERFORM fetch_contract_accounts using lc_tabname .

    ENDIF. " IF sy-subrc EQ 0.

    *wrote the logic

    • Modify the database table as per new dunning procedure from internal table

    MODIFY fkkvkp FROM TABLE lt_fkkvkp .

    *unlock the tbale

    CALL FUNCTION 'DEQUEUE_E_TABLE'

    EXPORTING

    TABNAME = uc_tabname .

    Reward if usefull

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 12:14 PM

    Updating a SAP standard table is in no ways different, programmatically, from updating one of your own Z tables.

    Be aware that if you modify a SAP standard table with your own program, you may find that if it all goes horribly wrong, then SAP will charge you lots of money to fix it.

    Generally, I'd advise finding another method. Usually, SAP have written programs that allow you to enter all types of data you could possibly need, with full validation.

    matt

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:29 PM

    Thanks for all of you.

    I have rewarded all answers based on the reply rank, because all the replies are nearly the same and I have taken into account whom replied first and goes like that....

    Thanks again.

    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.