topic Re: UPDATE dynamic in Application Development and Automation Discussions

UPDATE dynamic

ronaldo_aparecido — Thu, 13 Jun 2013 19:31:13 GMT

Hello guys

I need to use the command update dynamic but he does not accept the set dynamic

how can I do this command:

UPDATE (v_tbnam) SET (field) = 'TBRA'.

He says that the set is wrong.

Thanks.

Re: UPDATE dynamic

Former Member — Fri, 14 Jun 2013 05:16:13 GMT

Hi,

see the SAP example:

Example

Dynamic conversion of the content of an arbitrary column in an arbitrary database table of a previous currency in Euro.

PARAMETERS: table    TYPE c LENGTH 30,
            column   TYPE c LENGTH 30,
            old_curr TYPE sycurr.

DATA: set_expr TYPE string,
      condition TYPE string.

CONCATENATE column ` = 'EUR'`
            INTO set_expr.

CONCATENATE column ` = old_curr`
            INTO condition.

TRY.
    UPDATE (table)
    SET    (set_expr)
    WHERE (condition).
CATCH cx_sy_dynamic_osql_error.
    MESSAGE `Error in update!` TYPE 'I'.
ENDTRY.

Regards,

Klaus

Re: UPDATE dynamic

Former Member — Fri, 14 Jun 2013 05:29:21 GMT

Hi,

Provide the where condition along with this.

Please see below:

TRY.

UPDATE (table)

SET (set_expr)

WHERE (condition).

CATCH cx_sy_dynamic_osql_error.

MESSAGE `Error in update!` TYPE 'I'.

ENDTRY.

Regards,

Jayshree.

Re: UPDATE dynamic

FredericGirod — Fri, 14 Jun 2013 05:34:49 GMT

Hi Ronaldo,

I never do this, but the SAP logic would be :

Update (W_TBNAME) SET (W_SET) WHERE (WHERE).

regards

Fred

Re: UPDATE dynamic

Former Member — Fri, 14 Jun 2013 05:40:03 GMT

Hi Ronaldo,

Use Field Symbol to achieve your goal.

Use the following Syntax:

DATA tbnam TYPE TABLE OF v_tbnamt.

FIELD-SYMBOLS <fs_tbnam> TYPE v_tbnam.

SELECT * FROM v_tbnamt INTO TABLE tbnamt.

IF sy-subrc = 0.

LOOP AT tbnamt ASSIGNING <fs_tbnam>.

<fs_tbnam>-field = New_value.

ENDLOOP.

ENDIF.

UPDATE (v_tbnam) FROM TABLE tbnam.

Thanks

Dileep Kumar

Re: UPDATE dynamic

Former Member — Fri, 14 Jun 2013 05:46:34 GMT

Hi,

You can do it like this.

TABLE_NAME = 'ZMYTABLE'

CONCATENATE 'MYFIELDNAME = ' '''' 'MYVALUE' '''' INTO T_SET.

UPDATE (TABLE_NAME) SET (T_SET).

Yakub Shah

Re: UPDATE dynamic

rainer_hbenthal — Fri, 14 Jun 2013 05:59:00 GMT

You have to put the whole logical condition into a variable:

[code]

concatenate fieldname `=` value into condition.

update (v_tbname) set (condition),

[code]

Re: UPDATE dynamic

ronaldo_aparecido — Fri, 14 Jun 2013 06:09:03 GMT

thanks worked

Re: UPDATE dynamic

RaymondGiuseppi — Fri, 14 Jun 2013 07:13:39 GMT

I just hope you are not updating a standard table with a dynamic sql statement

Regards,

Raymond

Re: UPDATE dynamic

rainer_hbenthal — Fri, 14 Jun 2013 07:23:20 GMT

Whatever can be used will be used (somewhere)

Re: UPDATE dynamic

RaymondGiuseppi — Fri, 14 Jun 2013 07:36:28 GMT

Yes, and Anything that can go wrong, will go wrong (someday)

Re: UPDATE dynamic

rainer_hbenthal — Fri, 14 Jun 2013 08:45:45 GMT

Better type 'A' so in case of an error all previous updates are rolled back to have a consistent state.

Re: UPDATE dynamic

ronaldo_aparecido — Mon, 17 Jun 2013 19:12:20 GMT

Its Z table relax