topic Re: New Syntax for Loop in Application Development and Automation Discussions

New Syntax for Loop

former_member296235 — Wed, 17 Feb 2021 11:32:11 GMT

Hi team,

please let me know the new syntax for below code.

LOOP AT IT_BSID ASSIGNING FIELD-SYMBOL(<FS_BSID>).
IF <FS_BSID>-VBELN IS INITIAL.
<FS_BSID>-VBELN = <FS_BSID>-XBLNR.
ENDIF.
ENDLOOP.

Re: New Syntax for Loop

FredericGirod — Wed, 17 Feb 2021 12:29:50 GMT

What did you expect as "New syntax" ?

LOOP AT IT_BSID
     REFENCE INTO DATA(o_bsid_line).
  o_bsid_line->vbeln = COND #( WHEN o_bsid_line->vbeln IS INITIAL
                                 THEN o_bsid_line->xblnr
                                 ELSE o_bsid_line->vbleln ).
ENDLOOP.

Re: New Syntax for Loop

former_member296235 — Wed, 17 Feb 2021 12:34:11 GMT

Hi frdric.girod

am expecting with this new syntax

LT_BSID = VALUE #( FOR WA_BSID IN IT_BSID
* WHERE ( VBELN = WA_BSID-XBLNR ) ).

how to check vbeln is initial

don't want to use loop statement .

Re: New Syntax for Loop

Patrick_vN — Wed, 17 Feb 2021 12:43:56 GMT

Or something like this?

*   Return only the data where PROFIT_CENTER has been found
    [new_table] = VALUE #(  FOR data
                            IN [old_table]
                            WHERE ( profit_center IS NOT INITIAL )
                            ( document_date     = data-document_date
*                             ..
                            )
                         ).

Re: New Syntax for Loop

former_member296235 — Wed, 17 Feb 2021 12:53:47 GMT

Hi pvnierop

want results as mentioned below.

Re: New Syntax for Loop

Patrick_vN — Wed, 17 Feb 2021 13:04:05 GMT

Easiest would be to use COALESCE in the corresponding SQL statement in that case I think.

But I guess you could try something like this (see this blog for details on COND & SWITCH)

    [table] = VALUE #(  FOR data
                        IN [table]
                        (  vbeln = COND #( WHEN data-vbeln IS INITIAL THEN data-xblnr
                                           ELSE data-vbeln
                                         )
                          )
                     ).