Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

update zz fields in delivery

Former Member

‎10-05-2007 5:05 PM

0 Kudos

Hello,

I want to update 2 zz fields appended in likp table. Which is the best and smart way to do it?

Now, I'm doing it with "update likp set ... "

Thanks

3 REPLIES 3

Former Member

‎10-05-2007 5:08 PM

0 Kudos

Hi,

Make use of an Update statement with all the key fields included in the where condition.

Eg:



UPDATE SCUSTOM SET: DISCOUNT  = '003',
                    TELEPHONE = '0621/444444'
              WHERE ID        = '00017777'.

REgards,

Santosh

Former Member

‎10-05-2007 5:21 PM

0 Kudos

Hi,

UPDATE with SET option is he best one, but use all the keywords in the where condition,

Regards

Sudheer

maciej_domagaa
Contributor

‎10-05-2007 8:02 PM

0 Kudos

If you mean updating those fields during some standard SAP transaction changing the delivery document (VL01N or VL02N for example), then the best way would be to make use of an appropriate user-exit. This allows to set the data in an internal structure which is then written to database by standard SAP code.

See this note to decide which user-exit would be the best for you:

415716 - User exits in delivery processing

regards