Skip to Content

How to view Contracts and its sales order in Bex?

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers