I_BANKACCOUNTSIGNATORYPATTERN

CDS View

Bank Account with Signatory Pattern

I_BANKACCOUNTSIGNATORYPATTERN is a CDS View in S/4HANA. Bank Account with Signatory Pattern. It contains 19 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 19 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_BankAccountSignatory view from COMPOSITE API for Bank Account Signatory
A_BankAccountSignatoryFX view from COMPOSITE Signatory API with Currency Conversion

Fields (19)

KeyField CDS FieldsUsed in Views
KEY BankAccountNumber BankAccount 1
KEY BankCountry BankCountry 2
KEY BankNumber BankNumber 2
KEY IBAN IBAN 2
ApprovalType ApprovalType 2
BankAccountCurrency BankAccountCurrency 2
BankAccountHolderName BankAccountHolderName 2
BankAccountInternalID BankAccountInternalID 2
BankAccountType BankAccountType 2
BankName BankName 2
BICNumber BICNumber 2
BusinessArea BusinessArea 2
CompanyCode CompanyCode 2
CompanyCodeName CompanyCodeName 2
ControllingArea ControllingArea 2
ProfitCenter ProfitCenter 2
ReleaseProcedure ReleaseProcedure 2
Segment Segment 2
SignatoryPattern SignatoryPattern 2 
@AbapCatalog.sqlViewName: 'IBKACCSIGPTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED  
@EndUserText.label: 'Bank Account with Signatory Pattern'
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
// This view is obsolete. It's only used in API for central payment management, which was deprected in CE2002

define view I_BankAccountSignatoryPattern as select from I_BankAccount
//left outer join FCLM_BAM_ACC_SIGPATTERN_TF as SignatoryPattern on Account.BankAccountInternalID = SignatoryPattern.BankAccountInternalID

//left outer join I_Bank as Bank on Account.BankCountry = Bank.BankCountry and Account.Bank = Bank.BankInternalID

//association [0..1] to I_CompanyCode as _CompanyCode on CompanyCode = _CompanyCode.CompanyCode

//association [0..1] to I_Country                  as _BankCountry              on  $projection.BankCountry = _BankCountry.Country

//association [0..1] to I_BusinessArea             as _BusinessArea                on  $projection.BusinessArea = _BusinessArea.BusinessArea

//association [0..*] to I_ProfitCenter             as _ProfitCenter                on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter

                                                                                 //and $projection.ControllingArea = _ProfitCenter.ControllingArea

//association [0..1] to I_ControllingArea          as _ControllingArea             on  $projection.ControllingArea = _ControllingArea.ControllingArea

//association [0..1] to I_Segment                  as _Segment                  on  $projection.Segment = _Segment.Segment                                                                                 

{
    key cast( BankAccountInternalID as fclm_bam_acc_num ) as BankAccountNumber,
    key IBAN,
    key BankCountry,
    key Bank as BankNumber,
    cast( '1234567890' as fclm_bam_acc_id ) as BankAccountInternalID,
    cast( 'EUR' as waers_curc ) as BankAccountCurrency,
    cast( '0001' as bukrs ) as CompanyCode,
    cast( '' as prctr ) as ProfitCenter,
    cast( '' as fb_segment) as Segment,
    cast( '' as gsber ) as BusinessArea,
    cast( '01' as fclm_bam_bk_acc_type_id ) as BankAccountType,
    cast( '' as kokrs ) as ControllingArea,
    cast( '' as butxt ) as CompanyCodeName,
    cast( '' as fclm_bam_beneficiary_name ) as BankAccountHolderName,    
    cast( '' as swift ) as BICNumber,
    cast( '' as banka ) as BankName,    
    cast( '01' as text40 ) as ApprovalType,
    cast( '01' as fclm_bam_sign_pattern) as SignatoryPattern,
    cast( '01' as bca_dte_rel_proc) as ReleaseProcedure
    //_BankCountry,

    //_CompanyCode,

    //_ProfitCenter,

    //_Segment,

    //_BusinessArea,

    //_ControllingArea 

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

Learn More