topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Sat, 03 Nov 2007 10:46:42 GMT

Hi,

Is there any problem in this select statement, it is not returning data, though i have data in MARD table for material and respective plant. also checked the date field DLINL field is empty. I am using SAP 4.6c version.

SELECT * FROM MARD APPENDING TABLE TMARD

WHERE MATNR IN MS_MATNR

AND WERKS IN MS_WERKS

AND LGORT IN MS_LGORT

and dlinl = ' '.

Regards,

Shan

Re: SELECT STATEMENT

Former Member — Sat, 03 Nov 2007 11:08:11 GMT

try this

SELECT * FROM MARD APPENDING TABLE TMARD

WHERE MATNR IN MS_MATNR

AND WERKS IN MS_WERKS

AND LGORT IN MS_LGORT

and dlinl eq '00000000'.

regards

shiba dutta

Re: SELECT STATEMENT

Former Member — Sat, 03 Nov 2007 11:14:33 GMT

initial value for date is '00000000'

try to use this value in ur select statement for the date filter

regards

Re: SELECT STATEMENT

Former Member — Sat, 03 Nov 2007 11:20:47 GMT

thanks