‎2012 Dec 15 8:35 AM
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
‎2012 Dec 16 11:57 AM
‎2012 Dec 16 1:05 PM
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.
‎2012 Dec 16 2:08 PM
loop at itab into wa where ort01 ne 'HYDARABAD'.
wa-ort01 = 'HYDARABAD'.
modify itab from wa.
endloop.