A_BankAccountSignatory

DDL: A_BANKACCOUNTSIGNATORY SQL: ABKACCSIG Type: view COMPOSITE

API for Bank Account Signatory

A_BankAccountSignatory is a Composite CDS View that provides data about "API for Bank Account Signatory" in SAP S/4HANA. It reads from 1 data source (I_BankAccountSignatoryPattern) and exposes 20 fields with key fields BankAccount, IBAN, BankCountry, BankNumber. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BankAccountSignatoryPattern Account from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_BankAccountSignatoryDetails _Signatory $projection.BankAccountInternalID = _Signatory.BankAccountInternalID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ABKACCSIG view
EndUserText.label API for Bank Account Signatory view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BankAccount I_BankAccountSignatoryPattern BankAccountNumber
KEY IBAN I_BankAccountSignatoryPattern IBAN
KEY BankCountry I_BankAccountSignatoryPattern BankCountry
KEY BankNumber I_BankAccountSignatoryPattern BankNumber
BankAccountCurrency I_BankAccountSignatoryPattern BankAccountCurrency
CompanyCode I_BankAccountSignatoryPattern CompanyCode
CompanyCodeName I_BankAccountSignatoryPattern CompanyCodeName
BankAccountHolderName I_BankAccountSignatoryPattern BankAccountHolderName
BankAccountInternalID I_BankAccountSignatoryPattern BankAccountInternalID
BankName I_BankAccountSignatoryPattern BankName
ProfitCenter I_BankAccountSignatoryPattern ProfitCenter
Segment I_BankAccountSignatoryPattern Segment
BusinessArea I_BankAccountSignatoryPattern BusinessArea
BankAccountType I_BankAccountSignatoryPattern BankAccountType
ControllingArea I_BankAccountSignatoryPattern ControllingArea
BICNumber I_BankAccountSignatoryPattern BICNumber
ApprovalType I_BankAccountSignatoryPattern ApprovalType
ReleaseProcedure I_BankAccountSignatoryPattern ReleaseProcedure
SignatoryPattern I_BankAccountSignatoryPattern SignatoryPattern
_Signatory _Signatory 
@AbapCatalog.sqlViewName: 'ABKACCSIG'
@EndUserText.label: 'API for Bank Account Signatory'
@VDM:{
    viewType: #COMPOSITE,
    lifecycle.contract.type:#PUBLIC_REMOTE_API
}

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED  
@AccessControl.privilegedAssociations: ['_Signatory']
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
// This API is never published to customer. It's only used in central payment management.

// But CPM was deprected in CE2002. This API is obsolete too.

define view A_BankAccountSignatory 
as select from I_BankAccountSignatoryPattern as Account
association [0..*] to A_BankAccountSignatoryDetails as _Signatory on $projection.BankAccountInternalID = _Signatory.BankAccountInternalID

{
    key Account.BankAccountNumber as BankAccount,
    key Account.IBAN,
    key Account.BankCountry,
    key Account.BankNumber,
    Account.BankAccountCurrency,
    Account.CompanyCode,
    Account.CompanyCodeName,
    Account.BankAccountHolderName,
    Account.BankAccountInternalID,
    Account.BankName,
    Account.ProfitCenter,
    Account.Segment,
    Account.BusinessArea,
    Account.BankAccountType,
    Account.ControllingArea,    
    Account.BICNumber,
    Account.ApprovalType,
    Account.ReleaseProcedure,
    Account.SignatoryPattern,
    
    _Signatory
}
where Account.BankAccountInternalID = '0000000001'

Learn More