Help with doing SELECT sub query within the SET of an UPDATE statement

[Zoom]

Hello experts,

After doing some research, it appears as if it's possible to use a SELECT subquery in the SET of an UPDATE statement. I did find some examples and here is my code:

LOOP AT IT_DATA
UPDATE /BIC/AZDP_O0140
   SET /BIC/ZCOUNTER = (SELECT COUNT( DISTINCT MATERIAL )
                        FROM /BIC/AZDP_O0140
                        WHERE MATERIAL EQ IT_DATA-MATERIAL
                        GROUP BY MATERIAL).
ENDLOOP.

However when I click the "check" button it's saying the field (my entire select subquery) is unknown and neither in one of the specified tables or defined by a "DATA".

Do I have a syntax issue or is there another reason why it's not taking this as a valid statement?

Thanks for the help!

Best regards,
Zoom

[Portal]

Hi,

Do you still get the error if you remove the GROUP BY?

Regards,
Portal

[Golfi]

Hi Zoom,

I cannot find supporting documentation that subqueries are allowed in this spot. You can use a dynamic "(expr_syntax)", but this would contain syntax of the fields to be updated.
Also, is it correct that your UPDATE statement does not have a WHERE-condition, as you are updating all rows this way?

Regards,
Golfi