#BRJAVA
Input
$Var0#Name:##$Norm
$Var1#Vorname:##$Norm
$Var2#Zeitraum von:#01.01.2007#$NORM_DATUM
$Var3#Zeitraum bis:#01.01.2009#$NORM_DATUM
SQL
Select distinct sba_vg_akz as AKZ,
bt.bt_name as Name,
bt.bt_vorname as Vorname,
bs.bs_name as Betriebsstätte,
sba_vg_kennz as KFZKennz,
sba_vg_erfdat=BR_DATUM as Erfassungsdatum,
sba_vg_manr as Mitarbeiter,
agkatde.txt1 as Status,
erfdat=BR_DATUM as Erfassungsdatum,
verstbetrag as Verstossbetrag,
betrag_euro as Betrag
from (((((((bt join sba_schaub on
sba_schaub.sb_fahrer = bt.bt_nr
and sba_schaub.gueltig_bis = 0)
join sba_zug on
sba_zug.sb_nr = sba_schaub.sb_nr
and sba_zug.gueltig_bis = 0)
join sba_vgkontroll on
sba_vgkontroll.gueltig_bis = 0
and (sba_vgkontroll.sba_vg_akz = sba_zug.akz
or sba_vgkontroll.sba_vg_akz = sba_zug.akz_zugeordnet)
and sba_vgkontroll.sba_vg_erfdat >= '$Var2'
and sba_vgkontroll.sba_vg_erfdat >= '$Var3')
left outer join agkatde on
agkatde.subid = 207
and agkatde.nr = sba_vgkontroll.sba_se
and agkatde.guelbis > 2000000000)
join bs on
sba_vgkontroll.sba_bs_nr = bs.bs_nr
and bs.gueltig_bis = 0)
left outer join sba_bg_gesamt on
sba_bg_gesamt.akz = sba_vgkontroll.sba_vg_akz
and sba_bg_gesamt.gueltig_bis = 0)
left outer join sba_dok on
sba_dok.akz = sba_vgkontroll.sba_vg_akz
and sba_dok.lfdnr = (select max(lfdnr)
from sba_dok
where sba_dok.akz = sba_vgkontroll.sba_vg_akz
#and sba_dok.betrag_euro > 0
))
where bt.bt_name_norm like '$Var0%'
and bt.bt_vorname_norm like '$Var1%'
and bt.gueltig_bis = 0
order by bt.bt_name
Report
Java
|
