I_BankAccSignatureTP

@AbapCatalog: {
    sqlViewName: 'IBANKACCSIGTP',
    compiler.compareFilter: true
}

@EndUserText.label: 'Bank Account Signature BO active and draft'

@VDM:{
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type:#SAP_INTERNAL_API
}

@ObjectModel: {
    writeDraftPersistence: 'BANKACCSIGWD',
    createEnabled: 'EXTERNAL_CALCULATION',
    updateEnabled: 'EXTERNAL_CALCULATION',
    deleteEnabled: 'EXTERNAL_CALCULATION',
    semanticKey: [ 'BankAccountInternalID' ],
    usageType: {
        sizeCategory: #M,
        serviceQuality: #C,
        dataClass: #MASTER
    }
}


@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.privilegedAssociations:  [ '_SignatoryFullName' ]

@AccessControl.authorizationCheck: #CHECK


@Metadata.allowExtensions: true
define view I_BankAccSignatureTP
  as select from fclm_bam_sig as AccountSig
  //    left outer join I_User       as _User on _User.UserID = AccountSig.bname

  // association [0..1] to I_User          as _User    on  $projection.SignatoryForEdit = _User.UserID

  association [1..1] to I_BankAccountTP   as _Account           on  $projection.BankAccountInternalID = _Account.BankAccountInternalID
                                                                and $projection.BankAccountRevision   = _Account.BankAccountRevision
  association [1..1] to I_UserContactCard as _SignatoryFullName on  $projection.SignatoryForEdit = _SignatoryFullName.ContactCardID
{
      @ObjectModel: {
        readOnly: true
      //        foreignKey.association: '_Account'

      }
  key AccountSig.acc_id                as BankAccountInternalID,

      @ObjectModel: {
        readOnly: true,
        foreignKey.association: null
      }
  key AccountSig.bname                 as Signatory,

      @ObjectModel: {
        readOnly: true
      }
  key AccountSig.valid_to              as ValidTo,
      //@ObjectModel: {

      //  enabled: 'EXTERNAL_CALCULATION',

      //   readOnly:  'EXTERNAL_CALCULATION',

      //   mandatory: 'EXTERNAL_CALCULATION'

      // }

      @ObjectModel: {
        readOnly: true
      }
  key AccountSig.revision              as BankAccountRevision,
      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      //    foreignKey.association: '_User'

      }
      AccountSig.bname                 as SignatoryForEdit,

      @ObjectModel.readOnly: true
      _SignatoryFullName.FullName      as SignatoryFullName,

      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.valid_to              as ValidToForEdit,

      @Semantics.currencyCode: true
      @ObjectModel:{
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.waers                 as Currency,

      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.valid_from            as ValidFrom,

      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.sign_group            as SignatoryGroup,

      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.pay_amount            as PaymentAmount,

      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
        readOnly:  'EXTERNAL_CALCULATION',
        mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.batch_amount          as PaymentBatchAmount,

      @ObjectModel: {
        enabled: 'EXTERNAL_CALCULATION',
       readOnly:  'EXTERNAL_CALCULATION',
       mandatory: 'EXTERNAL_CALCULATION'
      }
      AccountSig.approval_is_unlimited as PaymentApprovalIsUnlimited,

      //      _User.UserDescription   as UserDescription,

      case when AccountSig.valid_to >= $session.system_date and AccountSig.valid_from <= $session.system_date then 'X'
         else ' '
      end                              as IsValid,

      @Consumption: {
        hidden: true
      }
      deleted_flag                     as IsMarkedForDeletion,

      @ObjectModel: {
        association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
        }
      _Account,
      _SignatoryFullName
      //     _User

}
where
  deleted_flag <> 'X';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USERCONTACTCARD",
"FCLM_BAM_SIG"
],
"ASSOCIATED":
[
"I_BANKACCOUNTTP",
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/