I_BankRecnclnAccount

DDL: I_BANKRECNCLNACCOUNT SQL: IBNKRECNACCT Type: view BASIC Package: FINS_FIS_FICO

Bank Reconciliation Account

I_BankRecnclnAccount is a Basic CDS View that provides data about "Bank Reconciliation Account" in SAP S/4HANA. It reads from 1 data source (ska1) and exposes 4 fields with key fields ChartOfAccounts, BankReconciliationAccount. It has 2 associations to related views. Part of development package FINS_FIS_FICO.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
ska1 ska1 from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..*] I_GLAccountText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.BankReconciliationAccount = _Text.GLAccount

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBNKRECNACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Bank Reconciliation Account view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey BankReconciliationAccount view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ktopl
KEY BankReconciliationAccount saknr
_Text _Text
_ChartOfAccounts _ChartOfAccounts 
@AbapCatalog.sqlViewName: 'IBNKRECNACCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Bank Reconciliation Account'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'BankReconciliationAccount'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #B
define view I_BankRecnclnAccount
  as select from ska1 
  association [1]    to I_ChartOfAccounts       as _ChartOfAccounts     on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [0..*] to I_GLAccountText         as _Text                on  $projection.ChartOfAccounts                 = _Text.ChartOfAccounts
                                                                        and $projection.BankReconciliationAccount       = _Text.GLAccount
{
  @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key ktopl as ChartOfAccounts,
  @ObjectModel.text.association: '_Text'
  key saknr as BankReconciliationAccount,
  _Text,
  _ChartOfAccounts
}
where
      glaccount_type  = 'C'
  and glaccount_subtype = 'B'

Learn More