P_MAKEBANKTRANSFERTEMPLATE

@AbapCatalog.sqlViewName: 'PMBKWITHTMPL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC 
@ObjectModel.representativeKey: 'RepetitiveCodeFlowID'
@VDM.private: true
define view P_MakeBankTransferTemplate as select from fibl_rpcode as a
  
  
  left outer join fibl_rpcode_tdef            as _rpcodetext                  on a.bukrs  = _rpcodetext.bukrs
                                                                              and a.hbkid = _rpcodetext.hbkid
                                                                              and a.rpcode = _rpcodetext.rpcode
                                                                              
//  association [1..1] to I_CompanyCode                 as _PayingCompanyCode           on  $projection.PayingCompanyCode = _PayingCompanyCode.CompanyCode

//  

//  

//  association [1..1] to I_Housebank                   as _HouseBank                   on  $projection.PayingHouseBank   = _HouseBank.HouseBank

//                                                                                      and $projection.PayingCompanyCode = _HouseBank.CompanyCode



{
    key concat(concat(a.rpcode,a.bukrs),a.hbkid) as RepetitiveCodeFlowID,
    a.rpcode as RepetitiveCode,
//    @ObjectModel.foreignKey.association: '_PayingCompanyCode' 

    a.bukrs  as PayingCompanyCode,
//    @ObjectModel.foreignKey.association: '_HouseBank' 

//    a.hbkid  as HouseBank,

    a.hbkid  as PayingHouseBank,
//    a.hktid      as PayingBankAccID,

    a.hktid      as PayingHouseBankAccount,
    a.pbukr      as PayeeCompanyCode,
//housebank & payeehousebank indicates payeehousebank    

    cast(a.partn as fclm_bam_aclink_hbkid )    as HouseBank,
    a.partn  as PayeeHouseBank,
//    a.parta      as TargetBankAccID,

    cast(a.parta as fclm_bam_aclink_hktid )     as HouseBankAccount,
    a.parta  as PayeeHouseBankAccount,
    cast(a.zlsch as char1)   as PaymentMethod,
    a.waers      as Currency,
    _rpcodetext.rp_text as RepetitiveCodeReferenceText, 
//    a.banks      as PayingBankCountry,

    a.banks      as BankCountry,
//    a.bankl      as PayingBankKey,

    a.bankl      as PayingBankKey,
//    a.bankn      as PayingBankAccNum,

    a.bankn      as PayeeBankAccount,
    a.ptype      as RepetitiveCodeCategory,
    a.dcrea      as CreationDate,
    a.ucrea      as CreationUserName,
    a.drele      as LastChangeDate,
    a.urele      as LastChangeByUserName
    
    
//    _PayingCompanyCode,

//    _HouseBank



    
}

where ptype = '03'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FIBL_RPCODE",
"FIBL_RPCODE_TDEF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/