topic Re: help in ECC6.0 in Application Development and Automation Discussions

help in ECC6.0

Former Member — Thu, 21 Jun 2007 14:31:38 GMT

Dear all,

I am using following select stmt in 4.0B, It is working fine, When I use same Select stmt in ECC6.0, I am getting error.

SELECT MATNR WERKS SUM( LABST ) FROM MARD INTO TABLE TMARD FOR ALL ENTRIES IN T_VBAP

WHERE MATNR = T_VBAP-MATNR

AND WERKS EQ T_VBAP-WERKS

AND LVORM EQ SPACE

AND LGORT NE 'ST02'

GROUP BY MATNR WERKS.

Can any one help me.

Thanks,

Re: help in ECC6.0

Former Member — Thu, 21 Jun 2007 14:35:59 GMT

can you please explain what exactly the error message you are getting in ECC 6.0

Re: help in ECC6.0

Former Member — Thu, 21 Jun 2007 14:40:10 GMT

Hi,

This is the msg

The addition "FOR ALL ENTRIES" excludes all aggregate functions with the exception of "COUNT(*)" as the single element of the SELECT clause.

Thanks

Re: help in ECC6.0

Former Member — Thu, 21 Jun 2007 14:43:20 GMT

you cannot use aggregate functions like SUM along with FOR ALL ENTRIES even in 4.6 and you will get the following error message when you check in 4.6 or ECC 6.0:

The addition "FOR ALL ENTRIES" excludes all aggregate functions with the exception of "COUNT( * )".

Regards,

Raman.

Re: help in ECC6.0

Former Member — Thu, 21 Jun 2007 14:45:34 GMT

Use like this without SUM it will work:

SELECT MATNR WERKS FROM MARD INTO TABLE TMARD FOR ALL ENTRIES IN T_VBAP

WHERE MATNR = T_VBAP-MATNR

AND WERKS EQ T_VBAP-WERKS

AND LVORM EQ SPACE

AND LGORT NE 'ST02'

GROUP BY MATNR WERKS.

Regards,

Raman.

Re: help in ECC6.0

Former Member — Thu, 21 Jun 2007 14:46:20 GMT

Hi,

Thanks for reply,

Can you pls suggest me alternative Select stmt for that.

Thanks a lot.