Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Internal table - modify statement

Former Member
0 Likes
635

HI i am subbareddy new to sap abap now i am in training

my intension is TO DECLARE  AN INTERNAL TABLE WITH FOLOWING RECORDS I.E BUKRS,BUTXT,ORT01,LAND1,ADRNR

MODIFY ALL THE RECORDS WITH CITY(ORT01) HYDERABAD'

i wrote this program but its not executed.please suggest me.

TYPES: BEGIN OF ty_t001,

       bukrs TYPE t001-bukrs,"company code

       butxt TYPE t001-butxt,"company name

       ort01 TYPE t001-ort01,"city

       land1 TYPE t001-land1,"country key

       adrnr TYPE t001-adrnr, " address

       end of ty_t001.

  DATA : iT_t001 TYPE TABLE OF TY_T001,

          WA_T001 TYPE TY_T001.

  SELECT BUKRS BUTXT ORT01 LAND1 adrnr FROM T001 INTO TABLE IT_T001

         WHERE LAND1 = 'DE'.

  SORT IT_T001 deSCENDING BY BUKRS.

  WRITE : / 'LIST OF GERMAN COMPANIES IN DESCENDING ORDER' COLOR 1.

            ULINE.

  LOOP AT IT_T001 INTO WA_T001.

    WRITE : /  SY-TABIX,WA_T001-BUKRS, WA_T001-BUTXT, WA_T001-ORT01, WA_T001-LAND1 ,wa_t001-adrnr.

    ENDLOOP.

     CLEAR wa_t001.

     wa_t001-ort01 = 'hyderabad'.

     MODIFY it_t001 FROM wa_t001 TRANSPORTING ort01.

     if sy-subrc = 0 .

      WRITE : /'data after modify' COLOR 1.

         uline.

     WRITE : / sy-tabix,wa_t001-bukrs,wa_t001-butxt,

              wa_t001-ort01,wa_t001-land1.

     ENDIF.

can u please suggest me how can i modify all the records with city(ort01) hyderabad.

Moderator Message - Basic ABAP syntax, do an F1. Thread locked.

Message was edited by: Suhas Saha

3 REPLIES 3
Read only

frank_bannert
Active Participant
0 Likes
562

I have move your question to the right topic space.

Best,

Frank

Read only

basarozgur_kahraman
Contributor
0 Likes
562

Hi Subba,

You can add Where clause to modify statement

ex:

CLEAR wa_t001.

wa_t001-ort01 = 'hyderabad'.

MODIFY it_t001 FROM wa_t001

TRANSPORTING ort01

WHERE bukrs IS NOT INITIAL.

Read only

Former Member
0 Likes
562

loop at itab into wa where ort01 ne 'HYDARABAD'.

wa-ort01 = 'HYDARABAD'.

modify itab from wa.

endloop.