According to SAP documentation, constructor operator NEW supports table comprehensions via FOR. There are no hints of any limitations of table comprehensions in that section of the documentation. However, i discovered that NEW doesn't support GROUP BY in FOR expressions. That is, both VALUE and NEW should behave the same way for the same iteration expression. Nevertheless, NEW with GROUP BY showed a syntax error:
> Field "FOR" is unknown.
When i replaced NEW with VALUE, syntax error was gone. I prepared a demo code snippet which one can use for testing:
types: begin of ty_line_1,
key1 type i,
key2 type i,
cnt type i,
end of ty_line_1,
ty_lines_1 type standard table of ty_line_1 with empty key.
types: begin of ty_line_2,
key1 type i,
cnt type i,
end of ty_line_2,
ty_lines_2 type standard table of ty_line_2 with empty key.
data(src) = value ty_lines_1( ( key1 = 1 key2 = 1 cnt = 10 )
( key1 = 1 key2 = 2 cnt = 20 )
( key1 = 2 key2 = 100 cnt = 30 ) ).
data(aggr) = new ty_lines_2( for groups <g> of <l1> in src
group by ( id = <l1>-key1 sz = group size )
( key1 = <g>-id
cnt = reduce #( init total type i
for <l1_dtl> in group <g>
next total += <l1_dtl>-cnt ) ) ).
This snippet will give an error as specified above. If NEW is replaced with VALUE in line data(aggr) = new ty_lines_2(..., then syntax error will be gone, and the program will be activated.
Is this a bug, or is documentation simply not up to date? Would be great to hear from horst.keller.
Thanks.
Kind regards,
Vlad.
P.S. SAP_BASIS version is 7.56, system is S4HANA ON PREMISE 2021 FPS02.
