amdp_3.abap

METHOD copy_to_ztables BY DATABASE PROCEDURE FOR HDB
                        LANGUAGE SQLSCRIPT USING
      cfin_accit zcfin_accit cfin_acchd zcfin_acchd // Table Names
      cfin_acccr zcfin_accfi zcfin_acccr cfin_accfi .
 
    lt_accit = APPLY_FILTER ( CFIN_ACCIT, :iv_where );
    lt_accit_z = SELECT * FROM :lt_accit where logsystem_sender = :iv_logsys
                                                            and bukrs = :iv_bukrs
                                                            and awtyp = :iv_awtyp;
    INSERT INTO zcfin_accit SELECT * FROM :lt_accit_z ;
 
 
    lt_guid  = SELECT acchd_guid FROM :lt_accit_z;
 
 
 
    lt_acchd = SELECT * FROM cfin_acchd WHERE acchd_guid IN ( Select acchd_guid FROM :lt_guid );
    INSERT INTO zcfin_acchd  SELECT * FROM :lt_acchd ;
    lt_acccr = SELECT * FROM cfin_acccr WHERE acchd_guid IN ( SELECT acchd_guid FROM :lt_guid ) ;
    INSERT INTO zcfin_acccr  SELECT * FROM :lt_acccr ;
    lt_accfi = SELECT * FROM cfin_accfi WHERE acchd_guid IN ( SELECT acchd_guid FROM :lt_guid );
    INSERT INTO zcfin_accfi  SELECT * FROM :lt_accfi ; 
ENDMETHOD.