Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

REPORTS

Former Member
0 Kudos

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 .

2 REPLIES 2

Former Member
0 Kudos

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
0 Kudos

SELECT

MATNR

ERNAM

ERSDA

FROM

MARA

INTO TABLE

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