Skip to Content
avatar image
Former Member

update zz fields in delivery

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 05, 2007 at 04:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2007 at 04:21 PM

    Hi,

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

    Regards

    Sudheer

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 05, 2007 at 07:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded