Skip to Content

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

UPDATE Question

Hello experts,

Imagine that you have an internal table (iTable) already filled with your data, and you need to update one field to 'ABC'. That is every record inside iTable will have 'ABC' in that field.

In SQL, we can do something like UPDATE [TABLE] SET field='ABC' (WHERE <conditions>).

In this one we don't need no conditions because the iTable already has the right data, so all i need is to update the field.

How can i do this in one step, i mean without having to loop the iTable and UPDATE each record?

Maybe i got this question badly, but the loop will take longer than the simple update right?

Regards,

Jorge

Tags:
Former Member
Former Member replied

t_data occurs 0,

matnr type matnr,

werks type werks,

st_data like line of t_data.

st_data-werks = 'STUFF'.

modify t_data from st_data transporting werks

where not matnr is initial.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question