Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Case issue in Database table

Hi All,

We have an issue of lowercase in database table and we want to convert that lowercase data to upper case. The code for doing this operation is as follows:

"

SELECT * FROM zehs_volumes INTO TABLE i_volumes_temp.

LOOP AT i_volumes_temp.

DELETE zehs_volumes FROM i_volumes_temp.

IF sy-subrc is INITIAL.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

TRANSLATE i_volumes_temp-zehs_business TO UPPER CASE.

MODIFY i_volumes_temp.

CLEAR i_volumes_temp.

ENDLOOP.

SORT i_volumes_temp BY SUBID ZEHS_BUSINESS ZEHS_SITE ZEHS_ROLE

ZST_DATE ZED_DATE.

DELETE ADJACENT DUPLICATES

FROM i_volumes_temp COMPARING SUBID ZEHS_BUSINESS ZEHS_SITE

ZEHS_ROLE ZST_DATE ZED_DATE.

MODIFY zehs_volumes FROM TABLE i_volumes_temp.

IF sy-subrc is INITIAL.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

"

The problem wid the above code is that it first clears the entire database table and then fills it with the modified data from the internal table. But we do not want to take risk of emptying the database table. Is there any way out to perform the above operation?

Thanks in advance

Regards,

Yogesh Sharma

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question