RE:[sap-log-sd] MB58 and sales doc number
Posted by
Admin at
Share this post:
|
0 Comments
Posted by jmcoste on Aug 24 at 6:59 AM | Mark as helpful |
thanks Chris
this worked great
Lou Costello
SAP_PM BPRF Team
901.419.1161
james.costello@ipaper.com
"SAP is a matter of consistent unending learning. one should be prepared to
Learn, Unlearn and Relearn"
"ChrisO via sap-log-sd" <sap-log-sd@Group To s.ITtoolbox.com> jmcoste <james.costello@IPAPER.COM> cc 08/24/2009 05:31 AM Subject RE:[sap-log-sd] MB58 and sales doc number Please respond to sap-log-sd@Groups .ITtoolbox.com
(Embedded Posted by ChrisO (Mr) Mark this reply as helpful image on Aug 24 at 6:34 AM Mark as helpful moved to file: pic26962.j pg)
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
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
How Can Predictive Analytics Drive Competitive Advantage? Find out here