RE:[sap-log-mm] How to get PO number belonging to the material document

Posted by Kate_
on Sep 7 at 5:15 AM
Hi All,

Thanks everybody for your answers. I marked those that I could use as helpful.

Emmanuel, I have no auth for sqvi.

Cheers,

Kate_

---------------Original Message---------------
From: Emmanuel Leclainche
Sent: Tuesday, September 06, 2011 5:39 AM
Subject: How to get PO number belonging to the material document

Hello Kate

If you have all the document numbers related to those purchases, I would suggest an easy Query.

Run SQVI
Create a Table Query
Choose Table MSEG (material movements)

Pick as fields:

MSEG-MBLNR (Material movement number)
MSEG-MJAHR (Running Exercise)
MSEG-ZEILE (Position)

MSEG-BWART (movement code)
MSEG-WERKS (Plant)
MSEG-MATNR (article code)
MSEG- DMBTR (value) <=
MSEG-MENGE (qty)

MSEG-EBELN (PO)

You should have the total value in internal currency.

Regards,
Emmanuel

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT
_.____.__

0 Response to "RE:[sap-log-mm] How to get PO number belonging to the material document"

Post a Comment