Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
For some reason I completely overlooked the open order value part of the
question when I read it this morning so ignore the suggested report
completely.
Did you try the left join?
On 9 June 2010 07:51, hovering_yogi via sap-log-sd <
sap-log-sd@groups.ittoolbox.com> wrote:
>
> Posted by hovering_yogi (Independent SAP SD Consultant currently at Sony)
> on Jun 9 at 2:59 AM
> Admittedly its not one display but have you checked VL06O - what would
> having different types of outstanding issue on one display give you?
>
> In terms of your query then change the join condition to LIPS a LEFT join
> and then you will still get records from the order tables even if a
> delivery
> hasn't been created. However be careful with queries in this area as
> avoiding duplicates when you start adding in information from areas like
> schedule lines say can be difficult to avoid. A custom ABAP report is
> probably better, although as above I don't see the value of combining
> everything in to one screen.
>
> On 8 June 2010 19:21, pimbrands via sap-log-sd <
> sap-log-sd@groups.ittoolbox.com> <http://groups.ittoolbox.com%3E> wrote:
>
> > Posted by pimbrands
> > on Jun 8 at 2:44 PM I'm looking for an overview to monitor the value
> > of all open orders.
> > We have two types of open orders:
> >
> > 1. Open orders for which the outbound delivery hasn't been created.
> > 2. Open orders for which the outbound delivery has been created but
> billing
> > status not completed.
> >
> > I want to create one overview, but the problem is that orders for which
> the
> > outbound deliveries are not shown when I create a query with the tables:
> > VBAK / VBAP / VBEP / LIPS. These orders are not yet created in the table
> > LIPS.
> >
> > IS their a standard overview available in SAP?
> > If not, please give me instructions how to compose the query.
> >
> > Thanks in advance.
> >
> > Best regards,
> >
> > Pim Brands
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  hovering_yogi
SAP Logistics Sales and Distribution Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement _.____.__ |
Mark as helpful
