Skip to Content
0

How to view Contracts and its sales order in Bex?

Mar 04, 2017 at 02:34 AM

56

avatar image
Former Member

I am brining in Sales data via 2lis_11_vaitm, the field VBELN can either be Sales order, Quotation or Contract, the way to distinguish them is via 0DOC_CATEG. The report needs to display Contract / Quotations and when you drill down, all sales orders associated with it should be shown.

I tried the following.

I Split data into 2 DSO's, and loaded one DSO with just Contracts and the second DSO with orders and joined them by Sales order and item from contracts dso with the reference number and item from the sales dso, but the problem with this is we cant do a full join. Left outer on either DSO's will miss records from the other one and inner join will miss records too. If multiprovider is an option how should the design be for the underlying infoproviders?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers