Skip to Content
0

How do you relate a specific service notification type to a RAS sales order line item?

Sep 16, 2017 at 04:31 PM

46

avatar image
Former Member

I am attempting to create a report to identify scrapped materials, so I have joined a Z custom table with material specific information per industry to VBAP to VIQMFEL (tried table QMEL on another attempt). The expected result is that a sales order SO1234 with 5 line items will have 1 service notification assigned to it but instead the result is 1 notification for each line item. How can I make this join more efficient using table VIQMFEL as this has the majority of the data that I need?

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

0 Answers