topic Re: check and append data in Application Development and Automation Discussions

check and append data

Former Member — Mon, 26 Mar 2007 15:20:22 GMT

Hi All,

My queries as below. Hope can solving my issues. Thanks!

I have to check for the value assignment in table CABN -ATEIN.

If the value in that field equal to 'X', then I have to append the value 'S' to internal table i-display, otherwise will put 'M'.

Please correctly me if my coding wrongly.

code:

Select field1 field2 atein into (itab1_A, itab1_B, i_display) from CABN.

If the cabn-atein EQ 'X'.

itab1-atbew = 'S'.

ELSE.

itab1-atbew = 'M'.

ENDIF.

endselect.

Append itab1.

Re: check and append data

Former Member — Mon, 26 Mar 2007 15:28:46 GMT

Hi Little,

Try as follows.

SELECT FIELD1 FIELD2 ATEIN INTO TABLE ITAB1

FROM CABN.

UPDATE ITAB1 SET ATBEW = 'S' WHERE ATEIN = 'X'.

UPDATE ITAB1 SET ATBEW = 'M' WHERE ATEIN = ' '.

Thanks,

Vinay

Re: check and append data

Former Member — Mon, 26 Mar 2007 15:29:17 GMT

Hi,

select field1 field2 atein into itab1.

if cabn-atein eq 'x'

i-display-atbew = 's'

else

i-display-atbew = 'm'

endif

append i-display.

endselect

Regards,

Bhaskar

Re: check and append data

former_member194669 — Mon, 26 Mar 2007 15:31:47 GMT

Hi,


select field1 field2 atein atbew from CABN into corresponding field table itab1.
loop at itab1.
  if itab1-atein eq 'X'.
     itab1-atbew = 'S'.
  ELSE.
    itab1-atbew = 'M'.
  ENDIF.
  modify itab1 index sy-tabix.
endloop.

aRs

Re: check and append data

Former Member — Mon, 26 Mar 2007 15:33:49 GMT

Hi,

Select field1 field2 atein into (itab1_A, itab1_B, i_display) from CABN 
                                                                          where ATEIN = 'X'.
IF sy-subrc = 0.
itab1-atbew = 'S'.
ELSE.
itab1-atbew = 'M'.
ENDIF.
Append itab1. 
endselect.

Regards

Sudheer