topic Select statement in Application Development and Automation Discussions

Select statement

Former Member — Sat, 14 Oct 2006 14:03:39 GMT

Hello,

I have a problem with a select statement. I don't really know how to write it.

I wrote it like this:

SELECT DISTINCT marc~matnr

FROM marc

JOIN mara ON marc_{matnr = mara}matnr

...

where marc~mmsta NOT IN ('01','02','03')

AND marc~mmstd >= sy-datum

The problem is on the last line. That field may be empty and, in that case, this select should return the corresponding records. But, as I wrote the select, it doesn't work. Any ideea?

Re: Select statement

RichHeilman — Sat, 14 Oct 2006 14:08:07 GMT

If you need the records, that the MMSTD is initial as well you can try this.

.....
where marc~mmsta NOT IN ('01','02','03')
   AND (  marc~mmstd = '00000000'
       or marc~mmstd >= sy-datum ).

Regards,

Rich Heilman

Re: Select statement

Former Member — Sat, 14 Oct 2006 14:12:32 GMT

Hi George,

You are checking the date in WHERE claus, so you have to pass the date..without that you wont get the result.

Still if you want the values eventhough you are passing date as empty. Then write separate select statement without where clause-Date checking.

if p_date is initial.

SELECT DISTINCT marc~matnr

FROM marc

JOIN mara ON marc_{matnr = mara}matnr.

where marc~mmsta NOT IN ('01','02','03')

else.

SELECT DISTINCT marc~matnr

FROM marc

JOIN mara ON marc_{matnr = mara}matnr

...

where marc~mmsta NOT IN ('01','02','03')

AND marc~mmstd >= p_date.

endif.

pls reward if it helps.

Thanks

Eswar