Thursday, April 25, 2013

VBRP, KONV, VBRK tables selection UP TO 5 ROWS program

REPORT  ZBSD_ZAR_52023.
TABLES: VBRP, KONV, VBRK.

DATA: it TYPE VBRP.
DATA: it1 TYPE KONV.
DATA: it2 TYPE VBRK.

SELECT MATNR VRKME NETWR FKIMG
  FROM VBRP
  INTO (IT-MATNR, IT-VRKME, IT-NETWR, IT-FKIMG) UP TO 5 ROWS.
  WRITE: / it-matnr, it-vrkme, it-netwr.
ENDSELECT.

SELECT KBETR
  FROM KONV
  INTO (IT1-KBETR) UP TO 5 ROWS.
  WRITE: / it1-KBETR.
  ENDSELECT.

  SELECT VBELN FKDAT
    FROM VBRK
    INTO (IT2-VBELN, IT2-FKDAT) UP TO 5 ROWS.
    WRITE: / IT2-VBELN, IT2-FKDAT.
    ENDSELECT.

output-


No comments:

Post a Comment