SAP Open Outbound Deliveries ABAP SELECT Generator (LIKP / LIPS)

REPORT zr_open_deliveries.

DATA: lv_plant  TYPE werks_d VALUE '1000',
      lv_vstel  TYPE vstel   VALUE '1000',
      lv_from   TYPE dats    VALUE '20261001',
      lv_to     TYPE dats    VALUE '20261031',
      lv_lfart  TYPE lfart   VALUE 'LF'.

SELECT likp~vbeln,
       likp~lfart,
       likp~vstel,
       likp~wadat,
       likp~kunnr,
       lips~posnr,
       lips~matnr,
       lips~lfimg,
       lips~vrkme,
       lips~werks
  FROM likp
  INNER JOIN lips ON lips~vbeln = likp~vbeln
  WHERE likp~lfart      = @lv_lfart
    AND likp~vstel      = @lv_vstel
    AND likp~wadat      BETWEEN @lv_from AND @lv_to
    AND likp~wadat_ist  = '00000000'
    AND lips~werks      = @lv_plant
  ORDER BY likp~wadat, likp~vbeln, lips~posnr
  INTO TABLE @DATA(lt_open)
  UP TO 5000 ROWS.

IF sy-subrc <> 0.
  WRITE: / 'No open deliveries found.'.
  RETURN.
ENDIF.

LOOP AT lt_open INTO DATA(ls_open).
  WRITE: / ls_open-vbeln, ls_open-posnr, ls_open-matnr, ls_open-lfimg, ls_open-vrkme, ls_open-wadat.
ENDLOOP.

* In S/4HANA, goods movement status WBSTK is also on LIKP (A = not yet processed).
* To restrict to unprocessed deliveries add this to the WHERE clause:
*   AND likp~wbstk = 'A'
* On ECC systems the status lives in VBUK-WBSTK, so join VBUK on VBELN instead.