FCLM_BAM_ACC_SIGNATORY_DETAILS

@AbapCatalog.sqlViewName: 'VFCLMBASIGDET'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED  
@EndUserText.label: 'Bank Account Signatory Details'
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
define view FCLM_BAM_ACC_SIGNATORY_DETAILS 
with parameters
    P_KeyDate: datum,
    P_Currency: waers,
    P_ExchangeRateType: kurst_curr
as select distinct from FCLM_BAM_ACC_SIG_TF as AccountSignatory
left outer join I_UserContactCard as User on User.ContactCardID = AccountSignatory.Signatory
left outer join I_BankAccountSignatoryGroup as SigGroup on AccountSignatory.SignatoryGroup = SigGroup.SignatoryGroup
{
    key AccountSignatory.BankAccountInternalID,
    key AccountSignatory.Sequence,
    key AccountSignatory.Signatory,
    key AccountSignatory.SignatoryGroup,  
    AccountSignatory.SignatoryPattern,
    SigGroup.SignatoryGroupName,
    @Semantics.currencyCode:true 
    :P_Currency as Currency,
    AccountSignatory.BankAcctSignatoryStartDate,
    AccountSignatory.BankAcctSignatoryEndDate,
    @Semantics.amount.currencyCode: 'Currency'
    currency_conversion( amount => AccountSignatory.MaximumPaymentAmount,
    source_currency => AccountSignatory.Currency,
    round => 'X',
    exchange_rate_type => :P_ExchangeRateType,
    target_currency => :P_Currency,
    exchange_rate_date => :P_KeyDate,
    error_handling => 'SET_TO_NULL' )
    as MaximumPaymentAmount,
    @Semantics.amount.currencyCode: 'Currency'
    currency_conversion( amount => AccountSignatory.MaximumPaymentBatchAmount,
    source_currency => AccountSignatory.Currency,
    round => 'X',
    exchange_rate_type => :P_ExchangeRateType,
    target_currency => :P_Currency,
    exchange_rate_date => :P_KeyDate,
    error_handling => 'SET_TO_NULL' )
    as MaximumPaymentBatchAmount,
    @Semantics.currencyCode:true
    :P_Currency as MinimumPaymentCurrency,
    @Semantics.amount.currencyCode: 'Currency'
    currency_conversion( amount => AccountSignatory.MinimumPaymentAmt,
    source_currency => AccountSignatory.MinimumPaymentCurrency,
    round => 'X',
    exchange_rate_type => :P_ExchangeRateType,
    target_currency => :P_Currency,
    exchange_rate_date => :P_KeyDate,
    error_handling => 'SET_TO_NULL' )
    as MinimumPaymentAmt,
    @Semantics.amount.currencyCode: 'Currency'
    currency_conversion( amount => AccountSignatory.MinimumPaymentBatchAmount,
    source_currency => AccountSignatory.MinimumPaymentCurrency,
    round => 'X',
    exchange_rate_type => :P_ExchangeRateType,
    target_currency => :P_Currency,
    exchange_rate_date => :P_KeyDate,
    error_handling => 'SET_TO_NULL' )
    as MinimumPaymentBatchAmount,
    User.EmailAddress    
}
where BankAcctSignatoryStartDate <= :P_KeyDate and BankAcctSignatoryEndDate >= :P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BANKACCOUNTSIGNATORYGROUP",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/