Equivalent Statement in ECC6.0

[Former Member]

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.

[former_member189059]

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

[Former Member]

Yes,

the same code is working in the earlier Version.

[Former Member]

Hi,

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

Revert back .

Regards,

Naveen

[former_member189059]

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