I_BankAccountSignatoryPattern

@AbapCatalog.sqlViewName: 'IBKACCSIGPTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED  
@EndUserText.label: 'Bank Account with Signatory Pattern'
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
// This view is obsolete. It's only used in API for central payment management, which was deprected in CE2002

define view I_BankAccountSignatoryPattern as select from I_BankAccount
//left outer join FCLM_BAM_ACC_SIGPATTERN_TF as SignatoryPattern on Account.BankAccountInternalID = SignatoryPattern.BankAccountInternalID

//left outer join I_Bank as Bank on Account.BankCountry = Bank.BankCountry and Account.Bank = Bank.BankInternalID

//association [0..1] to I_CompanyCode as _CompanyCode on CompanyCode = _CompanyCode.CompanyCode

//association [0..1] to I_Country                  as _BankCountry              on  $projection.BankCountry = _BankCountry.Country

//association [0..1] to I_BusinessArea             as _BusinessArea                on  $projection.BusinessArea = _BusinessArea.BusinessArea

//association [0..*] to I_ProfitCenter             as _ProfitCenter                on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter

                                                                                 //and $projection.ControllingArea = _ProfitCenter.ControllingArea

//association [0..1] to I_ControllingArea          as _ControllingArea             on  $projection.ControllingArea = _ControllingArea.ControllingArea

//association [0..1] to I_Segment                  as _Segment                  on  $projection.Segment = _Segment.Segment                                                                                 

{
    key cast( BankAccountInternalID as fclm_bam_acc_num ) as BankAccountNumber,
    key IBAN,
    key BankCountry,
    key Bank as BankNumber,
    cast( '1234567890' as fclm_bam_acc_id ) as BankAccountInternalID,
    cast( 'EUR' as waers_curc ) as BankAccountCurrency,
    cast( '0001' as bukrs ) as CompanyCode,
    cast( '' as prctr ) as ProfitCenter,
    cast( '' as fb_segment) as Segment,
    cast( '' as gsber ) as BusinessArea,
    cast( '01' as fclm_bam_bk_acc_type_id ) as BankAccountType,
    cast( '' as kokrs ) as ControllingArea,
    cast( '' as butxt ) as CompanyCodeName,
    cast( '' as fclm_bam_beneficiary_name ) as BankAccountHolderName,    
    cast( '' as swift ) as BICNumber,
    cast( '' as banka ) as BankName,    
    cast( '01' as text40 ) as ApprovalType,
    cast( '01' as fclm_bam_sign_pattern) as SignatoryPattern,
    cast( '01' as bca_dte_rel_proc) as ReleaseProcedure
    //_BankCountry,

    //_CompanyCode,

    //_ProfitCenter,

    //_Segment,

    //_BusinessArea,

    //_ControllingArea 

}