RE:[sap-log-sd] MB58 and sales doc number
Posted by
Admin at
Share this post:
|
0 Comments
Posted by ChrisO (Mr) on Aug 24 at 6:34 AM | Mark as helpful |
We have customer consignment stock orders so I looked into this, as it may be of use to us. You can use the delivery tables LIPS and LIKP linked to MSKU. The links are via LIKP-KUNAG to MSKU-KUNNR and LIPS-MATNR, -WERKS and CHARG to the same fields in MSKU.
If you link tables L-R as LIKP-LIPS-MSKU (I did an initial trial in SQVI), then you return all delivery records for customer consignment batches, even if that batch in MSKU shows zero, without using a left-outer join to force the zero field in MSKU to be returned.I found that I needed to remove the duplicate report lines where WM Mvt Type is '000' (keeping WM Mvt Type 255). When I did this it tied up perfectly in our system with with MB58.
The beauty of using LIKP-LIPS is that not only do you get sales order no. (LIKP-VGBEL, and not KDAUF ('Sales Order No.') as one might expect) but you also get sold-to and ship-to (link from LIKP to MSKU must be by sold-to) and a load of batch info like production date and shelf life. There's probably other useful stuff in those tables as well.
Hopethishelps
ChrisO
__.____._ If you link tables L-R as LIKP-LIPS-MSKU (I did an initial trial in SQVI), then you return all delivery records for customer consignment batches, even if that batch in MSKU shows zero, without using a left-outer join to force the zero field in MSKU to be returned.I found that I needed to remove the duplicate report lines where WM Mvt Type is '000' (keeping WM Mvt Type 255). When I did this it tied up perfectly in our system with with MB58.
The beauty of using LIKP-LIPS is that not only do you get sales order no. (LIKP-VGBEL, and not KDAUF ('Sales Order No.') as one might expect) but you also get sold-to and ship-to (link from LIKP to MSKU must be by sold-to) and a load of batch info like production date and shelf life. There's probably other useful stuff in those tables as well.
Hopethishelps
ChrisO
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
_.____.__ White Papers
In the Spotlight
Share Knowledge About SAP Scripting. Join the New Discussion Group