A_BankAccountSignatoryFX

@AbapCatalog.sqlViewName: 'ABKACCSIGFX'
@EndUserText.label: 'Signatory API with Currency Conversion'
@VDM:{
    viewType: #COMPOSITE,
    lifecycle.contract.type:#PUBLIC_REMOTE_API
}

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED  
@AccessControl.privilegedAssociations: ['_Signatory']
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
define view A_BankAccountSignatoryFX
with parameters
P_KeyDate: datum,
P_Currency: waers,
P_ExchangeRateType: kurst_curr  
as select from I_BankAccountSignatoryPattern as Account
association [0..*] to A_BankAccountSignatoryDetails
 as _Signatory on $projection.BankAccountInternalID = _Signatory.BankAccountInternalID

{
    key cast( substring(Account.BankAccountNumber, 1, 18) as bankn ) as BankAccount,
    key Account.IBAN,
    key Account.BankCountry,
    key Account.BankNumber,
    Account.BankAccountCurrency,
    Account.CompanyCode,
    Account.CompanyCodeName,
    Account.BankAccountHolderName,
    Account.BankAccountInternalID,
    Account.BankName,
    Account.ProfitCenter,
    Account.Segment,
    Account.BusinessArea,
    Account.BankAccountType,
    Account.ControllingArea,    
    Account.BICNumber,
    Account.ApprovalType,
    Account.ReleaseProcedure,
    Account.SignatoryPattern,
    
    _Signatory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNTSIGNATORYPATTERN"
],
"ASSOCIATED":
[
"A_BANKACCOUNTSIGNATORYDETAILS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/