topic Re: modify DB table in Application Development and Automation Discussions

modify DB table

Former Member — Sat, 17 Feb 2007 11:01:19 GMT

hi

i am using the following code to modify the table MSEG

TABLES : MSEG.

DATA : TB_MSEG LIKE STANDARD TABLE OF MSEG INITIAL SIZE 0 WITH HEADER

LINE.

SELECT * FROM MSEG

INTO TABLE TB_MSEG

WHERE CHARG = 'ADK309'

AND MBLNR = '6910003275'.

LOOP AT TB_MSEG.

MSEG-J_2CMANF = '100'.

MSEG-J_2CMEND = '3698'.

MODIFY MSEG FROM TABLE TB_MSEG.

IF SY-SUBRC = 0.

WRITE : / 'SUCCESFUYL'.

ENDIF.

ENDLOOP.

but its not happening.

can u help me with this please???

Re: modify DB table

Former Member — Sat, 17 Feb 2007 11:58:06 GMT

TABLES : MSEG.

DATA : TB_MSEG LIKE STANDARD TABLE OF MSEG INITIAL SIZE 0 WITH HEADER

LINE.

SELECT * FROM MSEG

INTO TABLE TB_MSEG

WHERE CHARG = 'ADK309'

AND MBLNR = '6910003275'.

LOOP AT TB_MSEG.

<b>TB_MSEG-J_2CMANF = '100'.

TB_MSEG-J_2CMEND = '3698'.

MODITY TB_MSEG INDEX SY-TABIX.</b>

ENDLOOP.

<b>MODIFY MSEG FROM TABLE TB_MSEG</b>

IF SY-SUBRC = 0.

WRITE : / 'SUCCESFUYL'.

ENDIF.