I_BkAcctBscDtaForKeyValue

DDL: I_BKACCTBSCDTAFORKEYVALUE SQL: IBKACCTBSCDTAKV Type: view BASIC Package: FCLM_BAM

Bank Account Basic Data For Key Value

I_BkAcctBscDtaForKeyValue is a Basic CDS View that provides data about "Bank Account Basic Data For Key Value" in SAP S/4HANA. It reads from 1 data source (fclm_bam_amd) and exposes 26 fields with key fields BankAccountInternalID, BankAccountRevision. It has 3 associations to related views. Part of development package FCLM_BAM.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
fclm_bam_amd _Amd from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Bank_2 _BankKey $projection.Bank = _BankKey.BankInternalID and $projection.BankCountry = _BankKey.BankCountry
[0..1] I_BankAccountTypeVH _BankAccountType $projection.BankAccountType = _BankAccountType.BankAccountType
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Bank Account Basic Data For Key Value view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IBKACCTBSCDTAKV view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID fclm_bam_amd acc_id
KEY BankAccountRevision fclm_bam_amd revision
BankAccountNumber fclm_bam_amd acc_num
BankAccountCurrency fclm_bam_amd waers
CompanyCode fclm_bam_amd bukrs
BankAccountType fclm_bam_amd acc_type_id
Bank fclm_bam_amd bankl
BankCountry fclm_bam_amd banks
IBAN fclm_bam_amd iban
BankAccountStatus fclm_bam_amd status
OpenNewBankAccountRequest fclm_bam_amd open_request_id
Segment fclm_bam_amd segment
ProfitCenter fclm_bam_amd prctr
LeadingCashPoolID fclm_bam_amd cash_pool_id
ParticipantCashPoolID fclm_bam_amd cash_pool_id_participant
MaxTargetAmount fclm_bam_amd cash_pool_target_amt_max
LeadingPaymentMethod fclm_bam_amd payment_method_l
ParticipantPaymentMethod fclm_bam_amd payment_method_p
CashToleranceGroup fclm_bam_amd tolerance_group
IntradayIsReconciled fclm_bam_amd reconcile_intraday
BankAccountDescription _Desc description
SWIFTCode _Bank swift
BankControlKey fclm_bam_amd control_key
_BankKey _BankKey
_BankAccountType _BankAccountType
_CompanyCode _CompanyCode 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory: #M,
                         dataClass: #MASTER }
@ObjectModel.supportedCapabilities:  [ #SQL_DATA_SOURCE,
                                       #CDS_MODELING_DATA_SOURCE,
                                       #CDS_MODELING_ASSOCIATION_TARGET ]                                    
@EndUserText.label: 'Bank Account Basic Data For Key Value'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IBKACCTBSCDTAKV'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_BkAcctBscDtaForKeyValue
  as select from fclm_bam_amd as _Amd
  
  left outer to one join fclm_bam_amd_t        as _Desc    on  _Amd.acc_id        =  _Desc.acc_id
                                                           and _Amd.revision      =  _Desc.revision
                                                           and _Desc.langu        = $session.system_language
                                                           and _Desc.deleted_flag <> 'X'
      
  left outer to one join bnka                  as _Bank    on  _Amd.banks         = _Bank.banks
                                                           and _Amd.bankl         = _Bank.bankl  
                                                                 
  association [0..1] to I_Bank_2            as _BankKey          on  $projection.Bank                  = _BankKey.BankInternalID
                                                                 and $projection.BankCountry           = _BankKey.BankCountry
                                                                 
  association [0..1] to I_BankAccountTypeVH as _BankAccountType  on  $projection.BankAccountType       = _BankAccountType.BankAccountType
  
  association [1..1] to I_CompanyCode       as _CompanyCode      on  $projection.CompanyCode           = _CompanyCode.CompanyCode
{
  key _Amd.acc_id                    as BankAccountInternalID,
  key _Amd.revision                  as BankAccountRevision,
      _Amd.acc_num                   as BankAccountNumber,
      _Amd.waers                     as BankAccountCurrency, 
      _Amd.bukrs                     as CompanyCode,
      _Amd.acc_type_id               as BankAccountType,
      _Amd.bankl                     as Bank,
      _Amd.banks                     as BankCountry,
      _Amd.iban                      as IBAN,
      _Amd.status                    as BankAccountStatus,
      _Amd.open_request_id           as OpenNewBankAccountRequest,
      _Amd.segment                   as Segment,                 
      _Amd.prctr                     as ProfitCenter,            
      _Amd.cash_pool_id              as LeadingCashPoolID,       
      _Amd.cash_pool_id_participant  as ParticipantCashPoolID,   
      _Amd.cash_pool_target_amt_max  as MaxTargetAmount,         
      _Amd.payment_method_l          as LeadingPaymentMethod,    
      _Amd.payment_method_p          as ParticipantPaymentMethod,
      _Amd.tolerance_group           as CashToleranceGroup,      
      _Amd.reconcile_intraday        as IntradayIsReconciled,
      _Desc.description              as BankAccountDescription,
      _Bank.swift                    as SWIFTCode,
      _Amd.control_key               as BankControlKey,
      _BankKey,
      _BankAccountType,
      _CompanyCode
}

Learn More