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

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.

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

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

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

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.