REPORTS

[Former Member]

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]

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]

SELECT

MATNR

ERNAM

ERSDA

FROM

MARA

INTO TABLE

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