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

Posted by Sap Land Wednesday 24 August 2011 02:04

Posted by mack007 (SAP business analyst)
on Aug 24 at 5:09 AM

Hi

I assume you are using std query writer SQVi and then you joined tables. If
this is so, you will have to sort the list according to latest GRN date to
get the info you require.

Thanks
Mack

---------------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.

__.____._