Skip to Content
avatar image
Former Member

link b/w sales order and delivery details

Hi all,

i need to display the sales order header and item based on the delivery header and item. i need to provide link b/w sales order and delivery details. how can i do it/

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 27, 2009 at 01:05 PM

    Hi,

    Link between Sales Order and Delivery are

    lips-vgbel = vbap-vbeln

    Regards

    Milan

    Edited by: Milan Shah on Jul 27, 2009 6:36 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 27, 2009 at 01:06 PM

    Hi

    If you starts from delivery you can find the sales order number and item in LIPS table: LIPS-VGBEL and LIPS-VGPOS, if you need to start from sales order it should be better to use the table VBFA (document flow) and search the next document of sales order VBFA-VBELN and VBFA-POSNN with VBFA-VBTYP_N = 'J'

    Max

    Add comment
    10|10000 characters needed characters exceeded