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: 

link b/w sales order and delivery details

Former Member

‎07-27-2009 2:02 PM

0 Kudos

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,

2 REPLIES 2

Former Member

‎07-27-2009 2:05 PM

0 Kudos

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

Former Member

‎07-27-2009 2:06 PM

0 Kudos

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