topic Re: select statment in Application Development and Automation Discussions

select statment

Former Member — Wed, 20 May 2009 12:43:32 GMT

Hi Guys,

I want to select the latest billing doc date .How do I use the order by clause and select single

in below select statment.Please guide

SELECT a~wadat_ist

INTO billing_dat

FROM likp AS a JOIN lips AS b

ON a_{vbeln EQ b}vbeln

WHERE a~kunag = iest0-customer

AND b~matnr = iest1-material.

Re: select statment

Former Member — Wed, 20 May 2009 12:52:07 GMT

Try using this;

SELECT SINGLE a~wadat_ist
INTO billing_dat
FROM likp AS a JOIN lips AS b
ON a~vbeln EQ b~vbeln
WHERE a~kunag = iest0-customer
AND b~matnr = iest1-material 
ORDER BY a~wadat descending.

Check and revert back....

Regards

Karthik D

Re: select statment

Former Member — Wed, 20 May 2009 13:27:38 GMT

Hai,

Try to use max keyword. I hope it may be useful to pick the latest record.

SELECT max(wadat_ist) FROM likp WHERE kunag = iest0-customer and matnr = iest1-material.

Regards,

Harish