Re: [sap-log-mm] SAP Query for material master PRICE and GRN

Posted by Sap Land Wednesday 24 August 2011 03:53

Posted by jahir-hussain
on Aug 24 at 6:54 AM

Dear MairyMano,

In this case you can't get exact Max-Grn. because multiple grn has been done in
the same day. In this case will come latest grn only.
But Max(mblnr) you can get exact and accurate latest grn with movement 105.

Regards
Jahir

---------------Original Message---------------
From: Humaira Aslam
Sent: Wednesday, August 24, 2011 12:50 AM
Subject: SAP Query for material master PRICE and GRN

Hi Jahir,

Here matno and maxdate are my additional fields.

DATA: matnr like mara-matnr, budat LIKE mkpf-budat.
SELECT max( budat ) mara~matnr
FROM mara left join mseg on mara~matnr = mseg~matnr join mkpf on
mkpf~mblnr = mseg~mblnr
INTO (budat, matnr)
Group BY mara~MATNR.
move matnr to matno.
move budat to maxdate.
ENDSELECT.

__.____._