I_BusinessPartnerBankTP

@AbapCatalog.sqlViewName: 'IBUPABANKTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Association View for bank details'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true
@ObjectModel.writeDraftPersistence: 'BUPA_BANK_D' 
@ObjectModel.semanticKey: [ 'BankIdentification', 'BusinessPartner' ]
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@Search.searchable: true



@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_BusinessPartnerBankTP

  as select from I_BusinessPartnerBank as BusinessPartnerBank
  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  ////  association [0..1] to I_DraftAdministrativeData as _DraftAdministrativeData on  _DraftAdministrativeData.DraftUUID = $projection.DraftAdministrativeDataUUID


  ////  association [0..1] to i_businesspartnerbanktp   as _SiblingEntity           on  $projection.IsActiveEntity     <> _SiblingEntity.IsActiveEntity

  ////                                                                              and $projection.BusinessPartner    =  _SiblingEntity.BusinessPartner

  ////                                                                              and $projection.BankIdentification =  _SiblingEntity.BankIdentification



{

      //     @Consumption.hidden: true

      ////  key BusinessPartnerBank.DraftUUID,

      //   @Consumption.hidden: true

  key BusinessPartnerBank.BankIdentification,
      // @Consumption.hidden: true

  key BusinessPartnerBank.BusinessPartner,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankIdentification                                                              as BankIdentificationForEdit,
      BusinessPartnerBank.BusinessPartner                                                                 as BusinessPartnerForEdit,
      ////      BusinessPartnerBank.ParentDraftUUID,


      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankCountryKey,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankName,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankNumber,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: true
      BusinessPartnerBank.SWIFTCode,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankControlKey,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccountHolderName,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccountName,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.IBAN,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.IBANValidityStartDate,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccount,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.BankAccountReferenceText,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.CollectionAuthInd,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast(
      case
          when BusinessPartnerBank.IBAN is null
          then ''
          else 'X'
      end  as boole_d)                                                                                    as AutoIBAN,
      
      @ObjectModel.readOnly: true
      BusinessPartnerBank.BPBankIsProtected,


      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      //cast(substring (cast(BusinessPartnerBank.ValidityStartDate as abap.char(32)),1,8) as abap.dats)     as BankValidityStartDate,

      tstmp_to_dats(BusinessPartnerBank.ValidityStartDate,'UTC',  $session.client, 'NULL') as BankValidityStartDate,
      
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      //cast(substring (cast(BusinessPartnerBank.ValidityEndDate as abap.char(32)),1,8) as abap.dats)       as BankValidityEndDate,

      tstmp_to_dats(BusinessPartnerBank.ValidityEndDate,'UTC',  $session.client, 'NULL') as BankValidityEndDate,
      
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.ValidityStartDate,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      BusinessPartnerBank.ValidityEndDate,
      
      BusinessPartnerBank._BusinessPartnerBankAlias.PaymentSystem,
      
      BusinessPartnerBank._BusinessPartnerBankAlias.AliasType,
      
      BusinessPartnerBank._BusinessPartnerBankAlias.BPBankAccountAliasName,


      ////      BusinessPartnerBank.IsActiveEntity,

      ////      BusinessPartnerBank.HasActiveEntity,

      ////      BusinessPartnerBank.HasDraftEntity,


      //new

      ////      BusinessPartnerBank.DraftAdministrativeDataUUID,


      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
      _BusinessPartner
      ////      _DraftAdministrativeData,

      ////      _SiblingEntity

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERBANK",
"I_BUSINESSPARTNERBANKALIAS"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/