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

Equivalent Statement in ECC6.0

Former Member — Thu, 13 Sep 2007 04:42:37 GMT

Hi,

I want the equivalent statement of the following in ECC6.0.

SELECT MCOMP SUM( PSMNG ) INTO CORRESPONDING FIELDS OF

ITAB_NEW FROM (ITAB_SEL)

GROUP BY MCOMP.

ENDSELECT.

This statement is giving error in the new Version. Error is " Table ITAB_SEL " must have a character line type(data type C,N, D,T, or String)

Useful answer will be rewarded with points.

Re: Equivalent Statement in ECC6.0

former_member189059 — Thu, 13 Sep 2007 04:57:23 GMT

Hello,

Is the same code working in a previous version?

The error points to a missing / wrong declaration of the variable ITAB_SEL

make sure it is of CHAR type

Also, select.. endselect without any code in between doesn't make much sense

Re: Equivalent Statement in ECC6.0

Former Member — Thu, 13 Sep 2007 05:00:32 GMT

Yes,

the same code is working in the earlier Version.

Re: Equivalent Statement in ECC6.0

Former Member — Thu, 13 Sep 2007 05:08:06 GMT

Hi,

Make sure that (ITAB_SEL) contains the Database table name in CAPS.

Revert back .

Regards,

Naveen

Re: Equivalent Statement in ECC6.0

former_member189059 — Thu, 13 Sep 2007 05:12:28 GMT

okay, i'm guessing ITAB_SEL is an internal table and it contains some numeric fields

what you need to do, is to declare itab_sel with all character fields

depending on the way you are getting data into ITAB_SEL (since some FMs need a particular datatype), you may need to make another internal table with all character fields and use the MOVE-CORRESPONDING statement

then pass this NEW_ITAB_SEL to your select statement