topic Re: Table updation in Application Development and Automation Discussions

Table updation

Former Member — Tue, 06 May 2008 07:03:20 GMT

Hi All,

Upon cross checking certain amounts of a std.transaction with a Y program we found there is some imbalance in the amounts.Can anyone suggest what would be the best way to update a data entry in a standard data base table (BSIS).

1.Write a piece of code to update the particular table entry ?

2.Use any BAPI ? If yes , how to search for a correct BAPI which can do the update ?

3.The table is not maintainable , can we still use table maintenanace generator ?

Kindly Advise.

Answers will be rewarded .

Regards,

Raajessh.

Re: Table updation

Former Member — Tue, 06 May 2008 07:08:01 GMT

Hi,

1.use the converter for the amount.(for amount problem)

2.update syntax:

UPDATE (table)

SET (set_expr)

WHERE (condition).

3.With the name or by checking the documentation of that BAPi.

4.If the table is not maintainable,Then it cann't possible to create table maintenance.

Regards,

Shiva.

Re: Table updation

Former Member — Tue, 06 May 2008 08:55:06 GMT

When you are updating the standard table you should be careful about ....

Go through the following statements.

perform dboperation_table using 'SET' 'BIRTHDT' '=' var_date.

perform dboperation_table using 'WHERE' 'PARTNER' '=' ls_import-partner.

perform dboperation_update using 'BUT000'.

form dboperation_table

using p_type

p_var1

p_var2

p_var3.

data: t_l type cmst_str_data.

data: d_cx_root type ref to cx_root,

d_text type string.

try.

clear t_l.

if p_var3 is not initial.

t_l = p_var3.

condense t_l.

concatenate '''' t_l '''' into t_l.

endif.

concatenate p_var1 p_var2 t_l into t_l

separated by space.

case p_type.

when 'SET'. append t_l to g_s_t.

when 'WHERE'. append t_l to g_w_t.

endcase.

catch cx_root into d_cx_root.

d_text = d_cx_root->get_text( ).

message a398(00) with d_text.

endtry.

endform. "DBOPERATION_table

form dboperation_update

using p_tabname type zdboperation-tabname.

data: tabname type bus_table.

data: d_cx_root type ref to cx_root,

d_text type string.

try.

tabname-tabname = p_tabname.

call function 'ZDBOPERATION_UPDATE'

in update task

exporting

tabname = tabname

tables

where_table = g_w_t

set_table = g_s_t.

catch cx_root into d_cx_root.

d_text = d_cx_root->get_text( ).

message a398(00) with d_text.

endtry.

endform. "DBOPERATION_update

Regards,

Madan.