I_BusinessPartnerBankTP_2

//@AbapCatalog.sqlViewName: 'IBUPABANKTP2'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Transactional View for BP bank details with RAP'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
//@ClientHandling.algorithm : #SESSION_VARIABLE

@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
define view entity I_BusinessPartnerBankTP_2
  as select from I_BusinessPartnerBank_2 as BusinessPartnerBank
  association        to parent I_BusinessPartnerTP_2 as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
//                                                                         and $projection.BPDrftUUID = _BusinessPartner.BPDrftUUID

  association [0..1] to I_Country                    as _Country         on $projection.BankCountryKey = _Country.Country
{ 
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPBankDrftUUID,

  key BusinessPartner,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key BankIdentification,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      BankIdentification as BankIdnForEditValue,
      BankCountryKey,
      BankName,
      BankNumber,
      SWIFTCode,
      BankControlKey,
      BankAccountHolderName,
      BankAccountName,
      @Semantics.businessDate.from: true
      case when ValidityStartDate != 00010101000000
      then tstmp_to_dats(ValidityStartDate,'UTC',  $session.client, 'NULL')
      else cast ( '00010103' as abap.dats )
      end as BankValidityStartDate,
      @Semantics.businessDate.to: true
      case when ValidityEndDate != 00010101000000
      then tstmp_to_dats(ValidityEndDate,'UTC',  $session.client, 'NULL')
      else cast ( '99991231' as abap.dats)
      end as BankValidityEndDate,
      IBAN,
      IBANValidityStartDate,
      BankAccount,
      BankAccountReferenceText,
      CollectionAuthInd,
      BusinessPartnerExternalBankID,
      BPBankDetailsChangeDate,
      BPBankDetailsChangeTargetID,
      BPBankIsProtected,
      CityName,
      AuthorizationGroup,
      cast( 'X' as sdraft_is_active preserving type )   as  BPHasActiveEntity,
      _BusinessPartner.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataControllerSet              as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController1                as DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController2                as DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController3                as DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController4                as DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController5                as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController6                as DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController7                as DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController8                as DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController9                as DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.DataController10               as DataController10,
      _Bank,
      _BusinessPartner,
      _IBAN,
      _Country
//      _BPDataControllerUsage

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERBANK_2",
"I_BUSINESSPARTNERTP_2"
],
"ASSOCIATED":
[
"I_BANKFORBUSINESSPARTNER",
"I_BUSINESSPARTNERIBAN",
"I_BUSINESSPARTNERTP_2",
"I_COUNTRY"
],
"BASE":
[
"I_BUSINESSPARTNERBANK_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/