Schlagwort: WHERE

geschachtelter Select-Befehl

REPORT YZSM0005 . PARAMETERS: L_NR LIKE EKKO-IHREZ, L_ANT LIKE EKKO-LIFNR, MAT_NR LIKE EKPO-MATNR. TABLES: EKKO, EKPO. SELECT * FROM EKKO WHERE IHREZ = L_NR AND LIFNR = L_ANT. SELECT * FROM EKPO WHERE MATNR = MAT_NR AND EBELN = EKKO-EBELN.

Veröffentlicht in ABAP Getagged mit: , , , , , , , , , , , , ,

Select-Befehl

REPORT YZSM0002 . TABLES SBOOK. * write: / ‚carrid‘, ‚connid‘, ‚fldate‘, ‚bookid‘, ‚luggweight‘,’wunit‘. SELECT * FROM SBOOK WHERE CARRID EQ ‚LH‘ AND CONNID = 0400. WRITE: / SBOOK-CARRID, 10 SBOOK-CONNID, 20 SBOOK-FLDATE, 31 SBOOK-BOOKID, 43 SBOOK-LUGGWEIGHT DECIMALS 2 EXPONENT 5,

Veröffentlicht in ABAP Getagged mit: , , , , , , , , , , ,