topic Re: REPORTS in Application Development and Automation Discussions

REPORTS

Former Member — Wed, 01 Aug 2007 08:46:21 GMT

hi all,

i want to utput like based on material creater name , we can display the material details lik no, des, of the particular date

i have writen like SELECT MATNR ERNAM ERSDA FROM MARA INTO TABLE IT_MARA WHERE ERNAM = P_ERNAM AND ERSDA = '2007.06.06' .

but it is not working am not getting the .

Former Member — Wed, 01 Aug 2007 08:48:21 GMT

Hi..,,

SELECT MATNR ERNAM ERSDA

FROM MARA

INTO TABLE IT_MARA

WHERE ERNAM = P_ERNAM

AND ERSDA = '20070606' .

Dots should not be there.. in between the date..

The internal storage format is YYYYMMDD.

Remove those dots and try...

regards,

sai ramesh

Former Member — Wed, 01 Aug 2007 08:48:58 GMT

SELECT

MATNR

ERNAM

ERSDA

FROM

MARA

INTO TABLE

IT_MARA WHERE ERNAM in ( P_ERNAM , '2007.06.06' ).