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

modify DB table

Former Member
0 Likes
339

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???

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
311

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.

1 REPLY 1
Read only

Former Member
0 Likes
312

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.