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

Posted by Sap Land Tuesday 23 August 2011 21:47

Posted by mairymano (Software Engineer)
on Aug 24 at 12:49 AM

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.

---------------Original Message---------------
From: jahir hussain
Sent: Wednesday, August 24, 2011 12:33 AM
Subject: SAP Query for material master PRICE and GRN

Dear Aslam,

Select max(b~mblnr),a~budat,b~matnr
---
---
group by a~budat,b~matnr.

Now you can get date wise latest GRN if you don't want date wise don't
select budat in select statement and group by.

Best Regards
Jahir Hussain
Sap Techno Functional
Hero Motors Ltd.

__.____._