topic Re: Modfiy database table from work area or variable issue in Application Development and Automation Discussions

Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 07:16:59 GMT

Hi Guys ,

I need to modfiy database table from the value in workare .iam dooing the code as below ..

modify Zdata_base from ls_inter_numb.

but it is not working ..

Can any one give right approach .

Regards,

Sri

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 07:19:47 GMT

what is the error you getting ?

Create the same workarea structure as your database table structure.

Can you paste the code of your workarea declaration ?

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 07:21:38 GMT

Hi Sri,

1) Make sure that the structure of the internal table / Work area is same as the structure of the data base table.

2) Write COMMIT WORK statement after the MODIFY statement and check.

Regards,

Kumar Bandanadham

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 07:26:05 GMT

Hi,

Please check the strucutre of the work area is same with the ztable

Loop at itab into ls_inter_numb.

modify Zdata_base from ls_inter_numb.

commit work.

endloop.

this must resolve your issue.. if dont please post the code -> ztable updating

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 07:34:44 GMT

Try to use a where clause and observe the Sy-subrc after that.

Thanks,

Mathivanan.G

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 07:39:56 GMT

Hi Sriram,

Collect all the data into an internal table and then modify in database.

For example:

Append ls_workarea TO it_table.

SORT it_table BY field.

IF NOT it_table[] IS INTIAL.

MODIFY Z_DB_TABLE from TABLE it_TABLE.

ENDIF.

This will work.

Regards,

Prashant

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 09:28:14 GMT

Hi,

below is the sample code ...

Select mara from Zmaterial into ls_mara

where ZMPN = <ls_INPUT_row>-ZMPN and

ZMNFR = <ls_INPUT_row>-ZGLBMF_CODE.

IF sy-subrc NE 0.

CALL FUNCTION 'NUMBER_GET_NEXT'

EXPORTING

NR_RANGE_NR = '01'

OBJECT = 'ZOBJ_MPN'

IMPORTING

NUMBER = LS_INTER_NUMB.

modfiy zmaterial from LS_INTER_NUMB.

Like this iam dooing ..

Regards,

Sri

Re: Modfiy database table from work area or variable issue

Former Member — Wed, 20 May 2009 09:35:35 GMT

I hope the Database table(ZMATERIAL) has only one field MARA. If not then your logic is wrong...