I_BKACCTBSCDTAFORKEYVALUE

CDS View

Bank Account Basic Data For Key Value

I_BKACCTBSCDTAFORKEYVALUE is a CDS View in S/4HANA. Bank Account Basic Data For Key Value. It contains 22 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 22 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_BankAccountNumberVH_F1366A view_entity from CONSUMPTION Bank Account Number
I_BankAcctIdVH view from COMPOSITE Bank Account ID value help
I_BankAcctNumberVH view from COMPOSITE Account Number
I_BkAcctIntIDVH view from COMPOSITE Technical ID

Fields (22)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 4
KEY BankAccountNumber BankAccountNumber 4
_CompanyCode _CompanyCode 1
Bank Bank 4
BankAccountCurrency BankAccountCurrency 4
BankAccountDescription BankAccountDescription 4
BankAccountStatus BankAccountStatus 1
BankAccountType BankAccountType 4
BankControlKey BankControlKey 1
BankCountry BankCountry 4
CashToleranceGroup CashToleranceGroup 1
CompanyCode CompanyCode 4
IBAN IBAN 3
IntradayIsReconciled IntradayIsReconciled 1
LeadingCashPoolID LeadingCashPoolID 1
LeadingPaymentMethod LeadingPaymentMethod 1
MaxTargetAmount MaxTargetAmount 1
ParticipantCashPoolID ParticipantCashPoolID 1
ParticipantPaymentMethod ParticipantPaymentMethod 1
ProfitCenter ProfitCenter 1
Segment Segment 1
SWIFTCode SWIFTCode 3 
@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