topic Re: update structure help / erroe in Application Development and Automation Discussions

update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:28:17 GMT

HI ALL ,

I have functionality which i want to update some data but alwayes just one or more fields if somethig was cahged i.e.

if i have structure on the with

userid      1234
name        Jhon
language    EN
timezone    UTC
adress      Australia  
mail        www.sdn.com...

and in this structure i want to update just the language or other fields how i can do so

the language is just example it can be any fields and can be more then one field for instance

adress and mail .

userid      1234
name        Jhon
language    DE
timezone    UTC
adress      Australia  
mail        www.sdn.com...

when i try with modify

MODIFY ms_user FROM ls_user .

i get this error

"MS_USER" is not an internal table "OCCURS n" specification is missing.

but ms_user is in the method signature and type data base structure from se 11 .

how can solve this issue , i try also with update but noting ...

Thanks

Nina

Edited by: Nina C on Sep 21, 2009 9:28 AM

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:33:34 GMT

Hi,

if you only use a structure you can simly do this:

wa_struc-language = 'DE'.

wa_struc i your structurename.

Regards, Dieter

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:38:04 GMT

Hi,

Try using the transporting option of the modify statment.


MODIFY ms_user FROM ls_user transporting language.

Regards,

Vikranth

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:41:21 GMT

as its a structure, no need of MODIFY. modify is for tables.

you can simply use :

ms_user-language = 'DE'.

this wont change anything else except the language.. other fields will be there as usual..

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:41:30 GMT

Hi Dieter Gröhn ,

thanks but This is not my question ,

i want to update structure from other structure and i don't know which fields gonna be changed and i don't want to touch the fields that not changed so

how i can do so ?

Thanks

Nina

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:43:19 GMT

thanks but the language is just example

it can be any other fields so what is the best way to handle it ?

the problem is that i don't know which fields is chanced

Regards

Nina

Edited by: Nina C on Sep 21, 2009 9:44 AM

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:43:56 GMT

if the two structure are of same type:

then just use:

ws_ma = ls_ma.

if they are not same,

you need to use

MOVE-CORRESPONDING gs_wa to ms_wa.

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 07:47:46 GMT

Hi,

the same way:

olf_struc = new_struc.

Regards, Dieter

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 08:01:38 GMT

Hi,

If MS_USER is the original structure name, declare a reference structure and modify it.


data: it_ms_user type standard table of ms_user with header line.


loop at it_ms_user.
move-corresponding ls_user to it_ms_user.
modify it_ms_user.
endloop.

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 08:06:27 GMT

Hi Dieter Gröhn ,

it's not that simple ,

the problem is i am on update process ( i get structure with data ) and i do select singe from the DB to another structure (read before update ) and after i do some compering with the structure fields if somethig is diffrent

I can get for instance the fields to update (just userid is the key)

userid 1234

name Jhon

language EN

timezone

adress USA

mail

and in the DB i have

userid 1234

name Jhon

language DE

timezone UTC

adress Australia

mail www.sdn.com.

i dont want to overwrite the field that already exist i just want to update the fields that i get for update and dont touch the other fields ?

Regards

Nina

Edited by: Nina C on Sep 21, 2009 10:11 AM

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 08:28:06 GMT

Hi,

Is this what you are looking for?



select single * from db into itab where (any conditions)


loop at MS_USER.
read table itab with key userid = MS_USER-userid.
if sy-subrc = 0.
modify MS_USER from itab.
endif.
endloop.

Regards,

Vikranth

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 08:38:15 GMT

hI Vikranth,

Thanks but how i can know if one fields is changed language or adress or email ?

Reagrds

Nina

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 08:38:25 GMT

If you want to update only the changed fields, you will need to compare each field (old vs. new value).

This example should give you an idea to work with.

DATA: wa_mara_old     TYPE mara,
      wa_mara_new     TYPE mara.


FIELD-SYMBOLS: <fs_old> TYPE any,
               <fs_new> TYPE any.


SELECT * INTO wa_mara_old
  FROM mara
    UP TO 1 ROWS.
ENDSELECT.



wa_mara_new = wa_mara_old.
wa_mara_new-ersda = sy-datum.

write: / 'MARA old ersda', wa_mara_old-ersda.
write: / 'MARA new ersda', wa_mara_new-ersda.
uline.


DO.

  ASSIGN COMPONENT sy-index OF STRUCTURE wa_mara_old TO <fs_old>.
  IF sy-subrc NE 0.
    EXIT.
  ENDIF.

  ASSIGN COMPONENT sy-index OF STRUCTURE wa_mara_new TO <fs_new>.
  IF <fs_old> NE <fs_new>.
    <fs_old> = <fs_new>.
  ENDIF.

ENDDO.

write: / 'MARA old ersda', wa_mara_old-ersda.
write: / 'MARA new ersda', wa_mara_new-ersda.

This only works if both structures have the same definition!

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 08:53:15 GMT

you must compare field by field.

You can do it like this:


TABLES: MARA.
FIELD-SYMBOLS: <FS_OLD>, <FS_NEW>.
DATA: STRU_OLD TYPE MARA.
DATA: STRU_NEW TYPE MARA.
*
START-OF-SELECTION.
*
  SELECT SINGLE * FROM MARA.
*
  STRU_OLD = MARA.
  STRU_NEW = MARA.
*
  STRU_NEW-BISMT = 'newvaulue'.
* Now the structures are different.
*
  DO 1000 TIMES.
    ASSIGN COMPONENT SY-INDEX OF STRUCTURE STRU_OLD TO <FS_OLD>.
    ASSIGN COMPONENT SY-INDEX OF STRUCTURE STRU_NEW TO <FS_NEW>.
    IF SY-SUBRC <> 0. EXIT. ENDIF.
    IF <FS_OLD> <> <FS_NEW>.
      <FS_OLD> = <FS_NEW>.
    ENDIF.
  ENDDO.
*
END-OF-SELECTION.

Regards, Dieter

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 09:04:54 GMT

Hi,

You can just use the simple assignment to check if there is any change in the fields.

For eg,


select single * from db into itab where (any conditions)
 
 
loop at MS_USER.
read table itab with key userid = MS_USER-userid.
if sy-subrc = 0.
if MS_USER NE itab.          "Comparing the header items of both the internal tables.   
modify MS_USER from itab. "Modify only if there is any change in the fields
endif.
endif.
endloop.

Regards,

Vikranth

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 09:16:52 GMT

HI Dieter ,

The problem is that the when one fields are equal the going to the exit

and not compare all other fields why ?

Regards

Nina

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 09:24:52 GMT

Hi,

do you set the DO - loop like i have mentioned?

The exit will be executed if the assign gets an error, because there isn't an structure field.


  DO 1000 TIMES.
    ASSIGN COMPONENT SY-INDEX OF STRUCTURE STRU_OLD TO <FS_OLD>.
    ASSIGN COMPONENT SY-INDEX OF STRUCTURE STRU_NEW TO <FS_NEW>.
* here the exit
    IF SY-SUBRC  0. EXIT. ENDIF.
*
    IF <FS_OLD>  <FS_NEW>.
      <FS_OLD> = <FS_NEW>.
    ENDIF.
  ENDDO.

regards, Dieter

Edited by: Dieter Gröhn on Sep 21, 2009 11:25 AM

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 09:30:09 GMT

Thanks ,

i try your code and its not working ,

basically what i expect is at the end wa_mara_new will have the old fields that are not

changed and the new fields that change and with all this field i can update the DB .

but its not working like that .

Regards

Nina

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 09:44:24 GMT

Thanks ,

i try your code and its not working ,

baisicliy what i expect is at the end STRU_OLD will have the old fields that are not

changed and the new fields that change and with all this field i can update the DB

Regards

Nina

Re: update structure help / erroe

Former Member — Mon, 21 Sep 2009 09:44:54 GMT

Thanks ,

i try your code and its not working ,

baisicliy what i expect is at the end STRU_OLD will have the old fields that are not

changed and the new fields that change and with all this field i can update the DB

Regards

Nina