SELECT STATEMENT

[Former Member]

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

[Former Member]

initial value for date is '00000000'

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

regards

[Former Member]

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

[Former Member]

initial value for date is '00000000'

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

regards

[Former Member]

thanks