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

Posted by Sap Land Tuesday 23 August 2011 21:29

Posted by jahir-hussain
on Aug 24 at 12:32 AM

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.

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

Hi All,

Is it better to raise this issue on this forum or not? But looking for
your support and answers.
I have developed a report through SAP Query for Material Master latest
price and latest GRN (doc number, qty, value, rate, date).
This report shows all GRN through Mara and MSEG but how to pick latest one GRN?

--

Best Regards,

Humaira Aslam Chughtai
SAP MM Consultant
ICI Paints, Pakistan

__.____._