SELECT to_date(dmbdbu,'YYYYMMDD')  DAT,dmbnr NR, dmbtl TL, LPAD(dmbmge||' '||dmb
sme,10) MG, dmbrm1 RM, dtlbn1||' '||dtlbn2 BEN, dtlpgr||'/'||dtlpfa GRP, dmblo L
O, dmbsva SVA, dmbvnr VNR, dmbsbm BA, dtlvkb VKB
FROM idmb,idtl
WHERE dmbtl = dtlnr
AND dmbdbu BETWEEN '&DMBDBU_VON' AND '&DMBDBU_BIS'
REM COND and dmbdbu >= &DMBDBU_VON
REM COND and dmbdbu <= &DMBDBU_BIS
REM COND and dtlvkb = '&DTLVKB'
REM COND and dmbsbm in (&DMBSBM)
REM COND and dmbtl = '&DMBTL'
REM COND and dtlpgr = UPPER('&DTLPGR')
REM COND and dtlpfa = UPPER('&DTLPFA')
ORDER BY dmbdbu,dmbnr