    LEB_LANR
    LE_ARZTGRUPPE_QPA
    LE_ARZTGRUPPE_QP
    LE_ARZTGRUPPE_QPT
    
    LE_BTYPGOPS_QPT
    LE_BTYPGOPS_QP
    LE_BTYPGOPS_TP
    LE_BTYPGOPS_TPT

    LE_BTYPNR_QPT
    LE_BTYPNR_QP
    LE_BTYPNR_TPT
    LE_BTYPNR_TP

    LE_GOPKATALOG_QP
    LE_GOPKATALOG_QPT

    LE_HAUSFACHARZT_QP        
    LE_HAUSFACHARZT_QPT        

    LE_HGHUG_OP        
    LE_HGHUG_OPT
 
    LE_KBV_BARCODE_QP
    LE_KBV_BARCODE_QPT

    LE_LABORWB_INIT_QPA
    LE_OKZ_QP   
    LE_POSGOPS_QP

LE_RW_EIGENSCHAFT_QP
    LE_RW_IST_GP_OP

    LE_VPGP_QP  
    LE_VPGP_QPT       
     
    LE_ZB_GOP_QPT
    LE_ZB_GOP_QP


insert into LEB_LANR select * from kvai_rw_vdg_anb_20082..LEB_LANR
insert into LEB_ARZTPRAXIS select * from kvai_rw_vdg_anb_20082..LEB_ARZTPRAXIS

insert into LE_ARZTGRUPPE_QPA select * from kvai_rw_vdg_anb_20082..LE_ARZTGRUPPE_QPA
insert into LE_ARZTGRUPPE_QP select * from kvai_rw_vdg_anb_20082..LE_ARZTGRUPPE_QP
insert into LE_ARZTGRUPPE_QPT select * from kvai_rw_vdg_anb_20082..LE_ARZTGRUPPE_QPT

insert into LE_BTYPGOPS_QPT select * from kvai_rw_vdg_anb_20082..LE_BTYPGOPS_QPT
insert into LE_BTYPGOPS_QP select * from kvai_rw_vdg_anb_20082..LE_BTYPGOPS_QP
insert into LE_BTYPGOPS_TP select * from kvai_rw_vdg_anb_20082..LE_BTYPGOPS_TP
insert into LE_BTYPGOPS_TPT select * from kvai_rw_vdg_anb_20082..LE_BTYPGOPS_TPT

insert into LE_BTYPNR_QPT select * from kvai_rw_vdg_anb_20082..LE_BTYPNR_QPT
insert into LE_BTYPNR_QP select * from kvai_rw_vdg_anb_20082..LE_BTYPNR_QP
insert into LE_BTYPNR_TPT select * from kvai_rw_vdg_anb_20082..LE_BTYPNR_TPT
insert into LE_BTYPNR_TP select * from kvai_rw_vdg_anb_20082..LE_BTYPNR_TP

insert into LE_GOPKATALOG_QP select * from kvai_rw_vdg_anb_20082..LE_GOPKATALOG_QP
insert into LE_GOPKATALOG_QPT select * from kvai_rw_vdg_anb_20082..LE_GOPKATALOG_QPT

insert into LE_HAUSFACHARZT_QP select * from kvai_rw_vdg_anb_20082..LE_HAUSFACHARZT_QP
insert into LE_HAUSFACHARZT_QPT select * from kvai_rw_vdg_anb_20082..LE_HAUSFACHARZT_QPT

insert into LE_HGHUG_OP select * from kvai_rw_vdg_anb_20082..LE_HGHUG_OP
insert into LE_HGHUG_OPT select * from kvai_rw_vdg_anb_20082..LE_HGHUG_OPT

insert into LE_KBV_BARCODE_QP select * from kvai_rw_vdg_anb_20082..LE_KBV_BARCODE_QP
insert into LE_KBV_BARCODE_QPT select * from kvai_rw_vdg_anb_20082..LE_KBV_BARCODE_QPT

insert into LE_LABORWB_INIT_QPA select * from kvai_rw_vdg_anb_20082..LE_LABORWB_INIT_QPA
insert into LE_OKZ_QP select * from kvai_rw_vdg_anb_20082..LE_OKZ_QP
insert into LE_POSGOPS_QP select * from kvai_rw_vdg_anb_20082..LE_POSGOPS_QP

insert into LE_RW_EIGENSCHAFT_QP select * from kvai_rw_vdg_anb_20082..LE_RW_EIGENSCHAFT_QP

insert into LE_VPGP_QP select * from kvai_rw_vdg_anb_20082..LE_VPGP_QP
insert into LE_VPGP_QPT select * from kvai_rw_vdg_anb_20082..LE_VPGP_QPT

insert into LE_ZB_GOP_QPT select * from kvai_rw_vdg_anb_20082..LE_ZB_GOP_QPT
insert into LE_ZB_GOP_QP select * from kvai_rw_vdg_anb_20082..LE_ZB_GOP_QP

insert into LE_ANZ_AERZTE_OP select * from kvai_rw_vdg_anb_20082..LE_ANZ_AERZTE_OP


create view LE_RW_IST_GP_OP as 
Select 
        LE_ANZ_AERZTE_OP.PRAXIS_ID, 
        Case When Coalesce(ANZ_AERZTE, 0)>1 Then '1' Else '0' End As "IST_GP" 
    From 
        LE_ANZ_AERZTE_OP 
        Join 
            (Select PRAXIS_ID, 
                    Max(VORBELEGUNG) As "MAX_VORBELEGUNG" 
                From  LE_ANZ_AERZTE_OP 
                Group By  PRAXIS_ID 
            ) mv 
        On 
            LE_ANZ_AERZTE_OP.PRAXIS_ID = mv.PRAXIS_ID 
            And  LE_ANZ_AERZTE_OP.VORBELEGUNG = mv.MAX_VORBELEGUNG 


insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX
insert into XXX select * from kvai_rw_vdg_anb_20082..XXX

KS_ABME_FEHLER_PAKET           
KS_BEHANDLUNGSFALL             
KS_HONORAR_PAKET               
KS_KHF                         
KS_PH                          
KS_PH_BHF                      
KS_PH_SCHEIN                   
KS_PRAXIS_AUSSETZUNG           
KS_PRAXIS_FKXXXX               
KS_PRAXIS_KILOMETER            
KS_PRAXIS_PAKET                
KS_PRAXIS_REGEL_PROT           
KS_PRAXIS_SCHWIERIGKEIT        
KS_PRAXIS_ZUGRIFF              
KS_SCHEINKOPF                  
KS_SCHEINKOPF_A2PV             
KS_SCHEINKOPF_H                
KS_SK_DATENART                 
KS_SK_SCHWIERIGKEIT            
KS_TRENN_PROTOKOLL             
KS_VERG_FREQ_P                 
KS_VERG_FREQ_PT                
KS_VQ_KHF                      
KS_VQ_LEISTUNG                 
KS_VQ_LEIST_BEGRUEND           
KS_VQ_LEIST_OPS                
KS_VQ_PRAXIS_PAKET             
KS_VQ_SCHEINKOPF               

