topic Re: Update data base table in Application Development and Automation Discussions

Update data base table

Former Member — Thu, 06 Mar 2008 21:19:23 GMT

I have custom table zmm_dscs

vth 5 fields and i want to add the 6th field

the 6th field data is filling in my internal table i_netpr

the field is netwr

i want to update my custom table zmm_dscs vth this field

How to do that

Plz suggest its very urgent

my read statmemt is follows where lwa_newnetpr is referening line type of i_netpr

read table lt_newnetpr into lwa_newnetpr with key domth = i_dscs-zz_dteca+6(2).

if sy-subrc = 0 and lwa_newnetpr-kostl = i_dscs-kostl.

i_detl-netwr = lwa_newnetpr-netwr.

endif.

Thanks in advance

Edited by: sukruthi raj on Mar 6, 2008 10:34 PM

Re: Update data base table

Former Member — Thu, 06 Mar 2008 21:44:22 GMT

Have you added the field in the data dictionary?

Rob

Re: Update data base table

Former Member — Thu, 06 Mar 2008 22:17:06 GMT

Hi rob

i added the field in the dictionary zz_netpr but i has to fill it

after the read stmt i added

i_dscs-zz_netpr = lwa_newnetpr-netwr.

data:

begin of i_dscs occurs 0.

include structure zmm_dscs.

in debbugging i am able to see that i_dscs is filled

but i cant able to see the data in the custom table zmm_dscs

Plz suggest me

Re: Update data base table

Former Member — Thu, 06 Mar 2008 22:28:05 GMT

Modify dbtable from table itab.

DBtable and Itab should be of same type.

Re: Update data base table

Former Member — Thu, 06 Mar 2008 22:33:30 GMT

Hi naren,

but here the DB table and internal table are not of same type

i would like update netwr filed values that are in i_dscs

into table zmm_dscs

In this table i added zz_netpr field

what i have to do is to fill zz_netpr field vth netwr values

Plz any help is highly appreciated

Re: Update data base table

Former Member — Thu, 06 Mar 2008 22:53:14 GMT

Sukruthi,

Can you please give me the fields in your database table and fields in your internal table?

I would be more helpful if you can pass on me that info.

Thanks,

Naren

Re: Update data base table

Former Member — Fri, 07 Mar 2008 00:14:58 GMT

there are so many fields in my custom table but kostl and zz_dteca are primary fields

In my internal table there are kostl,zz_dteca,netpr,netwr

are fields

i have to fill the zz_netpr field vth netwr values that i get in internal table

plz help me

Re: Update data base table

Former Member — Fri, 07 Mar 2008 00:38:04 GMT

Sukruthi,

Then you should define a work area (wa) of your data base table type.

Then select a record from your data base table using the key fields as below.

Select single * (if there are multiple records then use internal table rather than work area in this select statement and dont use SINGLE) from dbtable into work area (use internal table if there are multiple records) inwhere key1 = itab-key1 ......

then move itab-netwr to wa-zz_netpr .

modify dbtable from wa.

Rgds,

Naren

Re: Update data base table

Former Member — Fri, 07 Mar 2008 00:59:05 GMT

hi naren

this is my select query

select ekpo_{ebeln ekpo}ebelp ekpo_{matkl ekpo}netpr ekpo_{netwr zmm_dprpo}kostl zmm_dprpo_{zz_dteca ekpo}aedat

into corresponding fields of table i_netpr

from

ekpo inner join zmm_dprpo

on zmm_dprpo_{refbn = ekpo}ebeln

and zmm_dprpo_{rfpos = ekpo}ebelp

where ekpo~matkl eq c_matkl and

zmm_dprpo~kostl in s_kostl and

ekpo~aedat in r_dteca.

sort i_netpr by matkl ebeln ebelp.

delete adjacent duplicates from i_netpr comparing ebeln ebelp.

refresh lt_newnetpr.

loop at i_netpr where zz_dteca+4(2) = p_month.

at new zz_dteca.

clear lwa_newnetpr.

move-corresponding i_netpr to lwa_newnetpr.

lwa_newnetpr-domth(2) = i_netpr-aedat+6(2).

clear lwa_newnetpr-netwr.

endat.

lwa_newnetpr-netwr = lwa_newnetpr-netwr + i_netpr-netwr.

at end of zz_dteca.

append lwa_newnetpr to lt_newnetpr.

endat.

endloop.

plz give me the piece of code

Edited by: sukruthi raj on Mar 7, 2008 2:46 AM