topic Re: Dynamic modify for the fields in a database table in Application Development and Automation Discussions

Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:08:35 GMT

Hii All,

I am in to a serious trouble it is as follows.

I have a Z table from which i will be getting a field name and from a idoc i will be getting a value in a segment.

I have to update a table with the value from the idoc into the field name which i have retrieved from the Z table.

Now based on the select the field name will be changing everytime based on select query.

Now how do i modify the Database table??? since the field is changing everytime.

I tried using the field symbols but it is not working.

it is not allowing me to wrote say W_itab-<FS> = idoc-value.

PLEASE HELP ME OUT.

Thanks,

Ravindra.

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:24:57 GMT

Hi Ravindra,

Can you paste your code for updating the Z table here?

Regards,

Prakash Pandey

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:31:42 GMT

Hi ravindra ,

You declare one generic structure with all the fields which are included in your select query.move corresponding values from field symbol to this structure. now easily u can update the table with the fields.The fields which will contains value will be updated and the remainig field which does not contain value will be empty.

like....

 * Generic structure with the required fields  (or) all the fields from the table
TYPES:
    BEGIN OF TYPE_S_GENERIC,
      KDGRP TYPE KDGRP,
      KUNNR TYPE KUNNR,
      MATNR TYPE MATNR,
      DATBI TYPE DATBI,
      DATAB TYPE DATAB,
      KNUMH TYPE KNUMH,
    END OF TYPE_S_GENERIC.

 * *  Select the records from table 

SELECT *
      FROM (WA_ALL_TABS-TABNAME)
      INTO TABLE <ITAB>
     WHERE (W_CONDITION)
       AND KAPPL EQ PR_KAPPL
       AND KSCHL EQ PR_KSCHL.

    IF SY-SUBRC EQ 0.
       CREATE DATA REF_WA LIKE LINE OF <ITAB>.
       ASSIGN REF_WA->* TO <FS_WA>.

       LOOP AT <ITAB> INTO <FS_WA>.
         MOVE-CORRESPONDING <FS_WA> TO WA_GENERIC.
         APPEND WA_GENERIC TO T_GENERIC.
      endloop.
  ENDIF.

Regards,

Rajitha.

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:36:27 GMT

Hi Ravindra,

Try the following code:

create a varable of type string.

DATA: lv_condition TYPE string.

Now as you said you have the name of the variable from the IDOC. So use a concatenate statement to create a UPDATE condition. Somewhat like this:

CONCATENATE idoc-field ' = ' idoc-value INTO lv_condition.

UPDATE ztable

set (lv_condition).

This was one of the ways.....

Hope this helps.

Regards,

Prakash Pandey

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:40:25 GMT

Hii

Here are the values in the ztable.

Z_VC_MY

Z_VC_MODEL

Z_VC_MARKET

Z_VC_DESTINATION

Z_VC_COLOR

Z_VC_ABS

Z_VC_WHEEL

Now in these values and the fields in some other table.

now every time in the select i will get some field name say in one case it is "Z_VC_WHEEL"

Now in the work area i need to update Z_VC_WHEEL field with the value i am getting in the IDOC.

and modify the data base table from the work area.

Thanks,

Ravindra.

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:48:43 GMT

Hi Ravindra,

Above given example is for a simple report. You can also do like that. If the work area contains only

Z_VC_WHEEL value and you want to updat with that value. Then the value will be updated with this field and make other fields remains same for that record.

Regards,

Rajitha.

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:51:37 GMT

Hi Ravindra,

If you already have the values in the work area then I have another way to solve your problem.

use the following statement.

ASSIGN COMPONENT 'Z_VC_WHEEL' OF STRUCTURE work_area to <fs_any>.

CHECK <fs_any> IS ASSIGNED.

<fs_any> = idoc-value.

Now you can update the database from your work area.

Regards,

Prakash Pandey

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 05:52:04 GMT

Hi Ravindra,

If you already have the values in the work area then I have another way to solve your problem.

use the following statement.

ASSIGN COMPONENT 'Z_VC_WHEEL' OF STRUCTURE work_area to <fs_any>.

CHECK <fs_any> IS ASSIGNED.

<fs_any> = idoc-value.

Now you can update the database from your work area.

Regards,

Prakash Pandey

Re: Dynamic modify for the fields in a database table

Former Member — Mon, 23 Feb 2009 08:00:09 GMT

Thank you very much Rajitha Sangi and Prakash Pandey

Thanks,

Ravindra