A_BankAccountSignatoryDetails

DDL: A_BANKACCOUNTSIGNATORYDETAILS SQL: ABKACCSIGDTL Type: view COMPOSITE

Bank Account Signatory Details

A_BankAccountSignatoryDetails is a Composite CDS View that provides data about "Bank Account Signatory Details" in SAP S/4HANA.

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ABKACCSIGDTL view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Bank Account Signatory Details view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API 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 (15)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID
KEY Sequence
KEY Signatory
KEY SignatoryGroup
SignatoryPattern
SignatoryGroupName
Currency
BankAcctSignatoryStartDate
BankAcctSignatoryEndDate
MaximumPaymentAmount
MaximumPaymentBatchAmount
MinimumPaymentCurrency
MinimumPaymentAmt
MinimumPaymentBatchAmount
EmailAddress
@AbapCatalog.sqlViewName: 'ABKACCSIGDTL'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #REQUIRED  
@EndUserText.label: 'Bank Account Signatory Details'
@VDM:{
    viewType: #COMPOSITE,
    lifecycle.contract.type:#PUBLIC_REMOTE_API
}
@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory:   #L,
    dataClass:      #MASTER
  }
}
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AbapCatalog.compiler.compareFilter: true
// This view is obsolete. It's only used in API for central payment management, which was deprected in CE2002

define view A_BankAccountSignatoryDetails as select distinct from FCLM_BAM_ACC_SIG_TF as AccountSignatory
//left outer join I_UserContactCard as User on User.ContactCardID = AccountSignatory.Signatory

//left outer join I_BankAccountSignatoryGroup as SigGroup on AccountSignatory.SignatoryGroup = SigGroup.SignatoryGroup

{
    key cast( '0987654321' as fclm_bam_acc_id ) as BankAccountInternalID,
    key cast( '01' as fclm_bam_sequence ) as Sequence,
    key cast( 'A' as fclm_bam_signatory ) as Signatory,
    key cast( 'G01' as fclm_bam_sign_group_id ) as SignatoryGroup,  
    cast( 'G1' as fclm_bam_sign_pattern) as SignatoryPattern,
    cast( 'G01' as fclm_bam_description) as SignatoryGroupName,
    @Semantics.currencyCode:true
    cast( 'EUR' as waers ) as Currency,
    cast( '99991231' as fclm_bam_sign_valid_from ) as BankAcctSignatoryStartDate,
    cast( '99991231' as fclm_bam_sign_valid_to ) as BankAcctSignatoryEndDate,
    @Semantics.amount.currencyCode: 'Currency'
    cast( 0 as fclm_bam_single_pay_amount) as MaximumPaymentAmount, 
    @Semantics.amount.currencyCode: 'Currency'
    cast( 0 as fclm_bam_batch_pay_amount) as MaximumPaymentBatchAmount,
    @Semantics.currencyCode:true
    cast( 'EUR' as waers ) as MinimumPaymentCurrency,
    @Semantics.amount.currencyCode: 'MinimumPaymentCurrency'
    cast( 0 as fclm_bam_min_payamount ) as MinimumPaymentAmt,
    @Semantics.amount.currencyCode: 'MinimumPaymentCurrency'
    cast( 0 as fclm_bam_min_batchamount) as MinimumPaymentBatchAmount,
    cast( '' as contactcardemailaddress ) as EmailAddress    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/